The meta data is from an SQL 2012 Server.
I have posted alot more, find the whole list here.
Goto Definition or MetaData
Definition:
sys.sp_MSdeleteretry(nvarchar @temptable, int @tablenick
, uniqueidentifier @rowguid)
MetaData:
create procedure sys.sp_MSdeleteretry
(@temptable nvarchar(386),
@tablenick int,
@rowguid uniqueidentifier)
as
declare @guidstr nvarchar(38)
declare @nickstr nvarchar(12)
declare @retcode int
declare @quotedtemptable nvarchar(388)
--
-- do permission checking
--
exec @retcode = sys.sp_MSrepl_PAL_rolecheck @tablenick = @tablenick
if @retcode<>0 or @@ERROR<>0 return (1)
--
-- Modify temp table, granted to public.
--
set @nickstr = convert(nchar, @tablenick)
set @guidstr = '''' + convert(nchar(36), @rowguid) + ''''
select @quotedtemptable = quotename(@temptable)
execute ('delete from ' + @quotedtemptable + ' where tablenick = ' +
@nickstr + ' and rowguidcol = ' + @guidstr)
IF @@ERROR <>0 RETURN (1)
return (0)
No comments:
Post a Comment