Kenneth Singer

Auto generate sp's for any table * usp_create_sps

If you've ever been stuck having to write stored procedures to support an application, check this script out.  This script will automatically generate seperate parameter driven select, insert, delete, and update stored procedures.  Simply call these stored procedures from your application, passing parameters.  This stored procedure requires only one parameter; table name.  Creates scripts with […]

1 (1)

2002-02-21

303 reads

DATEMY - Covnerts and validates MM/YY, MM/YYYY

If you've ever needed a convenient and quick way to convert/validate what could possibly be a mm/yy or mm/yyyy date to mm/dd/yyyy (date of month is 01) check out this custom function.  Eg:  select dbo.datemy('04/02') outputs smalldatetime '2002-04-01 00:00:00'.  Select dbo.datemy('04/2002') outputs the same smalldatetime '2002-04-01 00:00:00'.

2002-02-15

852 reads

Blogs

Containers: Create a Custom Container

By

Creating a custom container is where things get truly exciting. There’s actually a ton...

Mini-Rant: Spoofed Phone Numbers and Trust

By

I’ve seen this more and more over the last year: I receive a phone...

Speaking at SQL Saturday Dallas

By

Speaking at SQLSaturday Dallas! I’m proud to announce that I will be speaking at SQL...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

SQL Server health check

By 892717952

If I want to do a SQL Server health check, which aspects should be...

CPU?Memory and IO bottleneck check

By 892717952

Which indices will show  cpu bottleneck?memory bottleneck and IO bottleneck? for example: which indices...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers