SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Stored Procedures, T-SQL Rss

   Items 1 to 20 of 108    Older >>
 

Using Parameters for SQL Server Queries and Stored Procedures

One of the benefits of SQL is the ability to write a query and use parameters to dynamically act upon the resultset. Depending on the situation, there can be benefits to parameterizing queries, but it is not always clear when or how to do this. In this tip we look at different ways to pass in values as parameters to queries and the advantages and disadvantages.  Read more...
By Additional Articles 2018/07/05 | Source: MSSQLTips.com | Category: parameters
Rating: (not yet rated)  Rate this |   Briefcase | 3,414 reads

Stored procedure parameters

By Igor Micev 2017/03/30 | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 1,404 reads

EXECUTE as SELF

By Steve Jones 2017/01/18 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,195 reads

Stored Procedure Creation

By Robert Eder 2015/05/14 | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 1,968 reads

Signing options

By Steve Jones 2015/02/20 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,740 reads

Recompile in a stored procedure?

By Ben Kubicek 2015/02/17 | Category: recompile
Rating: (not yet rated) |  Discuss |   Briefcase | 1,903 reads

EXECUTE

By Steve Knox 2014/12/09 | Category: execute
Rating: (not yet rated) |  Discuss |   Briefcase | 1,981 reads

sp_rename and the procedure definition

By Lowell Izaguirre 2014/08/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,985 reads

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,574 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,194 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,194 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,517 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,517 reads

SP

By Reema 2012/04/26 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,001 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,851 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,398 reads

Stored Procedure Execution

By Jason Shadonix 2010/06/09 | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 4,087 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,851 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,194 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,097 reads
   Items 1 to 20 of 108    Older >>
 
Tags
miscellaneous (20)    
programming (18)    
sql server 7 (16)    
administration (13)    
advanced querying (9)    
performance tuning (9)    
xml (8)    
ado (7)    
security (7)    
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 and restore (2)    
database design (2)    
development (2)    
dynamic sql (2)    
indexing (2)    
maintenance and management (2)    
monitoring (2)    
parameters (2)    
sql server 2008 (2)    
user defined function (udf) (2)    
xsl (2)    
asp (1)    
basics (1)    
best and worst practices (1)    
coalesce() (1)    
columns (1)    
dba (1)    
distributed queries (1)    
english query (1)    
execute (1)    
find foreign key using sql (1)    
fn_listextendedproperty (1)    
indexed views (1)    
insert update stored procedure generation (1)    
naming standards (1)    
openxml (1)    
palalelism (1)    
recompile (1)    
replication (1)    
schemas+dtds (1)    
search (1)    
semaphore (1)    
source control (1)    
sp_rename (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)