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

Content with tags Stored Procedures, T-SQL Rss

   Items 1 to 20 of 100    Older >>
 

Sending a Variable Number of Elements in a Parameter

What are your options for sending a variable number of choices in a parameter to a stored procedure? Alex Grinberg looks at three techniques you can use.  Read more...
By Alex Grinberg 2014/02/06 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,272 reads

The Zero to N Parameter Problem (Sql Server 2005 and Up -- Update)

This article uses XML to deal with optional parameters along with multiple parameter passed into a stored procedure. (Note: We are re-running this as we had a newsletter issue last week)  Read more...
By Sloan Holliday 2013/12/16 (first published: 2013/12/10) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,079 reads

The Zero to N Parameter Problem (Sql Server 2005 and Up -- Update)

This article uses XML to deal with optional parameters along with multiple parameter passed into a stored procedure. (Note: We are re-running this as we had a newsletter issue last week)  Read more...
By Sloan Holliday 2013/12/16 (first published: 2013/12/10) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,079 reads

Insert Update Stored Procedure for a table

Generic Script for Insert Update Stored Procedures  Read more...
By Prasad Bhogadi 2013/10/22 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 29,259 reads

Insert Update Stored Procedure for a table

Generic Script for Insert Update Stored Procedures  Read more...
By Prasad Bhogadi 2013/10/22 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 29,259 reads

SP

By Reema 2012/04/26 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,920 reads

Methods For Converting a Stored Procedure

An interesting use of T-SQL to run a stored procedure as part of a SELECT statement to get a result set to be used and combined with other tables. From Eli Leiba, learn how you can build a stored procedure into your queries.  Read more...
By Eli Leiba 2011/04/08 (first published: 2009/10/29) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 29,760 reads

Changing Text in Multiple Stored Procedures From a Stored Procedure

In this article Brian Davey present a solution for changing the text in multiple stored procedures using T-SQL.  Read more...
By Brian Davey 2011/03/28 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 9,333 reads

Stored Procedure Execution

By Jason Shadonix 2010/06/09 | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 4,026 reads

EXECute SQL Commands over entire sets of parameters!

A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.  Read more...
By RBarry Young 2010/03/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,709 reads

Synchronize several stored procedure between two servers

Synchronize source code between two servers for multiple stored procedures  Read more...
By Th Tr 2009/12/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,132 reads

Synchronize all stored procedures between two servers

This script will synchronize all stored procedures between two servers, using spSynchStoredProcedure.  Read more...
By Th Tr 2009/12/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,043 reads

Synchronize a stored procedure between two servers

Use this stored procedure to synchronize source code of a stored procedure between two servers.  Read more...
By Th Tr 2009/12/11 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,545 reads

Generate stored procedure parameter list based on table

Generate stored procedure parameter list based on table, useful when creating new SPs on tables with lots of columns.   Read more...
By Thomas Cournane 2009/12/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,616 reads

Auto-Execute Procs

By Taposh Dutta Roy 2009/11/16 | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 3,759 reads

Methods For Converting a Stored Procedure

An interesting use of T-SQL to run a stored procedure as part of a SELECT statement to get a result set to be used and combined with other tables. From Eli Leiba, learn how you can build a stored procedure into your queries.  Read more...
By Eli Leiba 2011/04/08 (first published: 2009/10/29) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 29,760 reads

The Ultimate Object Searcher

Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.  Read more...
By Jesse Roberge 2009/10/06 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,081 reads

Execute SQL Scripts in paralel for real performance tests

Ever tried to simulate a production environment in a development one but realized that you couldn't easily start 500 executions simultaneously ? This script will help you out.  Read more...
By Gustavo Maia 2009/09/30 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 1,825 reads

Stored procedure parameters

By gary.rumble 2009/08/10 | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 4,669 reads

Using Coalesce in a stored Procedure

A quick way to take a column of data and place it into a variable in a Stored Procedure in a comma, separated format.  Read more...
By Richard Spalding 2009/06/26 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 1,812 reads
   Items 1 to 20 of 100    Older >>
 
Tags
miscellaneous (20)    
programming (18)    
sql server 7 (16)    
administration (13)    
advanced querying (9)    
performance tuning (9)    
xml (8)    
ado (7)    
security (5)    
strategies (5)    
configuring (4)    
sql server 2005 (4)    
sql-dmo (4)    
triggers (4)    
visual basic 6 (4)    
dts (3)    
installation (3)    
linked server (3)    
backup / restore (2)    
database design (2)    
development (2)    
indexing (2)    
maintenance and management (2)    
monitoring (2)    
sql server 2008 (2)    
user defined function (udf) (2)    
xsl (2)    
::fn_listextendedproperty (1)    
asp (1)    
basics (1)    
best and worst practices (1)    
coalesce (1)    
columns (1)    
dba (1)    
distributed queries (1)    
dynamic sql (1)    
english query (1)    
find foreign key using sql (1)    
indexed views (1)    
insert update stored procedure generation (1)    
naming standards (1)    
openxml (1)    
palalelism (1)    
parameters (1)    
replication (1)    
schemas/dtds (1)    
search (1)    
semaphore (1)    
source control (1)    
sql puzzles (1)    
sql server 6.5 (1)    
sqlclr (1)    
stress test (1)    
syscolumns (1)    
sysobjects (1)    
system development life cycle (1)    
system tables (1)    
table field information (1)    
table metadata (1)    
tables (1)    
updategrams (1)    
user-defined data types (1)    
utility (1)    
worst practices (1)