Feeds:
Posts
Comments

Posts Tagged ‘Transact-SQL’

Transact-SQL: Show real size of tables in database on your harddisk

Posted in Microsoft SQL SERVER, tagged , on 04-03-2009 | Leave a Comment »

Post moved to new location:
http://code.mareoblo.pl/2009/03/04/transact-sql-show-real-size-of-tables-in-database-on-your-harddisk/

Read Full Post »

WSUS: T-SQL – Move all computers from Unassigned Computers group into another

Posted in WSUS, tagged on 04-03-2009 | Leave a Comment »

Post moved to new location:
http://code.mareoblo.pl/2009/03/04/wsus-t-sql-%e2%80%93-move-all-computers-from-unassigned-computers-group-into-another/

Read Full Post »

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 »

Older Posts »