Feeds:
Posts
Comments

Archive for the ‘Transact-SQL’ Category

Transact-SQL: How to get current date with start time 00:00:00 and end time 23:59:59

Posted in Microsoft SQL SERVER, Transact-SQL, tagged on 22-09-2008 | Leave a Comment »

Post moved to new location:
http://code.mareoblo.pl/2008/09/22/transact-sql-how-to-get-current-date-with-start-time-000000-and-end-time-235959/

Read Full Post »

Tranasct-SQL: Delete (drop) all user stored procedures from database

Posted in Microsoft SQL SERVER, Transact-SQL, tagged , on 03-09-2008 | 5 Comments »

Post moved to new location:
http://code.mareoblo.pl/2008/09/03/transact-sql-delete-drop-all-user-stored-procedures-from-database/

Read Full Post »

Transact-SQL: Pack of useful Dates functions, calculations (day, week, month, year)

Posted in Microsoft SQL SERVER, Transact-SQL, tagged , on 01-09-2008 | Leave a Comment »

Post moved to new location:
http://code.mareoblo.pl/2008/09/01/transact-sql-pack-of-useful-dates-functions-calculations-day-week-month-year/

Read Full Post »

Transact-SQL: How to get only date from datetime

Posted in Microsoft SQL SERVER, Transact-SQL, tagged , on 11-08-2008 | Leave a Comment »

Post moved to new location:
http://code.mareoblo.pl/2008/08/11/transact-sql-how-to-get-only-date-yyyy-mm-dd-from-datetime/

Read Full Post »

Transact-SQL: Count number of lines in all stored procedures in current database

Posted in Microsoft SQL SERVER, Transact-SQL, tagged , on 08-08-2008 | 7 Comments »

Post moved to new location:
http://code.mareoblo.pl/2008/08/08/transact-sql-count-number-of-lines-in-all-stored-procedures-in-current-database/

Read Full Post »

Transact-SQL: How to calculate week number in ISO 8601 standard

Posted in Microsoft SQL SERVER, Transact-SQL, tagged , on 07-08-2008 | 2 Comments »

Post moved to new location:
http://code.mareoblo.pl/2008/08/07/transact-sql-how-to-calculate-week-number-in-iso-8601-standard/

Read Full Post »

Transact-SQL: How to calculate number of days in year

Posted in Transact-SQL, tagged , on 07-08-2008 | Leave a Comment »

Post moved to new location:
http://code.mareoblo.pl/2008/08/07/transact-sql-how-to-get-number-of-days-in-year-also-leap-year/

Read Full Post »

Transact-SQL: How to find (not) duplicates in column

Posted in Transact-SQL, tagged , on 04-08-2008 | 1 Comment »

Post moved to new location:
http://code.mareoblo.pl/2008/08/04/transact-sql-how-to-find-not-duplicates-in-column/

Read Full Post »

Transact-SQL: How to calculate last date of current month

Posted in Microsoft SQL SERVER, Transact-SQL, tagged , on 04-08-2008 | Leave a Comment »

Post moved to new location:
http://code.mareoblo.pl/2008/08/04/transact-sql-how-to-calculate-last-date-of-current-month/

Read Full Post »

Transact-SQL: How to calculate first date of current month

Posted in Transact-SQL, tagged , on 04-08-2008 | Leave a Comment »

Post moved to new location:
http://code.mareoblo.pl/2008/08/04/transact-sql-how-to-calculate-first-date-of-current-month/

Read Full Post »

Older Posts »