stored (3,137)


Check for changes to an SQL Server table?

Check for changes to an SQL Server table?

How can I monitor an SQL Server database for changes to a table without using triggers or modifying the structure of the database in any way? My preferred programming environment is.NET and C#. I'd li…


What language do you use for PostgreSQL triggers and stored procedures?

PostgreSQL is interesting in that it supports several languages for writing stored procedures. Which one do you use, and why?…



Have you ever encountered a query that SQL Server could not execute because it referenced too many tables?

Have you ever seen any of there error messages?-- SQL Server 2000 Could not allocate ancillary table for view or function resolution. The maximum number of tables in a query(256) was exceeded.-…


What's the best way to determine if a temporary table exists in SQL Server?

When writing a T-SQL script that I plan on re-running, often times I use temporary tables to store temporary data. Since the temp table is created on the fly, I'd like to be able to drop that table…


python - Calling a function of a module by using its name(a string)

What is the best way to go about calling a function given a string with the function's name in a Python program. For example, let's say that I have a module foo,and I have a string whose content is "b…


sql - How to pass a comma separated list to a stored procedure?

So I have a Sybase stored proc that takes 1 parameter that's a comma separated list of strings and runs a query with in in an IN() clause: CREATE PROCEDURE getSomething @keyList varchar(4096) AS SELE…


Is there any list datatype in MySQL stored procedures, or a way to emulate them?

I would like to create a stored procedure in MySQL that took a list as argument. For example, say that I would like to be able to set multiple tags for an item in one call, then what I want to do is…


.net - How to return a page of results from SQL?

Many applications have grids that display data from a database table one page at a time. Many of them also let the user pick the number of records per page, sort by any column, and navigate back and…


Has anyone had any success in unit testing SQL stored procedures?

We’ve found that the unit tests we’ve written for our C#/C++ code have really paid off. But we still have thousands of lines of business logic in stored procedures, which only really get tested in a…


Insert Update stored proc on SQL Server

I've written a stored proc that will do an update if a record exists, otherwise it will do an insert. It looks something like this: update myTable set [email protected], [email protected] where [email protected] if @@rowcount…




procedure how sql server from example with query where are