Advertisement
Guest User

Untitled

a guest
Jul 17th, 2019
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. CREATE PROCEDURE dbo.[mainsproc]
  2. WITH EXECUTE AS 'dynamicdatauser'
  3. AS
  4. BEGIN
  5. DECLARE @SPROCNAME NVARCHAR(1000) = N'dbo.[optionalsproc]'
  6. IF OBJECT_ID(@SPROCNAME,N'P') IS NOT NULL THEN
  7. BEGIN
  8. DECLARE @DYNSQL NVARCHAR(100) = N'EXEC ' + @SPROCNAME
  9. EXEC sp_executeSQL @DYNSQL
  10. END
  11. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement