一、请用T-SQL语句实现以下题目要求。

1、熟悉变量的声明、变量的赋值、输出结果

目的：查询并返回product产品表中产品名称以C开头的产品的条数

要求：产品名称以C开头的条件用变量来表示，查询出来的产品条数也用变量表示，并最终需要返回 The sum of the product is +查询出来的产品条数。

2、熟悉IF语句

给一变量赋值字符串 THIS IS MY BOOK ，如果此字符串的长度大于10，则返回其字符串第一位到第四位，否则返回后四位字符串。

3、熟悉循环语句

实验内容：求1-100之间能被7整除的整数之和。

4、熟悉所有示例文件中的T-SQL语句

-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