Click here to Skip to main content
Page 1 of 1
Page Size: 10 · 25 · 50


Author filtered by: Basavaraj P Biradar [x]
Technical Blog 7 May 2013   license: CPOL
Difference between SET QUOTED_IDENTIFIERS ON and OFF settings.
SQL
Merge Statement in SQL Server 2008 by Basavaraj P Biradar
Technical Blog 7 May 2013   license: CPOL
The new Merge statement in SQL Server 2008.
Tip/Trick 7 May 2013   license: CPOL
Difference between SQL Server Char and Varchar data type.
Tip/Trick 7 May 2013   license: CPOL
How to find all the Stored Procedures having a given text in it.
Tip/Trick 7 May 2013   license: CPOL
GO Statement can also be used to excute batch of T-SQL statement multiple times
Forum Message 18 Nov 2011  
Just one comment, as sql_modules will have row's only for Objects of type P, RF, V, TR, FN, IF, TF, R and D. So, the object types such as U, X, S, L etc... mentioned in the case statement are irreleva
Forum Message 26 Oct 2011  
In some rare cases this query will return in-correct result, because in syscomments table the text column is of type nvarchar(4000). If the sp text is exceeding this limit, sp text is split and stored
Tip/Trick 2 Oct 2011   license: CPOL
Note, the query mentioned in the section "How to search Stored Procedures containing a particular text?" will not return Stored Procedures which have the first occurance of the serach string after 4000 characters. It would be better to use the sys.procedures View as explained in my blog:...
Forum Message 1 Oct 2011  
Note the query mentioned in the section "How to search stored procedures containing a particular text?" query will not return stored procedures which has first occurance of the serach string after 400

Page 1 of 1


Advertise | Privacy | Mobile
Web04 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid