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

Scripts with tag parameters Rss

Search for any content tagged parameters

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 5 of 5   

Hassle free parameters in dynamic SQL

An alternative solution to passing parameters to sp_executesql. 
Rating: |  Discuss |   Briefcase | 2,804 reads

Unused Input Parameters

Identify all objects containing unused input parameters. 
By Sean Smith 2014/10/09 | Source: | Category: unused
Rating: |  Discuss |   Briefcase | 2,342 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: | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,686 reads

Demonstration on how to pivot data using temp tables

This script was designed to 'pivot' data that couldnt easily be pivoted in any other way. i used temporary tables to eventually achieve the result i was looking for :)  Read more...
By Chris Morton 2008/10/10 | Source: | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 929 reads


use metadata to generate basic create procedure statements for insert update and select  Read more...
By Chris Morton 2008/11/21 | Source: | Category: metadata
Rating: |  Discuss |   Briefcase | 3,740 reads
   Items 1 to 5 of 5