iteye_11350的博客

[size=medium]//重命名字段的名称 EXEC sp_rename 'T_VOTE.[id]','c_id','COLUMN'; //用sql语句设置主键语法 alter table T_ZHUANTI alter column c_id bigint not null alter table T_ZHUANTI add primary key(c_id)[/size]...

[size=large]SqlServer2005 下可以 update A set A.c_limitDate=B.ReplyDeadline from (SELECT * FROM visit_entries AS b WHERE (SELECT COUNT(*) FROM visit_entries WHERE code=b.code)=1 )B inner...

[size=large]trt_teacher_temp 是表名 SQLServer 2000 的： (1) 利用not in 和 select top select top 10 * from trt_teacher_temp where c_id not in(select top 20 c_id from trt_teacher_temp) 第一个10=pageSize 表示 每...

[size=large]1、对自己的表操作 select a.* from hdzx_question a where a.c_id=(select top 1 c_id from hdzx_question where c_title =a.c_title and substring(c_content,0,7000)=substring(a.c_content,0,7000)) （...

exec sp_msforeachtable 'sp_changeobjectowner ''?'', ''dbo''' 把数据库表其他用户的 全部转成 dbo