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

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

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

457 reads

Blogs

How to Design Backups in SQL Server?

By

The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...

Daily Coping 23 Sept 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Getting Up and Running with Dapr

By

I’ve heard about Dapr a few times from developer friends, but hadn’t really understood...

Read the latest Blogs

Forums

The OPENJSON return schema

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The OPENJSON return schema

Thank a Mentor

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Thank a Mentor

Create an RPA Flow that Connects to Oracle Data in UiPath Studio

By JerodJ

Comments posted to this topic are about the item Create an RPA Flow that...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers