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

Content with tag parameters Rss

   Items 1 to 8 of 8   
 

Hassle free parameters in dynamic sql.

An alternative solution to passing parameters to sp_executesql.  Read more...
Rating: |  Discuss |   Briefcase | 1,507 reads

Unused Input Parameters

Identify all objects containing unused input parameters.  Read more...
By Sean Smith 2014/02/26 | Source: SQLServerCentral.com | Category: unused
Rating: |  Discuss |   Briefcase | 1,579 reads

Variable Default Values to a Stored Procedure (SQL Spackle)

A way to assign variable and overrideable defaults to input parameters to an SP or FUNCTION using a configurations table.  Read more...
By Dwain Camps 2013/09/03 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 6,770 reads

Unused Input Parameters

Identify all objects containing unused input parameters.  Read more...
By Sean Smith 2014/02/26 | Source: SQLServerCentral.com | Category: unused
Rating: |  Discuss |   Briefcase | 1,579 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,643 reads

Using XML to pass and return values to procs

Tips on parsing and sculpting XML from within a SQL 2005 stored procedure  Read more...
By Steve McRoberts 2009/10/19 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 10,150 reads

AUTOGENERATE INSERT UPDATE SELECT STATEMENTS

use metadata to generate basic create procedure statements for insert update and select  Read more...
By Chris Morton 2008/11/21 | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 3,590 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: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 889 reads
   Items 1 to 8 of 8   
 
Tags
stored procedures (6)    
dynamic sql (2)    
autogenerate (1)    
chris morton (1)    
codrakon (1)    
execute (1)    
functions (1)    
input (1)    
insert (1)    
metadata (1)    
nested loop (1)    
parsing (1)    
pivot (1)    
report (1)    
select (1)    
sp_executesql (1)    
sql server 2005 (1)    
sql server 2008 (1)    
syscolumns (1)    
sysobjects (1)    
temporary tables (1)    
t-sql (1)    
unused (1)    
update (1)    
xml (1)