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 12118How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
1916
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What is the use of @@spid?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
how to define testing of network layers? : Sql server database administration
How to Insert multiple rows with a single insert statement?
What is exporting and importing utility?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What is auditing in sql server?
How do you rebuild an identity column?
What is policy management?
Define tempdb database?
what is the difference between count(*) and count(1) ?
What is the purpose of the model database?
What is factless fact table? : sql server analysis services, ssas
How do you delete a trigger?