sql查询员工入职多少天_sql 查询四舍五入_sql怎么四舍五入(17)

declare @vchSourceSafeINI varchar(255)

declare @vchServerNamevarchar(255)

declare @vchDatabaseNamevarchar(255)

exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSProject', @vchProjectName OUT

exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSSourceSafeINI', @vchSourceSafeINI OUT

exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSSQLServer', @vchServerNameOUT

exec dbo.dt_getpropertiesbyid_vcs @iPropertyObjectId, 'VCSSQLDatabase', @vchDatabaseNameOUT

if @chObjectType = 'PROC'

begin

/* Procedure Can have up to three streams

Drop Stream, Create Stream, GRANT stream */

exec @iReturn = sp_OACreate @VSSGUID, @iObjectId OUT

if @iReturn <> 0 GOTO E_OAError

exec @iReturn = sp_OAMethod @iObjectId,

'CheckOut_StoredProcedure',

NULL,

@sProjectName = @vchProjectName,

@sSourceSafeINI = @vchSourceSafeINI,

@sObjectName = @vchObjectName,

@sServerName = @vchServerName,

@sDatabaseName = @vchDatabaseName,

@sComment = @vchComment,

@sLoginName = @vchLoginName,

@sPassword = @vchPassword,

@iVCSFlags = @iVCSFlags,

@iActionFlag = @iActionFlag

if @iReturn <> 0 GOTO E_OAError

exec @iReturn = sp_OAGetProperty @iObjectId, 'GetStreamObject', @iStreamObjectId OUT

if @iReturn <> 0 GOTO E_OAError

create table #commenttext (id int identity, sourcecode varchar(255))

select @vchTempText = 'STUB'

while @vchTempText IS NOT NULL

begin

exec @iReturn = sp_OAMethod @iStreamObjectId, 'GetStream', @iReturnValue OUT, @vchTempText OUT

if @iReturn <> 0 GOTO E_OAError

if (@vchTempText IS NOT NULL) insert into #commenttext (sourcecode) select @vchTempText

本文来自电脑杂谈，转载请注明本文网址：
https://www.pc-fly.com/a/ruanjian/article-30385-17.html