Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ILC_NextKeySp]') AND type in (N'P', N'PC'))
- DROP PROCEDURE [dbo].[ILC_NextKeySp]
- GO
- CREATE PROCEDURE [dbo].[ILC_NextKeySp] (
- @TableName nvarchar(128)
- , @ColumnName nvarchar(128)
- , @Context LongListType
- , @Prefix LongListType
- , @KeyLength INT
- , @Key LongListType OUTPUT
- , @Infobar InfobarType OUTPUT
- )
- AS
- DECLARE
- @Severity INT
- EXEC @Severity = SetNextKeySp
- @TableName --@TableName
- , @ColumnName --@ColumnName
- , @Prefix --@Prefix
- , @KeyLength --@KeyLength
- , @Prefix --@Type
- , NULL --@SubKey
- , NULL --@TableName2
- , NULL --@SubKey2
- , @Key OUTPUT --@KeyStr
- , @Infobar OUTPUT --@Infobar
- RETURN @Severity
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement