Answer Posted / thiyagaraj.ramaswamy

Local Variable :
The scope or lifetime of the local variable
is with in a block or procedure..
Eg: DECLARE @Variable1

Global Variable :
The scope or lifetime of the global
variable throughout the execution of the program..
Eg: DECLARE @@Variable1

What is the difference between a stored procedure and a user defined function?

1020

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

2076

---

what's the maximum size of a row? : Sql server database administration

1088

---

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1251

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

1518

---

System requirements for sql server 2005 express edition?

1027

---

Can you always create a cache of a report?

172

---

Do I need a report server to run reports in my application?

165

---

How to provide values to user defined function parameters?

1008

---

Do you know how to make remote connection in database?

965

---

Can you explain what is indexed view? How to create it?

908

---

Explain different types of collation sensitivity?

982

---

How to create median function?

164

---

How to replace null values in expressions using isnull()?

1102

---

What is the default value of an integer data type in sql server 2005?

953

---