Stored Procedures [dbo].[setDateFirst]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@numint4
SQL Script
/****** Object:  Stored Procedure dbo.setDateFirst    Script Date: 12/1/2005 11:49:12 PM ******/

CREATE PROCEDURE setDateFirst
    @num int = -1
AS
BEGIN
    IF @num < 8 and @num >0
        SET DATEFIRST @num
END
GO
Uses