Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: exec

Must declare the scalar variable question

By adminPosted on August 28, 2023

Question : That is my first post here, need helps: in a stored procedure I had some following code CREATE […]

SQL Server: what additional permissions for EXECUTE for implicit result codes?

By adminPosted on February 11, 2023

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?

By adminPosted on August 22, 2022

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?

By adminPosted on June 23, 2022

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]

By adminPosted on June 6, 2022

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

By adminPosted on October 8, 2021

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?

By adminPosted on January 22, 2021

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]

By adminPosted on October 20, 2020

Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]

Recent Posts

  • Can sp_executesql be configured / used by default?
  • SQL Server Query Store – why does it not always use the forced plan? [duplicate]
  • Multiple query to columns indexed in MySql
  • cluster_database TRUE/FALSE what does it mean in Oracle RAC?
  • mysql – How to repair & backup archive table, also stop growing .ARN extension file?
  • How does the transactions interact if you set a different isolation level per connection?
  • Autovacuum in Postgresql database
  • MySQL Server 5.7.33 or upgrade
  • What are the performance implications of using uuid as primary key in Postgres 10.12? (need canonical answer) [duplicate]
  • How do I use subquery on the same table in MySQL?
  • Error on updating a field with binary values
  • Feasibility of a MSSQL Read Only Replicas as ephermal containers?
  • How to represent directed graph with multiple parents?
  • Promoting MySQL slave with unknown replication delay
  • Rules for Decomposition to 2 NF
  • Index with ops for `LIKE` and `=` queries
  • How many cores are used for serial plans in SQL Server?
  • MySQL read-write Master with many read-only Slaves over shared storage?
  • How to reference categories table in products table?
  • Automatically set value on child rows when deleting parent row?

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding