Explain the truncate command? : SQL Server Architecture

0 Answers  

---

Explain indexed views and partitioned view with their syntax.

0 Answers  

---

What is the main difference between ‘between’ and ‘in’ condition operators?

0 Answers  

---

How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?

3 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

---

What is extent? Types of extents?

0 Answers  

---

In which format does an image save in SQL Server database ?

0 Answers   MCN Solutions,

---

What is full outer join in sql server joins?

0 Answers  

---

how can we know that how many users are connected in perticuler server??????

2 Answers  

---

What is the use of floor function in sql server?

0 Answers  

---

Delete duplicate records from the table?(Table must have unique id)

7 Answers   TCS, Thomson Reuters,

---

Can foreign key be duplicate?

0 Answers  

---