2013-12-19 (first published: 2007-08-27)
20,673 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,657 reads
2008-09-09
1,068 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,254 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,140 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)
457 reads
Blogs
The Cost of Not Having a DBA
By Kevin3NF
Does skipping a DBA save money? Wait until your system grinds to a halt,...
Who are you? Building an identity map.
By Brian Kelley
I admit that until I read the article, Who are you as a Leader?,...
Call a Fabric REST API from Azure Data Factory
Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure...
Forums
How to update a history table with changes.
Good morning to all. I am a novice when it comes to SQL so...
How to check if credential password for TDE matches the secret key of Key Vault
Hi all, In my company we have many databases encrypted with TDE and there...
Create Raw Zone Tables using Generative AI: Data Engineering with Fabric
Comments posted to this topic are about the item Create Raw Zone Tables using...
Question of the Day
Replacing a NULL II
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL , @value2 VARCHAR(20) = NULL; SELECT COALESCE (@value, @value2, 100.5) AS Result; GOSee possible answers