SELECT SQL Select SQL and upgrade your performance

Details

Written by Stanislav Duben

Parent Category: MSSQL

Published: 05 January 2017

Last Updated: 03 April 2017

Hits: 31057

If you need calculate week number from date, you can use DATEPART with parameter ISO_WEEK. Unfortunately there is nothing like ISO YEAR parameter. In case you need to show YearWeek value in some report you have to take care about correct value manually.

Details

Written by Stanislav Duben

Parent Category: MSSQL

Published: 01 February 2016

Last Updated: 01 February 2016

Hits: 17453

Are you looking for simple way, how to get count of distinct values for each column in a table on MS-SQL database? There is a simple script with solution to help you.

Details

Written by Stanislav Duben

Parent Category: MSSQL

Published: 13 January 2011

Last Updated: 22 December 2012

Hits: 73576

When you try alter column in MSSQL 2005 from one datatype to other with some default value by ALTER TABLE xxx ALTER COLUMN column_name you get error about existing constraint. Unfortunately there is nothing like CASCADE CONSTRAINT. You must DROP constraint first and then you can ALTER column and finally you have to create CONSTRAINT again. I will show you easy way, how to do it.

Details

Written by Stanislav Duben

Parent Category: MSSQL

Published: 13 January 2010

Last Updated: 22 December 2012

Hits: 28678

Common situation, you need to make same changes in database, and you have column name.  But you aren't sure in which tables this column is, where to look etc. Here is the simple solution.

Details

Written by Stanislav Duben

Parent Category: MSSQL

Published: 15 October 2009

Last Updated: 22 December 2012

Hits: 43625

When you try drop column in MSSQL 2005 with some default value by ALTER TABLE xxx DROP column_name you get error about existing constraint. Unfortunately there is nothing like CASCADE CONSTRAINT. You must DROP constraint first and then you can DROP column. I will show you the easiest way, how to do it.