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 […]

(2)

You rated this post out of 5. Change rating

2006-04-21 (first published: )

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

300 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 […]

(2)

You rated this post out of 5. Change rating

2006-03-29 (first published: )

476 reads

Blogs

On Speaking Well

By

Professor Patrick Winston of MIT used to give a one-hour talk about how to...

Monday Monitor Tips: Oracle Custom Metrics

By

One of the popular features of Redgate Monitor has been the ability to add...

Walking Through a Planned Failover: SQL Server Always On Availability Groups on Kubernetes

By

When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...

Read the latest Blogs

Forums

Troubleshooting WQL in custom PBM conditions?

By mastershake

Hi, I'm currently trying to implement policy based mgmt with a condition to query...

Analysis of Locking Issues on Secondary Replicas in AlwaysOn Availability Groups

By abdalah.mehdoini

We have an AlwaysOn architecture with four replicas: two running in synchronous commit mode...

The Vector Data Type

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Vector Data Type

Visit the forum

Question of the Day

The Vector Data Type

What is the vector data type in SQL Server?

See possible answers