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
TCS,
7 12115How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
1916
what are different types of backups available in sql server? : Sql server database administration
Do you know what are pages and extents? : SQL Server Architecture
What is side by side migration in sql server?
How to delete a database in ms sql server?
Where sql server user names and passwords are stored in sql server? : sql server database administration
explain what is raid and what are different types of raid configurations? : Sql server database administration
What are the components of sql server service broker?
1 01 101 01010
How do you clear a log file?
How can you stop stored procedures from recompiling?
Can we write ddl in trigger?
What is dbcc command in sql server?
What is clustered vs nonclustered index?
Explain the rules for designing files and file groups in sql server?
How to update values in a table with update statements in ms sql server?