Technical Article

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)

You rated this post out of 5. Change rating

2006-04-21 (first published: )

539 reads

Technical Article

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

You rated this post out of 5. Change rating

2006-04-03 (first published: )

279 reads

Technical Article

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)

You rated this post out of 5. Change rating

2006-03-29 (first published: )

460 reads

Blogs

What Does Redgate Test Data Manager Do?

By

At the PASS Data Community Summit in 2024, Redgate launched Test Data Manager (TDM),...

Extracting PostgreSQL database metadata for presentation in Excel format

By

(2024-Mar-16) I have been a big fan of using the Excel application for various tasks...

Change Notebook Spark Session Time-Out in Microsoft Fabric

By

You might know the feeling: you’re writing code in a Notebook in Microsoft Fabric...

Read the latest Blogs

Forums

some questions related to Ola hallengren maintenance scripts

By vsamantha35

Hi All, I have couple questions related to Ola Hallengren's maintenance script. If anyone...

How to Alert When SQL Queries Exceed a Time Limit During Execution?

By IT researcher

I've been exploring various methods to monitor and alert for long-running queries in SQL...

3rd Friday of the Month

By water490

Hi everyone I need to find the last business of the week.  In most...

Visit the forum

Question of the Day

SQL Express Agent

How can I run SQL Agent with SQL Server Express 2022?

See possible answers