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

Tag: exec

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

  • Why should I create an ID column when I can use others as key fields? [duplicate]
  • Force NOW to return new timestamps without committing the transaction
  • MariaDB on Windows Server 2012 R2 – out of memory
  • How to easily convert a comma seperated list of ids into a table of rows
  • clusterdb stopped working for PostgreSQL database in Ubuntu 12.04 server
  • Slow MySQL query
  • Database design : hotel room and its detail
  • How to use GROUP BY in an efficient way without losing attributes? [closed]
  • Query execution time is random, need to identify the root cause
  • Returning data where all categories exactly match
  • Partitioning increases CPU usage in mariadb
  • How to script out push subscription creation at the subscriber?
  • Can a transitive join loop infinitely?
  • 2 similar queries in large sql server table – 1 takes too long
  • Select data from another database instance on the same server in sql server
  • Is it possible to get server roles and database roles in a same query/script?
  • UPDATE performance where no data changes
  • Can I parse a text value from a specific column in a query (MySQL)?
  • MSSQL Geography STIntersects returns 1 when 0 is expected
  • Shrinking log files with SMO

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