Answer Posted / digvijay

yes, set is assign the value in declared variable.

exaple:--

declare @a int
set @a=20
@a hold the 20.

Explain a checkpoint?

1081

---

What is filter index?

988

---

What is the main purpose of having conversation group?

943

---

How to create a trigger for insert only?

1079

---

What are the dis_advantages of stored procedures, triggers, indexes?

2272

---

Can select statements be used on views in ms sql server?

1104

---

What are the advantages of user defined function?

1038

---

Define a cross join?

1081

---

What is self join in sql server joins?

1108

---

Do you know what is a with(nolock)?

1101

---

What is linked report?

137

---

What do you mean by the term 'normalization'?

1276

---

Explain Geometry datatype in sql server 2008 with example

1045

---

What does <> symbol mean?

1024

---

What is single-user mode?

978

---