MS SQL. How to get only date from datetime field

Tuesday, 4 November 2008 14:25 by dmitriy

SQL construct to remove time part from datetime. [More]

Be the first to rate this post

Tags:		ms sql
Categories:		SQL
Actions:		E-mail \| del.icio.us \| Kick it! \| DZone it! \| Permalink \| Comments (0) \| Comment RSS

MS SQL. Get rows in random order.

Monday, 15 September 2008 11:42 by dmitriy

How to get data from MS SQL table in random order. [More]

Be the first to rate this post

Tags:		ms sql
Categories:		Main \| SQL
Actions:		E-mail \| del.icio.us \| Kick it! \| DZone it! \| Permalink \| Comments (0) \| Comment RSS

Monday, 7 April 2008 17:23 by Dmitriy

Simple function to convert MySQL LIMIT to MS SQL TOP. [More]

Be the first to rate this post

Tags:		c#, sql
Categories:		C# \| SQL
Actions:		E-mail \| del.icio.us \| Kick it! \| DZone it! \| Permalink \| Comments (0) \| Comment RSS

Wednesday, 12 December 2007 12:37 by Dmitriy

Explains how to make SQL Express DB full dump to publish on shared hosting. [More]

Currently rated 4.0 by 3 people

Categories:		Main \| ASP.NET \| SQL
Actions:		E-mail \| del.icio.us \| Kick it! \| DZone it! \| Permalink \| Comments (0) \| Comment RSS