SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
Home Articles Editorials Forums Scripts Blogs QotD SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us
 

Content with tags Administration, T-SQL, SQL Server 2005 Rss

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

Maintenance (2)     T-SQL Aids (2)     sys.foreign_key_columns (1)    
Maintenance and Management (2)     Advanced Querying (1)     sys.foreign_keys (1)    
Search (2)     Search Stored PRocedures (1)     sys.sql_modules (1)    
   Items 1 to 3 of 3   
 

The Ultimate Precompiled Procedure Searcher

Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.  Read more...
By Jesse Roberge 2008/08/29 | Source: SQLServerCentral.com | Category: SQL Server 2005
Rating: (not yet rated) |  Discuss |  Briefcase | 100 reads

The Ultimate Foreign Key Researcher

Searches for actual and potential foreign key columns for a given primary key reference.  Read more...
By Jesse Roberge 2008/08/15 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 148 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,895 reads
   Items 1 to 3 of 3   
 
 
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use