Sql server database syntax reference 02

GOTO label sentence

Syntax:label:

GOTO label

1.statement:

DECLARE @count  SMALLINT

SELECT @count=1

Restart:

PRINT 'hello'

SELECT @count=@count+1

WHILE @count<=4

goto Restart

2.results:

output:

hello

hello

hello

hello

 

RETURN sentence

Syntax:RETURN [int_expression]

statement:

CREATE PROCEDURE findrules @name NVARCHAR(30)=null

AS

IF @name ISnull

BEGIN

    PRINT 'You must give a user name'

    RETURN

END

ELSE

BEGIN

    ......

END

 

WAITFOR sentence

Syntax:WAITFOR {DELAY 'time'|TIME 'time'}

BEGIN

    WAITFOR TIME '22:20'

    EXECUTE update_all_states

END

 

PRINT sentence

syntax:PRINT {string_expr|@local_variable|@global_variable}

 

comment sentence

syntax:/* text_of_comment*/