2013-12-19 (first published: 2007-08-27)
20,770 reads
Deepthi Viswanathan Nair
Dynamic creation of Insert, Update, Delete Stored procedures
Automates the creation of INSERT, UPDATE & DELETE stored procedure of a table
2010-07-09 (first published: 2009-07-23)
35,678 reads
2008-09-09
1,069 reads
Get list of tables used in a stored procedure
It used to find the table dependencies, helps the developers during an enhancement stage to find the tables are used in a stored procedure.
2007-08-30 (first published: 2007-03-16)
3,270 reads
Generate Stored Procedure/Functions Script with SP
It will help to generate DBscript of Stored Procedure/User defined Functions in SQL server without selecting those thru Enterprise manager.Pass the name of Stored procedures/Functions as parameters to the sp_Generate_Script, it generates the scripts and displayed on screen. Choose text format for result display.
2007-03-23 (first published: 2007-03-14)
2,145 reads
List of stored procedures which refer a DB table
It used to find stored procedures where a DB has been used.
2007-03-22 (first published: 2007-03-16)
458 reads
Blogs
T-SQL Tuesday #188: Growing the Community
By Steve Jones
This month we have a great T-SQL Tuesday, hosted by John Sterrett. He has...
Unveiling the Legacy: POSTGRES to Modern Open-Source Powerhouse
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
Capturing errors and auditing in Azure SQL DB
Logging is a necessity in the database world, well, the entire tech world. You...
Forums
The Mindset of a Database Administrator: A Love Letter to Risk Aversion
Comments posted to this topic are about the item The Mindset of a Database...
Unmasking CXPACKET and CXCONSUMER in SQL Server: What Your Execution Plan Isn’t Telling You
Comments posted to this topic are about the item Unmasking CXPACKET and CXCONSUMER in...
how to move all SP from one db to another db?
Hi everyone I have two db - one is test and other is archive. ...
Question of the Day
Independence Day
The film independence day was released in 1996. Which of these queries returns that year is run today?
See possible answers