-
编辑 删除
此服务器版本不受支持。必须安装Microsoft Sql sever 2005 Beta2或更高版
“此服务器版本不受支持。必须安装Microsoft Sql sever 2005 Beta2或更高版...直接下载补丁安装完后重起vs 就Ok了补丁地址：http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn&FamilyID=e1109aef-1aa2-408d-aa0f-9df094f993bf[@more@]
-
编辑 删除
SQL Server日期
SQL Server日期[@more@]Select CONVERT(varchar(100), GETDATE(), 0)--05 16 2006 10:57AMSelect CONVERT(varchar(100), GETDATE(), 1)--05/16/06Select CONVERT(varchar(100), GETDATE(), 2)--06.05.16Select CONVERT(varchar(100), GETDATE(), 3)--16/05/06Select CONVERT(varchar(100), GETDATE(), 4)--16.05.06Select CONVERT(varchar(100), GETDATE(), 5)--16-05-06Select CONVERT(varchar(100), GETDATE(), 6)--16 05 06Select CONVERT(varchar(100), GETDATE(), 7)--05 16, 06Select CONVERT(varchar(100), GETDATE(), 8)--10:57:4
-
编辑 删除
SQL重复记录查询
1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断select * from peoplewhere peopleId in (select peopleId from people group by peopleId having count (peopleId) > 1)2、删除表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断，只留有rowid最小的记录delete from people where peopleId in (select peopleId from people group by peopleId having count (peopleId) > 1)and rowid not in (select min(rowid) from people group by peopleId having count(peopleId )>1)3、查找表中多余的
-
编辑 删除
解决并清除SQL被注入<script>恶意病毒代码的语句
declare @t varchar(255),@c varchar(255) declare table_cursor cursor for select a.name,b.name from sysobjects a,syscolumns b ,systypes c where a.id=b.id and a.xtype='u' and c.name in ('char', 'nchar', 'nvarchar', 'varchar','text','ntext') declare @str varchar(500),@str2 varchar(500) set @str='<script src=http://r01.3322.org/c.js></script>'/*要替换的内容*/ set @str2='' open table_cursor fetch next from table_cursor into @t,@c while(@@fetch_status=0) begin exec('update [' + @t + '] set
