Database

Jörgen Andersson wrote:

The return statement is never reached, because the raiserror exits the statement block.

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" );