Answer / meena kurade

Bit datatype is used to store boolean information like 1 or
0 (true or
false). Untill SQL Server 6.5 bit datatype could hold either
a 1 or 0
and there was no support for NULL. But from SQL Server 7.0
onwards,
bit datatype can represent a third state, which is NULL.

Answer / sreejith s t

Bit is used to store boolean values . It stores 0 , 1 and
NULL .

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

0 Answers   Value Labs,

---

Explain the collation?

0 Answers  

---

What are the limitation of the Online Index Rebuild Operation?

1 Answers  

---

Write the SQL query to drop, truncate and delete table.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

find 2nd highest salary of person using cursor concept?

6 Answers   HCL,

---

What is SQL Profiler and the use of it?

2 Answers   247Customer,

---

how to delete duplicate rows from table in sql server

12 Answers   HCL, UHG,

---

What is the name of the Database which IBM mainframe uses?

0 Answers   Wipro,

---

What is partitioned view?

0 Answers  

---

Do you know what are various aggregate functions that are available?

0 Answers  

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

3 Answers   SAP Labs,

---