|
|
|
|
|
|
-
Dave Vroman liked 11 Months ago through Interview Questions | 1 Point
Suppose you have Employee_mst table now how to find store procedure uses this Employee_Mst table? ...
|
-
Dave Vroman Commented 11 Months ago through Interview Questions | 1 Point
We have over 150000 objects in our DB so I use the following:
DECLARE @Txt VARCHAR(50)
SET @Txt = '%%'
PRINT ' Searching For "' + @Txt + '" / "' + @TxtNot + '" / "' + @TxtNot2 + '"'
SELECT OBJECT_NAME(id) ObjectName,
...
|
|
|
|
|
|
|
|
|
|
|
-
Dave Vroman liked 1 Years ago through Interview Questions | 1 Point
Interview questions and answers on various SQL Server areas such as Database Administration, TSQL Development, BI etc....
|