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,785 reads

Unused Input Parameters

Identify all objects containing unused input parameters. 
By Sean Smith 2014/10/09 | Source: | Category: unused
Rating: |  Discuss |   Briefcase | 2,336 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,681 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 | 928 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,731 reads
   Items 1 to 5 of 5