Browse by Tags

All Tags » SQL Server (RSS)

Number of Rows Affected Rowcount and Top keyword by vik20000in

Hi, Many a times in a query we need to limit down the number of records returned in the query. This can be done in two ways using the TOP keyword or the row count keyword. Select top 10 from Table This will return the top 10 records from the query. We...
Filed under: ,

Different ways to get the UTC time in Oracle and MSSQL by vik20000in

Hi, Many a time with all the data we want to store the current date time for reference purpose. If your application is going to work with more than one country than its best to store the date time in UTC (GMT) format. With difference database the way...
Filed under: ,

SQL server 2008 February CTP launched by vik20000in

Hi, As all of us know that SQL server 2008 Launch has been delayed to 2nd half of the year, but the Feb CTP has been released. The CTP is feature complete. The CTP include better functionality for Data compression, Policy based management enhancement...
More Posts