数据库
ringtoping
知识从未如此性感!
展开
-
sql server中merge的使用
建表orders:create table orders (OrderID INT,CustomerID NCHAR(5)) insert into orders values(1,'aaaa') insert into orders values(2,'bbbb')复制一个数据进orders2表中select * into orders2 from翻译 2015-10-20 11:36:12 · 607 阅读 · 0 评论 -
存储过程 Sql server
alter proc demo_proc asbegindeclare updateCursor cursor for select jhlsh from jgpj_khjh_jbxx where qyzt='1' and qsyf is not nullopen updateCursor declare @jhlsh varchar(64)fetch next f原创 2015-09-20 14:15:23 · 414 阅读 · 0 评论