SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Articles with tags T-SQL, Administration Rss

Refine your search with one of the following additional tags (with number of items):

SQL Server 2005 (2)    
Advanced Querying (1)    
SQL Server 2000 (1)    

Search for any content tagged T-SQL & Administration

   Items 1 to 3 of 3   
 

Finding and Listing ALL Procedures, Functions, and Views in SQL Server 2005

James Rea brings us another great article that shows you how to keep on top of the code that's stored in each of your databases.  Read more...
By James Rea 2008/07/28 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 1 read

Return Query Text Along With sp_who2 Using SQL 2000

This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".  Read more...
By Ken Simmons 2008/07/18 | Source: SQLServerCentral.com | Category: SQL Server 2000
Rating: |  Discuss |  Briefcase | 5,763 reads

Using the OUTPUT Clause to Capture Identity Values on Multi-Row Insert

SQL Server 2005 introducted the OUTPUT clause which we can use to capture values from the inserted and deleted virtual tables.  Read more...
By Additional Articles 2006/08/25 | Source: SQLTeam.com | Category: Advanced Querying
Rating:  Rate this |  Briefcase | 2,897 reads
   Items 1 to 3 of 3