Last Row of Table in SQL

Hi, Below is code which gives last row of table

SELECT TOP 1 * FROM TABLENAME
ORDER BY SOMEFIELD desc

Advertisements

Enable CLR integration in SQL 2005

Hello Friends,

Please folloe this liank and find how you can enable CLR integration in SQL Server 2005.

http://www.sqlclr.net/Articles/tabid/54/articleType/ArticleView/articleId/1/Enabling-CLR-in-SQL-Server.aspx

SQL Server : User Define Data type

Hello,

SQL Server 2005 and 2008 allow user define data type. This data type allow your own rule.

Please read below article for more information.

http://msdn.microsoft.com/en-us/library/ms190232.aspx

HIERARCHYID Data Type in SQL 2008

Hello All,

SQL 2008 introduce new HIERARCHYID Data Type.

Please read below it’a great atricle.

http://www.sqlservercentral.com/articles/SQL+Server+2008/67787/

%d bloggers like this: