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

312 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

856 reads

Blogs

The End of PASS

By

I think our profession was the better for having a professional association, even if...

Platforms for Events

By

in my last post I wrote about thinking of the tools as being a...

Getting Started with Robotic Process Automation (RPA) Using the Power Automate Desktop

By

There are a lot of hot phrases you’ve likely heard thrown around during various...

Read the latest Blogs

Forums

"Home PC" SQL instance

By ifthir

This may be a bit non-typical, but I am currently running SQL 2019 Developer...

delete

By sulman.sqldba

    delete

Interview question about CPU

By Lord Slaagh

Hello SSC friends, I am a SQL Developer who is learning how to be...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers