love_snow

INSERT INTO #date (SaleOrderDate,produceLineID,branchDepID,controlTypeID) SELECT convert(varchar(10),dateadd(dd,number,'2019-10-8'),120), bpi.produceLineID, 10000,1 from master..spt_values,dbo.baseProduceLineInfo bpi where type='p' and number <= datedif

Create VIEW ViewRpVmsToken --创建视图ASSELECT *FROM OPENROWSET('SQLNCLI', ---DBlink'DRIVER={SQL Server};SERVER=192.168.0.204;UID=sa;PWD=1;Trusted_Connection=no','SET FMTONLY OFF;SET NOCOUNT ON;EXEC QMNEW0618.dbo.proctest') --存储过程名称GO...

使用游标前数据declare @loginid varchar(50)declare @loginPass varchar(50)declare cursor1 cursor for --定义游标cursor1select loginid,loginPassword from users where loginid<54 ----使用游标的对象(跟据需要填...

单行的数据可以直接用表值函数Create FUNCTION [dbo].[F_Split] ( @SplitString nvarchar(max), --源字符串 @Separator nvarchar(10)=' ' --分隔符号，默认为空格 ) RETURNS @SplitStringsTable TABLE --输出的数据表 ( ...