清山博客

摘要： 知识点：①声明变量：DECLARE 关键字 ②循环语句：WHILE... BEGIN ... END③数据类型转换：CAST()函数应用举例：初始化脚本：CREATE TABLE [dbo].[TEST]( [ID] [int] IDENTITY(1,1) NOT NULL, [TID] [int] NULL, [Discription] [nvarchar](200) NULL ) --测试数据 DELETE FROM TEST INSERT INTO TEST (TID,Discription)VALUES (1,'记录1-1') INS... 阅读全文

摘要： 测试脚本：CREATE TABLE [dbo].[TEST]( [ID] [int] IDENTITY(1,1) NOT NULL, [TID] [int] NULL, [Discription] [nvarchar](200) NULL ) --测试数据 DELETE FROM TEST INSERT INTO TEST (TID,Discription)VALUES (1,'记录1-1') INSERT INTO TEST (TID,Discription)VALUES (1,'记录1-2') INSERT INTO TEST (TID,Discriptio 阅读全文