SQLServerCentral.com Scripts tagged parameters

Unused Input Parameters

Wed, 19 Dec 2012 07:00:00 UT

Identify all objects containing unused input parameters.

Generate stored procedure parameter list based on table

Fri, 04 Dec 2009 07:00:00 UT

Generate stored procedure parameter list based on table, useful when creating new SPs on tables with lots of columns.

Demonstration on how to pivot data using temp tables

Fri, 10 Oct 2008 14:10:52 UT

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 :)

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial.

AUTOGENERATE INSERT UPDATE SELECT STATEMENTS

Fri, 21 Nov 2008 07:00:00 UT

use metadata to generate basic create procedure statements for insert update and select