Posts tagged Execute

Do you want to execute a Stored Procedure as part of a SELECT statement??

0
1 year ago
in
I was on a training course at the end of September, and came across a way to execute a simple stored procedure as part of a select statement using an Inline Table Valued Function. You (like me) have probably tried to run the following statement expecting to get results from a stored procedure: USE [...]

Apply permissions to all stored procedures or tables

0
3 years ago
in
DECLARE @SQL varchar(100) DECLARE cObjects CURSOR FAST_FORWARD FOR     SELECT 'GRANT EXECUTE ON ' + name + ' TO [usrTest]' AS SQL     FROM   sysobjects     WHERE  xtype in ('P') /* Or, to Grant select, insert, update, and/or delete permissions, use the following select statement instead of the [...]
Go to Top