Advertisement
MagnusArias

SBO | Funkcje 2 SQL

Nov 16th, 2019
322
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.47 KB | None | 0 0
  1. DROP FUNCTION wiersze_f
  2. GO
  3. DROP PROCEDURE wiersze
  4. GO
  5. DROP ASSEMBLY funkcje1
  6. GO
  7. CREATE ASSEMBLY Funkcje1
  8. AUTHORIZATION [dbo]
  9. FROM 'C:\e740\repos\Funkcje\Funkcje1\Funkcje1\bin\Debug\Funkcje1.dll'
  10. WITH PERMISSION_SET = UNSAFE
  11. GO
  12. CREATE PROCEDURE wiersze(@a nvarchar(33), @b INT OUTPUT)
  13. AS EXTERNAL NAME Funkcje1.Wynik.wiersze
  14. GO
  15. CREATE FUNCTION wiersze_f(@tabela nvarchar(MAX)) RETURNS INT
  16. AS EXTERNAL NAME Funkcje1.Wynik.wiersze_f
  17. GO
  18.  
  19.  SELECT dbo.wiersze_f('cyk')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement