About 50 results
Open links in new tab

SQL Management studio can show invalid views?
Oct 3, 2006 · DECLARE cviews CURSOR FOR SELECT DISTINCT schema_name (schema_id) + '.' + name FROM sys.objects so WHERE type = 'V' OPEN cViews FETCH cViews INTO @view WHILE …
To continue a stored procedure even when an insert/update fails:
Jul 27, 2011 · For updating, I am taking each record of source in one cursor and destination in another cursor and comparing. The thing is that if the update is successful then the comparision is continued …
expand table with date range for each dates
Nov 19, 2010 · declare @patient varchar (50) DECLARE MyCursor CURSOR FOR SELECT patientid FROM table1 OPEN MyCursor FETCH NEXT FROM MyCursor INTO @patient WHILE …
MSDN
MSDN
MSDN
MSDN
MSDN
MSDN
MSDN
MSDN
MSDN
MSDN
MSDN
MSDN
MSDN
MSDN