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
WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.1 4467
System variable and temporary variables956
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?789
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
what are the Prerequisites for Replication?
Call by value and call by reference in procedure and function, with NOCOPY.
What are the dis_advantages of stored procedures, triggers, indexes?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
How much memory that we are using in Logshipping Concept?
How we create SQL Server 2005 Reporting Services ? Give me Sample
You are doing log shipping due to some reasons it is failing. How you will proceed from there
Which is the best place or learning center for MS SQL?????In Bangladesh?????
System variable and temporary variables
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
can any body tell me how to know the password of current user in sql server
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
Issues related in upgrading SQL Server 2000 to 2005 / 2008