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
Hi, Below is code which gives last row of table SELECT TOP 1 * FROM TABLENAME ORDER BY SOMEFIELD desc
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
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
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/
How to search all columns of all tables in a database for a keyword?
I was looking to create a such search where i can give simple one text box and get search in all columns of perticular table. When i was looking for that i find this script which is really cool… Find Origianl Article At. http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm Here is stored procedure “SearchAllTables”. It accepts a search string as input…
Read More