Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Sudhir Chawla,
NOTE: This script will give error if you have MONEY data type field in table.
Create this procedure and use following command to execute this:
Exec usp_Generate_Inserts 'Customers' --Customers is the table name
--Output is something like this for all the rows
INSERT INTO [dbo].[Customers](CustomerID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax) VALUES('ALFKI','Alfreds Futterkiste','Maria Anders','Sales Representative','Obere Str. 57','Berlin',NULL,'12209','Germany','030-0074321','030-0076545')
This week Steve Jones looks at those customizations that make your job easier.
Report Listing Customizations
Custom Reports- mgmt studio
Custom Date Key