Q&A

Q1:Does SQL Server allow me to create an array of variables?
A1: No, arrays are not supported by SQL Server.
Q2:I have used Visual Basic. Aren't there more program flow statements that I could use, such as CASE and FOR-NEXT?
A2: No. The IF and WHILE statements will provide you with as much control as you would need. The CASE statement is not used for controlling the flow of execution in T-SQL. It is most often used for conditional execution inside a SELECT or UPDATE statement.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset