Feeds:
Posts
Comments

Archive for the ‘Microsoft SQL SERVER’ Category

C#: SQL Server data types equivalents in .NET Framework

Posted in C#, Microsoft SQL SERVER, tagged , on 05-03-2009 | 2 Comments »

Post moved to new location:
http://code.mareoblo.pl/2009/03/05/c-sql-server-data-types-equivalents-in-net-framework/

Read Full Post »

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 »

Transact-SQL: How to find Service Pack version in SQL Server 2005

Posted in Microsoft SQL SERVER, tagged on 25-12-2008 | Leave a Comment »

Post moved to new location:
http://code.mareoblo.pl/2008/12/25/transact-sql-how-to-find-service-pack-version-in-sql-server-2005/

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 »

Older Posts »