Sql server database syntax reference 01

IF...ELSE sentence

Syntax:

IF boolean_expression

    statement

[ELSE[IF boolean_expression] statement]

1.statement:

IF (SELECT MAX(Longitude) FROM Camera) > 23.0
BEGIN
    PRINT '经度的最大值大于23.0'
    SELECT '限值'=23.0
END
SELECT '最大值'=MAX(Longitude) from Camera
PRINT 'Is it supported?'

2.results:

Copying table sentence

1.statement:

SELECT *
INTO hp_Camera
FROM Camera
WHERE Camera.Area=N'黄埔区'

2.results:

 

WHILE,BREAK,and CONTINUE sentences

Syntax:

WHILE boolean_expression

    Statement

1.statement:

WHILE (SELECT AVG(Longitude) FROM hp_Camera)>100
BEGIN
    UPDATE hp_Camera SET Longitude=Longitude-1
    IF(SELECT MIN(Longitude) FROM hp_Camera)=0
        UPDATE hp_Camera SET Longitude=1
    IF(SELECT MAX(Longitude) FROM hp_Camera)<110
        BREAK
END
   

2.results:

 

DECLARE sentence

Syntax:

DECLARE @variable_name datatype [,@variable_name datatype]... /* declare a local variable*/

DECLARE @@variable_name datatype [,@@variable_name datatype].../* declare a global variable*/

SELECT @variable_name={expression|(SELECT_statement)}

[,@variable={expression|SELECT_statement)}...]

[FROM clause]

[WHERE clause]

1.statement:

DECLARE @minval FLOAT
SELECT @minval=min(Longitude) FROM hp_Camera
IF(@minval>0)
    PRINT '大于0'
ELSE
    PRINT '小于0'
SELECT '最小值'=@minval

2.results: