About 50 results
Open links in new tab
  1. 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 …

  2. 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 …

  3. 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 …

  4. MSDN

    MSDN

  5. MSDN

    MSDN

  6. MSDN

    MSDN

  7. MSDN

    MSDN

  8. MSDN

    MSDN

  9. MSDN

    MSDN

  10. MSDN

    MSDN