SQLServerCentral: Content tagged Stored Procedures, T-SQL

Insert Update Stored Procedure for a table

Generic Script for Insert Update Stored Procedures Read more...

By Prasad Bhogadi 2012/09/05 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 27,490 reads

SP

By Reema 2012/04/26 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 2,875 reads

Methods For Converting a Stored Procedure

An interesting use of T-SQL to run a stored procedure as part of a SELECT statement to get a result set to be used and combined with other tables. From Eli Leiba, learn how you can build a stored procedure into your queries. Read more...

By Eli Leiba 2011/04/08 (first published: 2009/10/29) | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 29,657 reads

Changing Text in Multiple Stored Procedures From a Stored Procedure

In this article Brian Davey present a solution for changing the text in multiple stored procedures using T-SQL. Read more...

By Brian Davey 2011/03/28 | Source: SQLServerCentral.com | Category: stored procedures

Rating:

|

Discuss |

Briefcase | 9,275 reads

Stored Procedure Execution

By Jason Shadonix 2010/06/09 | Category: stored procedures

Rating: (not yet rated) |

Discuss |

Briefcase | 3,989 reads

EXECute SQL Commands over entire sets of parameters!

A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas. Read more...

By RBarry Young 2010/03/16 | Source: SQLServerCentral.com | Category: administration

Rating:

|

Discuss |

Briefcase | 2,635 reads

Synchronize several stored procedure between two servers

Synchronize source code between two servers for multiple stored procedures Read more...

By Th Tr 2009/12/21 | Source: SQLServerCentral.com | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 1,099 reads

Synchronize all stored procedures between two servers

This script will synchronize all stored procedures between two servers, using spSynchStoredProcedure. Read more...

By Th Tr 2009/12/15 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 2,001 reads

Synchronize a stored procedure between two servers

Use this stored procedure to synchronize source code of a stored procedure between two servers. Read more...

By Th Tr 2009/12/11 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,495 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,534 reads

Auto-Execute Procs

By Taposh Dutta Roy 2009/11/16 | Category: stored procedures

Rating: (not yet rated) |

Discuss |

Briefcase | 3,728 reads

Methods For Converting a Stored Procedure

An interesting use of T-SQL to run a stored procedure as part of a SELECT statement to get a result set to be used and combined with other tables. From Eli Leiba, learn how you can build a stored procedure into your queries. Read more...

By Eli Leiba 2011/04/08 (first published: 2009/10/29) | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 29,657 reads

The Ultimate Object Searcher

Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent. Read more...

By Jesse Roberge 2009/10/06 | Source: SQLServerCentral.com | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 1,048 reads

Execute SQL Scripts in paralel for real performance tests

Ever tried to simulate a production environment in a development one but realized that you couldn't easily start 500 executions simultaneously ? This script will help you out. Read more...

By Gustavo Maia 2009/09/30 | Source: SQLServerCentral.com | Category: development

Rating:

|

Discuss |

Briefcase | 1,754 reads

Stored procedure parameters

By gary.rumble 2009/08/10 | Category: stored procedures

Rating: (not yet rated) |

Discuss |

Briefcase | 4,636 reads

Using Coalesce in a stored Procedure

A quick way to take a column of data and place it into a variable in a Stored Procedure in a comma, separated format. Read more...

By Richard Spalding 2009/06/26 | Source: SQLServerCentral.com | Category: stored procedures

Rating:

|

Discuss |

Briefcase | 1,790 reads

Lightweight source control

Versioning for Stored Procs and view Read more...

By Jamie Ingram-729524 2009/04/22 | Source: SQLServerCentral.com | Category: source control

Rating:

|

Discuss |

Briefcase | 985 reads

Insert Update Stored Procedure for a table

Generic Script for Insert Update Stored Procedures Read more...

By Prasad Bhogadi 2012/09/05 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 27,490 reads

Find a Table's Metadata

Stored Procedure that returns table information Read more...

By Crosbie Christopher 2013/05/23 | Source: SQLServerCentral.com | Category: stored procedures

Rating:

|

Discuss |

Briefcase | 1,276 reads

Creating Functions for Stored Procedures

With the advent of so many new technologies in the Microsoft space, a DBA needs to learn more and more about many of them that aren't a part of SQL Server. Alex Grinberg brings us a technique he has used to create ADO functions for your stored procedures. Read more...

By Alex Grinberg 2008/10/10 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 13,157 reads

Content with tags Stored Procedures, T-SQL