What is a mutating table error and how can you get around it?
No Answer is Posted For this Question
Be the First to Post Answer
Why use sub query in sql server and list out types of sub queries?
When should you use an instead of trigger?
How would you add a section to a table?
What is unpivot?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What should be the fill factor for indexes created on tables? : sql server database administration
Describe the functionalities that views support.
what is performance tunning in sql server ? explain.
What is logon trigger?
How to get the definition of a trigger back?
How to check if stored procedure is running in sql server?
Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)