飘摇中的风雨

--SQLSERVER SELECT sysobjects.name AS 表名, syscolumns.name AS 列名, systypes.name AS 数据类型, syscolumns.length AS 数据长度 FROM sysobjects INNER JOIN syscolumns ON sysobjects.id = syscolumns.id I...

[code="sql"] declare @count int declare @total int set @total=0 declare @tablename varchar(100) declare @sql nvarchar(4000) declare mycursor cursor for select name from sysobjects where name li...

[code="sql"] SELECT sysobjects.name AS 表名, syscolumns.name AS 列名, systypes.name AS 数据类型, syscolumns.length AS 数据长度 FROM sysobjects INNER JOIN syscolumns ON sysobjects.id = syscolumns.id ...

[code="sql"] select cast(cast(字段 as decimal(18,0)) as varchar) [/code]

declare @count int declare @tablename varchar(100) declare @sql nvarchar(4000) declare mycursor cursor for select name from sysobjects where name like 'test____' open mycursor fetch next from my...

内容来源于:http://blog.youkuaiyun.com/anya/article/details/6407280 用SQL语句,删除掉重复项只保留一条 [code="sql"] 在几千条记录里,存在着些相同的记录,如何能用SQL语句,删除掉重复的呢 1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断 select * from people where pe...

SELECT SUSER_SID ('test') --查询sid用户 sp_addlogin 'roiland','test','master' go EXEC sp_grantdbaccess 'test', 'test' go sp_addrolemember 'db_owner','test' go 2005重新安装数据库服务器上，备份还原的用户不可用的处理方...

[code="sql"] --sqlserver跨服务器查询 EXEC sp_addlinkedserver @server='link', @srvproduct='', @provider='SQLOLEDB', @datasrc='192.168.1.120' --要连接的数据库服务器IP EXEC sp_addlinkedsrvlogin 'link', --被访问...

[code="sql"] SELECT SUSER_SID ('test') --查询sid用户 sp_addlogin 'test','test','master' go use testdb EXEC sp_grantdbaccess 'test', 'test' go sp_addrolemember 'db_owner','test' go --2005重新安...

--MSSQL 2005 SELECT SP.name as [login_name],DP.default_schema_name as [Schema_with_user],DP.name as [user_name] FROM sys.database_principals DP ,sys.server_principals SP WHERE SP.sid = DP.sid --an...

--适用于sqlserver2005,mysql,其他数据库未用过,不确定 SELECT * from information_schema.columns WHERE table_name = '表名';

use master go alter database AdventureWorks set RECOVERY FULL--完全 go use master go alter database AdventureWorks set RECOVERY SIMPLE...

[code="sql"] declare @count int declare @total int set @total=0 declare @tablename varchar(100) declare @sql nvarchar(4000) declare mycursor cursor for select name from sysobjects where name li...