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

306 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

853 reads

Blogs

SQL Server 2019 on Docker no longer runs as root by default

By

In my home lab I have an Ubuntu virtual machine that runs both SQL...

SQL Server 2019 – Compatibility Level in Azure

By

I am not sure when this became available but for Azure SQL Database 150...

When using Powershell to control Azure the Cloud Shell doesn’t require an additional login.

By

When studying Azure one of the things you’ll be asked to learn is the...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Execution Plans

By sizal0234

Hi, How do  you share execution plans.  Save the plan and share the .sqlformat...

transaction delay when replica unavailable - what effect?

By snomadj

I'm using AlwaysOn synchronous replica.  User issues an update on primary via SSMS.  In...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers