How to verify a user name with sqlcmd tool?

0 Answers  

---

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers  

---

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

0 Answers   Accenture,

---

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

0 Answers   Crown Solutions,

---

How get current date in SQL server 2000

6 Answers   Cap Gemini,

---

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

7 Answers   TCS,

---

How to recompile stored procedure at run time?

0 Answers  

---

Can Somebody tell me the difference between Clustered & Non- Clustered Index??

5 Answers   Progressive,

---

Mention the different types of replication in sql server.

0 Answers  

---

What is isolation levels?

0 Answers  

---

Does group by sort data?

0 Answers  

---

What is the difference between composite index and covering index?

0 Answers  

---