Syntax error

Results 1 to 2 of 2

Thread: Syntax error

  1. #1
    Join Date
    Dec 1969

    Default Syntax error

    CREATE PROCEDURE testjob AS<BR><BR>declare @stDate Datetime<BR><BR>@stDate=Dateadd(day,1,getdate())<B R><BR>Can u tell me why it gives me Syntax error : Declare @stDate

  2. #2
    Join Date
    Dec 1969

    Default RE: Syntax error

    Try this:<BR><BR>CREATE PROCEDURE testjob AS<BR>BEGIN<BR> declare @stDate Datetime<BR> <BR> set @stDate=Dateadd(day,1,getdate())<BR>END

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts