--给一个表指定一个顺序列
select name , ROW_NUMBER()over(order by name) ss from sysobjects where xtype='U'and name like '%da_%'
--查询出档案管理系统中所有的记录总数
DECLARE @TableInfo TABLE ( name VARCHAR(50) , [rows] int , reserved VARCHAR(50) , data VARCHAR(50) , index_size VARCHAR(50) , unused VARCHAR(50) ) DECLARE @TableName TABLE ( name VARCHAR(50) ) DECLARE @name VARCHAR(50) INSERT INTO @TableName ( name ) SELECT o.name FROM sysobjects o , sysindexes i WHERE o.id = i.id AND o.Xtype = 'U' AND i.indid < 2 ORDER BY i.rows DESC , o.name WHILE EXISTS ( SELECT 1 FROM @TableName ) BEGIN SELECT TOP 1 @name = name FROM @TableName DELETE @TableName WHERE name=@name INSERT INTO @TableInfo ( name , [rows] , reserved , data , index_size , unused ) EXEC sys.sp_spaceused @name END SELECT sum(rows) FROM @TableInfo where name like '%da_%'
--查询全部的表名
select name from sysobjects where xtype='U'and name like '%RHCJWT%'
--修改用户名密码
update ge_user set z_password='' where z_username='user' delete ge_para where username='user' and class1='usertype'
insert into ge_user(z_username,z_password,z_userdesc,z_email) values('lyb','123','梁永斌','')<BR>insert into ge_user(z_username,z_password,z_userdesc,z_email) values('jkq','123','江克强','')<BR>insert into ge_user(z_username,z_password,z_userdesc,z_email) values('cy','123','陈宇','')<BR>insert into ge_user(z_username,z_password,z_userdesc,z_email) values('xl','123','徐磊','')<BR>insert into ge_user(z_username,z_password,z_userdesc,z_email) values('czm','123','陈竹梅','')
--库名注册
Insert Ge_Main (Flsm, Ename,Cname,ClassName,SortNo) values ('子类','英文名称','中文名称','分类','顺序号')
--查询出a表的全部数据创建新表
select*into 新表 from a