Kenneth Singer


Technical Article

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

314 reads

Technical Article

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

858 reads

Blogs

Daily Coping 29 Nov 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

What are those new buttons under tab order in Power BI?

By

If you’ve visited the Tab order area of the Selection Pane in Power BI...

Last Week Reading (2021-11-28)

By

?? Press SynapseML: A simple, multilingual, and massively parallel machine learning library Microsoft just...

Read the latest Blogs

Forums

Get Summary Data for Last 52 weeks by Week

By skb 44459

I have a table which stores shipment data by date. We have a need...

create index columnstore

By abdalah.mehdoini

hello , Who has any idea please how to rebuild a clustered index to...

help with SQL query PGADMIN

By crisy

2 tables Users : User_id, First_name, Last_name, Gender. Deposits : User_id, time_stamp, amount. i...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers