Question : That is my first post here, need helps: in a stored procedure I had some following code CREATE […]
Tag: exec
SQL Server: what additional permissions for EXECUTE for implicit result codes?
Question : Tested on: 2014+SP2+CU7, 2016+SP1+CU5, 2016+SP2 Short description: User with EXECUTE permission still gets Cannot find the object ‘sp_fakeProcedureName’, […]
How can I stop script execution if insert value is null and set value if not null?
Question : I have tried to use Case and SET NOEXEC ON but get the following errors: Syntax Error: unexpected […]
SQL Server: what additional permissions for EXECUTE for implicit result codes?
Question : Tested on: 2014+SP2+CU7, 2016+SP1+CU5, 2016+SP2 Short description: User with EXECUTE permission still gets Cannot find the object ‘sp_fakeProcedureName’, […]
SQL Server: Use Implicit or Explicit Cursor? [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Check the result of a math expression in mysql
Question : Let’s say I have a table, which has four columns (a, b, oper and c) and some primary […]
How to combine multiple EXEC statements into a single SELECT?
Question : I run this every month to extract database logs, and I have to change the dates as well. […]
How to use variable in Exec statement [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]