SQL Server: Just think about any table which has say 50 odd column which is very common, now writing any kind of DML statement say SELECT statement, how long it takes, probably 1 or 2 or say for if you r not taking help of sys.columns 3-4 minutes. Now think about how many DML statements you cover in any business logic SP, yup a lot!!! Now imagine about an utility which in a second produce your required DML statement. Fascinated about the idea, let start writing a routine which will make our daily work ease IF OBJECT_ID(dbo.usp_getDMLText) IS NOT NULL BEGIN DROP PROCEDURE dbo.usp_getDMLText END GO
Posted on: Sat, 27 Dec 2014 12:44:03 +0000
Trending Topics
Recently Viewed Topics
© 2015