Description: First, please realize the following questions asked to use T-SQL statements. A familiar variable declarations, variable assignment, output purpose: query and return product to product table Name C at the beginning of the number of product requirements: product names that begin with the condition C variables to represent, check out the product also said that with the number of variables and eventually need to return to ' The sum of the product is' + check out the product of the number. 2, familiar with the IF statement to a variable assignment string ' THIS IS MY BOOK' , if the length of this string is greater than 10, then return to their string of first to fourth place, otherwise it returns after four strings. 3, familiar loop experiment: can be an integer divisible by 7 and between seeking 1-100. 4, familiar with all the sample files in the T-SQL statement
To Search:
File list (Check if you may need any files):
Lab10.sql
Download