2014年10月8日

SET IDENTITY_INSERT 表名 ON

摘要： SET IDENTITY_INSERT products ONinsert into products(pid,pname) values (1,'pname1');insert into products(pid,pname) values (2,'pname2');insert into pro... 阅读全文

posted @ 2014-10-08 10:54 中子持心 阅读(401) 评论(0) 推荐(0)

sqlserver 递归查询的一种写法

摘要： with tmp as ( select a.id,a.name,a.pid from tb a where id='003' union all select k.id,k.name,k.pid from tb k inner join tmp c on c.id = k.pid )select... 阅读全文

posted @ 2014-10-08 08:30 中子持心 阅读(246) 评论(0) 推荐(0)

导航