http://blog.csdn.net/seven_cm/article/details/50019927 http://blog.csdn.net/kmyhy/article/details/48343069 http://www.cnblogs.com/wuhuacong/p/3613826. Read More
distinct是sqlserver的标识符,如果想以distinct为表时,在QUOTED_IDENTIFIER为off的情况下,是不能创建表名为distinct的表的,因为在QUOTED_IDENTIFIER为off情况下,sqlserver的标识符是不允许加引号的,所以在 SET QUOTED Read More
1 declare @studentid int //声明一个int型变量 2 set @studentid=(select id from tclass where classid= 1);//设置变量值,tclass 为任意表,classid 为表中任一字段 3 if(@studentid is not null)//如果值不为空,则执行插入语句,向表tstudent插入数据 4 INS... Read More