![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql server
B624023251
这个作者很懒,什么都没留下…
展开
-
sql server触发器及存储过程
create proc proc_6 as select * from person; select * from users; go exec proc_6 create trigger tr_1 on users after insert as select * from inserted drop trigger tr_2 crea原创 2013-11-21 17:25:54 · 706 阅读 · 0 评论 -
SQL SERVER 2005存储过程
create table Person( id int identity(1,1) primary key, name varchar(50) not null ); create table users( id int identity(1,1) primary key, name varchar(50) not null, age int not null, sex c原创 2013-10-09 11:13:05 · 495 阅读 · 0 评论 -
sql server 2005 数据库相关知识
分页语句:SELECT * FROM news n1 WHERE (SELECT count(*) from news n2 where n2.nid= 10 AND (SELECT count(*) from news n2 where n2.nid<n1.nid) <20;原创 2013-07-11 11:15:42 · 444 阅读 · 0 评论 -
Sql Server数据库备份
package sqlserverBackUp; import java.util.Timer; public class SqlBackUp { public void startUp() { new Timer().schedule(new dbBackTimer(), 0, Util.time1); new Timer().schedule(new Diff原创 2013-05-14 17:42:40 · 507 阅读 · 0 评论