摘要：--创建存储过程IF EXISTS (SELECT * FROM sysobjects WHERE name='GetSplitString' AND xtype='p') DROP PROCEDURE dbo.GetSplitStringGOCREATE PROCEDURE dbo.GetSplitString @strID nvarchar(max) --以逗号隔开的字符串 ,@tableName nvarchar(50) output --临时表ASBEGIN declare @totalLength int declare @length in... 阅读全文

摘要：--简单的跨服务器查询语句select * from opendatasource('SQLOLEDB', 'Data Source=192.168.0.1;User ID=sa;Password=123').db_bingle.dbo.users--跨服务器插入数据IF EXISTS (select * from sys.servers WHERE name = 'ufserver')Exec sp_droplinkedsrvlogin 'ufserver',Null exec sp_dropserver @server= 阅读全文

摘要：create PROCEDURE pro_test@classID intASBEGIN SET NOCOUNT ON; begin tran --开始事务 declare @error int; --临时变量 declare @id int declare mycursor cursor --定义游标 for select id from test where classID=@classID --将数据导入游标 open mycursor ... 阅读全文

摘要：例：select SUM(1+null)结果为nullselect COALESCE(SUM(1+null),0)结果为0 阅读全文