Answer Posted / rahul

Local Variables are declared within the function main.

main()
{
int a,b,c;(local variable declaration)

}
Global variables are declared outside the function main.

int FACT(int);
main()
{
Local variable declaration;
}

Is null vs coalesce?

882

---

role of sql sever 2005 in database rather than any other database

1940

---

How you would rewrite the sql query to return the customerid sorted numerically?

998

---

How do I start and stop sql server?

1020

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1034

---

Why do you need a sql server?

1108

---

Where the sql logs gets stored? : sql server database administration

964

---

List out a number of the wants to setup a SQL Server failover cluster?

1073

---

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1888

---

Explain about nested stored procedure?

1029

---

Explain hostprotectionattribute in sql server 2005?

1028

---

Explain the benefits of user-defined functions?

1062

---

How many servers can we create in a single subscription?

162

---

what is a transaction? : Sql server database administration

992

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

962

---