Database

SET param_payroll_exists = (SELECT COUNT(*) FROM payroll WHERE location_id = param_location AND payroll_month = param_month AND payroll_year = param_year);

IF EXISTS (param_payroll_exists > 0) THEN
    SET param_payroll_id = 0;
END IF;

Jassim Rahma wrote:

IF EXISTS (param_payroll_exists > 0) THEN

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

srikrishnathanthri wrote:

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

Richard Deeming wrote:

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

Msg 6573, Level 16, State 1, Procedure tri_add_clr, Line 1
Method, property or field 'abc' of class 'ClassLibrary1.Class1' in assembly 'triggerdll' is not static.

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

SELECT
    ...
FROM
    t1
    INNER JOIN t2
    ON t2.CampusID = t1.CampusID
    INNER JOIN t3
    ON t3.StaffID = t1.StaffID
ORDER BY
    ...
;

DBCC CHECKDB (N'Your-Database-Name') WITH NO_INFOMSGS, ALL_ERRORMSGS;

Msg 3043, Level 16, State 1, Line 1
BACKUP 'broken' detected an error on page (1:143) in file 'c:\sql\mydb.mdf'.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.