SQLServerCentral: Content tagged parameters

Unused Input Parameters

Identify all objects containing unused input parameters. Read more...

By Sean Smith 2012/12/19 | Source: SQLServerCentral.com | Category: unused

Rating:

|

Discuss |

Briefcase | 715 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,535 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 | 9,926 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,407 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 2013/05/25 | Source: SQLServerCentral.com | Category: dynamic sql

Rating:

|

Discuss |

Briefcase | 798 reads

Content with tag parameters

Unused Input Parameters

Generate stored procedure parameter list based on table

Using XML to pass and return values to procs

AUTOGENERATE INSERT UPDATE SELECT STATEMENTS

Demonstration on how to pivot data using temp tables