Snipplr http://snipplr.com/language/sql/tags/T-SQL Recent snippets posted on Snipplr.com en-us Fri, 24 May 2013 20:07:33 GMT (SQL) Count number of tables, views, stored procedures or functions - Mithun http://snipplr.com/view/52990/count-number-of--tables-views-stored-procedures-or-functions/ You can use TSQL to Count Number Of Stored Procedures, Views, Tables or Functions in a Database by using the Database INFORMATION_SCHEMA view

]]> Wed, 04 May 2011 19:11:45 GMT http://snipplr.com/view/52990/count-number-of--tables-views-stored-procedures-or-functions/ (SQL) Find Duplicate Rows in Table - ezerick http://snipplr.com/view/47690/find-duplicate-rows-in-table/ Field1 + Field2 + Field3 should create 1 entry for each unique row in the DB. In an employee table, this would be FirstName + LastName + EmployeeNumber

]]> Sat, 22 Jan 2011 04:47:21 GMT http://snipplr.com/view/47690/find-duplicate-rows-in-table/ (SQL) Copy rows from one table to another - choasis http://snipplr.com/view/25550/copy-rows-from-one-table-to-another/ Just replace the squared brackets with the correct values.

]]> Mon, 28 Dec 2009 03:30:39 GMT http://snipplr.com/view/25550/copy-rows-from-one-table-to-another/