Build DATELOOKUP table

This script creates a table named DATELOOKUP which is used for looking up date related values. Each record represents date related info about the date in the column dtDate. For example the iMonth column stores the integer value of the month of dtDate and sShortMonth stores the abbreviated name of that same month. Use this […]

5 (1)

2004-12-13 (first published: )

183 reads

Blogs

Azure Storage tips

By

As a followup to my blog post Azure Data Lake Store Gen2 is GA,...

Managing Agent Jobs on Availability Group Servers

By

As always, the scripts in this post can also be found on our Git...

Permissions required for row counts to show up on Object Explorer Details

By

I ran into a rather obscure permissions problem the other day. Since I wasn’t...

Read the latest Blogs

Forums

Sql server Express 2017 and ssms

By kangarolf

Hi all, I've never used mssql express before but we had a small intranet...

Memory requirement

By Admingod

Looking for memory optimized tables. How would we know that the approx memory is...

Question on the use of schemas for access control

By chuck.forbes

I know that this is a long article, so, I totally understand if there...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers