Answer / sreejith s t

In SQL 6.5 bit datatype supports only 0 and 1 ( true /
false ) . But in later versions it supports NULL also .

What are the types of processing and explain each? : sql server analysis services, ssas

0 Answers  

---

What are the advantages of sql stored procedure?

0 Answers  

---

how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.

6 Answers   IBM,

---

Explain user defined views?

0 Answers  

---

What is the syntax to execute the sys.dm_db_missing_index_details?

0 Answers  

---

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

What is the difference between HAVING clause and the WHERE clause?

7 Answers  

---

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 Answers  

---

Where do you think the users names and passwords will be stored in sql server?

4 Answers   BirlaSoft,

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

5 Answers   Aptech, HCL, Perpetual, SAIC,

---

Can we write trigger for view?

0 Answers  

---

What are the advantages of using a stored procedure?

0 Answers  

---