script to create default stored procs

The following script will write basic update insert and delete stored procedures for a given table.It will add comments to the sp's with the autyhors name and also script a single grant statement for a given database user.I find this script extremely useful for both rad development and keeping consistency in my naming and structure […]

5 (2)

2006-04-21 (first published: )

526 reads

script to create default class in VB.NET

The following script creates a class to access the default stored procs created by a previous script I submitted called script to create default stored procs. Please note that this will only work correctly if the stored procs created by my earlier script (script to create default stored procedures) have been created. Have fun

2006-04-03 (first published: )

273 reads

Script To Create INSERT statements

The following script allows for the scripting of data into insert statement.The user only needs to set the tablename and a query for the data they require scripted and run.Note the script takes into account autonumber primary keys and removes them from the insert statement.Also Note that this script will only work on tables with […]

5 (2)

2006-03-29 (first published: )

450 reads

Blogs

ASF 029: Tomaz Kastrun interview

By

Introduction Tomaž Kastrun is BI & DEV developer, data analyst & data science. With...

Schema Filtering in SQL Prompt

By

I love SQL Prompt, and I’m regularly impressed by the enhancements our teams continue...

Information Measurement with SQL Server Part 4.8: The Intersection Family of Distances

By

By Steve Bolton …………Each group of distance measures surveyed in this segment of the...

Read the latest Blogs

Forums

using the same logic across multiple servers/dbs

By jonathan.crawford

We have five different report servers, with 13 or so different databases, all with...

How to see the source SELECT statement of views?

By imani_technology

I don't have permissions to right click\design views or to script the views.  Is...

Error converting data type varChar to Float

By ng_rai

Hello Everyone, I am running a really big code. At some point, I am...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers