BEGIN TRAN
BEGIN TRY
    -- Query code
    COMMIT TRAN
END TRY
BEGIN CATCH
    ROLLBACK TRAN
    PRINT ERROR_MESSAGE()
END CATCH

SLOSifl fucked around with this message at 16:45 on Mar 12, 2009

[Microsoft.SqlServer.Server.SqlProcedure]
public static int GetNames() {
   // Create a list to keep track of names you've encountered
   var nameList = new List<string>();

   // Create a SqlDataRecord
   var metadata = new SqlMetaData("Name", SqlDbType.NVarChar, 40 );
   var outputRecord = new SqlDataRecord ( new SqlMetaData[] { metadata } );

   using ( var conn = new SqlConnection ("context connection=true") ) {
      using ( var cmd = conn.CreateCommand() ) {
         cmd.CommandText = "SELECT [names] from [Table]";

         using ( var reader = cmd.ExecuteReader () ) {
             while ( reader.Read () ) {
                // Skip the row if it's null
                if( reader.IsDbNull ( 0 ) ) continue;

                var nameColumn = reader.GetString ( 0 );
             
                // Split the values into an array
                foreach ( var name in nameColumn.Split ( ',',
                            StringSplitOptions.RemoveEmptyEntries) ) {
                   // Ignore names you've seen already
                   if( nameList.Contains ( name.ToLower() ) ) continue;
                 
                   // Add the name to the list
                   nameList.Add ( name.ToLower() );

                   // Set the record's value and spit it out
                   outputRecord.SetString ( 0, name );
                   SqlContext.Pipe.Sent ( outputRecord );
                }
             }
         }         
      }
   }

   return nameList.Count;
}

SLOSifl fucked around with this message at 21:20 on Apr 30, 2009

UPDATE A SET Column1 = Val1, Column2 = Val2            --update everything
FROM TableA A WHERE Column1 <> Val1 OR Column2 <> Val2 --if anything changed

SLOSifl fucked around with this message at 13:12 on Sep 9, 2014