TSQL BASIC Programming

TSQL BASIC Programming:

Define variable: declore @ variable name data type

Assignment: SET @ variable name = value SELECT @ Variable name = value

Retrieve print: SELECT @ variable name print @ variable name

Branching statement: If @a>@b

Begin

................

End

Loop statement: Initial conditions, cyclic condition, loop body, state change

declare @a int; Initial

Select @a = 1

While loop condition @a <=10

Begin

............. Loop body

End

Stored procedures: Equivalent to functions, four elements: input, output, function name, function body

Create

create proc Stored procedure name

@b int

As

function body

return value

Call: Exec stored procedure name

EXEC @a = stored procedure name

　　　　　　　　　　　

TSQL BASIC Programming