Database

CREATE PROCEDURE dbo.SubSP1
AS
BEGIN
    PRINT 'Start SubSP1'
    RAISERROR('Some Error', 16,1) WITH LOG
    PRINT 'End SubSP1'
END
GO
-------Create SubSP2---------
CREATE PROCEDURE dbo.SubSP2
AS
BEGIN
    PRINT 'Inside SubSP2'
END

GO
-------Create MainSP---------
CREATE PROCEDURE dbo.MainSP
AS
BEGIN
    PRINT 'Start MainSP'
    EXEC dbo.SubSP1
    EXEC dbo.SubSP2 
    PRINT 'End MainSP'
END
GO

Start MainSP
Start SubSP1
Msg 50000, Level 16, State 1, Procedure SubSP1, Line 6
Some Error
End SubSP1
Inside SubSP2
End MainSP

Start MainSP
Start SubSP1
End SubSP1
Inside SubSP2
End MainSP
Msg 50000, Level 17, State 1, Procedure SubSP1, Line 5
Some Error

Kornfeld Eliyahu Peter wrote:

with the same parameters

brian1210 wrote:

receiving a syntax error

IF (new.temperature > 65 

1. Obtain current date -> obtain "current year" -> obtain ("current year" - 1)
2. Make the dates for "between": [("current year" - 1)-01-01] and [("current year" - 1)-12-31]
3. use them in your query.

long ORDINAL_POSITION = (long)row.Field<Int64> ( "ORDINAL_POSITION" );

UInt16

ushort DATA_TYPE = (ushort)row.Field<UInt16> ( "DATA_TYPE" );

long ORDINAL_POSITION = row.Field<Int64> ( "ORDINAL_POSITION" );
ushort DATA_TYPE = row.Field<UInt16> ( "DATA_TYPE" );