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;
}

What's the information that can be stored inside a bit column?

996

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

951

---

Why can there be only one clustered index and not more than one?

998

---

what is blocking? : Sql server database administration

1033

---

Explain having clause?

958

---

Explain the use of containers in ssis and also their types?

965

---

How many types of database relationship in sql server?

1050

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1138

---

What is sql collation?

1200

---

How to encrypt data between dialogs?

1100

---

which table keeps the locking information? : Sql server administration

1074

---

What is a transactions?

1035

---

What is optimization and its types?

967

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

948

---

Do you know how to implement service broker?

928

---