Database

IF EXISTS (SELECT payroll_id FROM payroll WHERE location_id = param_location AND payroll_month = param_month AND payroll_year = param_year) THEN
    SET param_payroll_id = 0;
END IF;

Public Class Class1
    Public Function abc(ByVal a As String) As String
        Return a.ToUpper
    End Function
End Class

CREATE ASSEMBLY   triggertest
FROM 'D:\dll\triggerdll.dll'	
WITH PERMISSION_SET = SAFE	

CREATE TRIGGER tri_add_clr	
ON dbo.foriegn
FOR INSERT	
AS	
EXTERNAL NAME triggertest.Class1.abc

Msg 6505, Level 16, State 2, Procedure tri_add_clr, Line 1
Could not find Type 'Class1' in assembly 'triggerdll'.

Dim cmdText As String
        cmdText = "SELECT t1.StaffName, t2.CampusName
            FROM t1
            INNER JOIN t2
            ON t1.CampusID = t2.CampusID
            ORDER BY t1.StaffName"

t1.StaffID = t3.StaffID

BACKUP DATABASE [DBName] TO disk = 'TargetPath' WITH CHECKSUM

USE [DBPS]
GO
/****** Object:  StoredProcedure [dbo].[DATABASE_MAINTANANCE_PLAN]    Script Date: 5/22/2010 12:32:30 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/*THIS SP WILL REBUILT ALL THE INDEXES IN ALL TABLES IN ALL DATABASES
THIS WILL BE CALLED FROM AN SSIS PACKAGE. THIS WILL USED IN CLIENTS TO REBUILT INDEXES AND IT WILL BE
RAN EVERY FRIDAY NIGHT
*/

ALTER PROC [dbo].[DATABASE_MAINTANANCE_PLAN]
AS 
DECLARE @DatabaseName SYSNAME   =  DB_NAME(),  @TableName VARCHAR(256) 
DECLARE @FILLFACTOR INT = 85
DECLARE @DynamicSQL NVARCHAR(max) =
 'DECLARE curAllTablesInDB CURSOR FOR SELECT TABLE_SCHEMA +
 ''.'' + TABLE_NAME AS TABLENAME  
 FROM ' + @DatabaseName + '.INFORMATION_SCHEMA.TABLES WHERE
 TABLE_TYPE = ''BASE TABLE'''  

BEGIN 
  EXEC sp_executeSQL @DynamicSQL  -- create tables cursor
  OPEN curAllTablesInDB  
  FETCH NEXT FROM curAllTablesInDB INTO @TableName  
  WHILE (@@FETCH_STATUS = 0) 
  BEGIN  
       SET @DynamicSQL = 'ALTER INDEX ALL ON ' + @TableName +
         ' REBUILD WITH (FILLFACTOR = ' + CONVERT(VARCHAR,@FILLFACTOR) + ')' 
       PRINT @DynamicSQL
       -- ALTER INDEX ALL ON Purchasing.ShipMethod REBUILD WITH (FILLFACTOR = 85)
       EXEC sp_executeSQL @DynamicSQL 
       FETCH NEXT FROM curAllTablesInDB INTO @TableName  
   END   -- cursor WHILE
   CLOSE curAllTablesInDB  
   DEALLOCATE curAllTablesInDB 
END