Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, System Development Life Cycle Rss

   Items 1 to 7 of 7   
 

Generating Insert Statements

This article from new author Oleg Netchaev describes the cursor-less script used to generate insert statements. This allows you to efficiently and easily add data generation statements to your project deployments.  Read more...
By Oleg Netchaev 2010/05/14 (first published: 2009/07/01) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 29,639 reads

Generating Insert Statements

This article from new author Oleg Netchaev describes the cursor-less script used to generate insert statements. This allows you to efficiently and easily add data generation statements to your project deployments.  Read more...
By Oleg Netchaev 2010/05/14 (first published: 2009/07/01) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 29,639 reads

The Baker's Dozen: 13 Productivity Tips for Transact-SQL 2005

SQL Server 2005 offers T-SQL language features that can improve your productivity.   Read more...
By Additional Articles 2007/11/07 | Source: DevX | Category: t-sql
Rating:  Rate this |   Briefcase | 4,566 reads

Build molecular queries from atoms in SQL Server

Every SQL Server developer has a preferred method of doing things; mine is what I call molecular queries. These are queries assembled from atomic queries; by which, I mean that they address exactly one table. By combing atoms, I can create molecules.   Read more...
By Additional Articles 2006/10/19 | Source: Builder.com | Category: advanced querying
Rating:  Rate this |   Briefcase | 3,544 reads

How To Find SQL Server Objects

SQL Server can grow to encompass hundreds of databases on a single server, each having hundreds or thousands of objects within it. A truly scalable RDBMS. However, how many times have you been searching through the Object Browser in QA or the left pane in Enterprise Manager searching for an object? New Author Ashish Kaushal gives us a method to easily search your server for that long lost object.   Read more...
By Ashish Kaushal 2004/08/17 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 16,243 reads

Making Good Use of Sysforeignkeys Table - Part 1: Display table relati

Sysforeignkeys is a valuable SQL Server resource. How many times have you had to "pick up the pieces" from a database developed by someone else and dropped on your desk? Ever get a database diagram with that? A data dictionary? Probably not too often. Jeffrey Yao has developed a system of finding those parent-child relationships automatically and displaying them so he can get up to speed quickly on these inherited databases. Read on to find out more.   Read more...
By Jeffrey Yao 2004/06/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,607 reads

Stored Procedure Development Cycle

This month Robert covers the process he uses for developing stored procedures. In many ways it reflects how software is developed, but it does have it's minor differences. This is a high level process discussion, not a line by line example of the entire process - by design of course.   Read more...
By Robert Marda 2003/09/03 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 10,628 reads
   Items 1 to 7 of 7   
 
Tags
strategies (4)    
advanced querying (3)    
administration (1)    
insert (1)    
sql server 7 (1)    
stored procedures (1)