Answer Posted / digvijay

yes, set is assign the value in declared variable.

exaple:--

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

What is truncate table?

542

---

How do I completely remove sql server instance?

553

---

What is data modification?

503

---

Do you know what is xpath?

550

---

what are different types of raid configurations? : Sql server database administration

478

---

---

Characterize join and name diverse sorts of joins?

522

---

How can we get count of the number of records in a table?

530

---

What is sql server profiler?

558

---

What is federation member?

91

---

What is oltp (online transaction processing)?

577

---

What is wide table?

523

---

What is apply operator in sql?

554

---

What method is used by the Command classes to execute SQL statements that return single values?

590

---

How to create a user to access a database in ms sql server using "create user" statements?

512

---

What are the elements of dbms?

535

---