Automatic Generation of Insert, Update and Delete stored procedures
This script automatically generates stored procedures for insert, update and delete operations on the given table
2009-08-12 (first published: 2009-07-23)
2,132 reads
This script automatically generates stored procedures for insert, update and delete operations on the given table
2009-08-12 (first published: 2009-07-23)
2,132 reads
Automates the creation of INSERT, UPDATE & DELETE stored procedure of a table
2010-07-09 (first published: 2009-07-23)
35,614 reads
This code will drop all stored procedures made with splog. With minor modification it will also drop all functions and sp not made with splog.
2009-03-13 (first published: 2009-02-12)
1,027 reads
Search for a text in all the stored Procedures in a Database
2013-01-04 (first published: 2009-01-14)
3,628 reads
2010-09-10 (first published: 2008-11-17)
32,987 reads
2008-10-23
1,438 reads
Longtime DBA David Poole brings us an interesting situation in involving setting up a user to allow Excel to query data from SQL Server.
2010-08-13 (first published: 2008-08-13)
61,083 reads
2008-07-17
345 reads
When searching meta-data to find an occurance of a particular string or pattern it is difficult to look everywhere. This procedure helps you find what you are looking for.
2008-05-28
8,640 reads
Some useful undocumented extended and stored procedures in SQL Server 2005
2009-11-20 (first published: 2008-05-09)
33,106 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...
Hi everyone. I have this table and this information. (left side of the image)...