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 is full outer join in sql server joins?

981

---

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1017

---

How to provide column names in insert statements in ms sql server?

1071

---

How do you debug a procedure in sql server?

885

---

Mention the 3 ways to get a count of the number of records in a table.

916

---

What is user defined datatypes and when you should go for them?

962

---

Why olap is used?

914

---

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

919

---

How many tables can be joined in SQL Server?

1003

---

How to add an address record into adventureworkslt?

931

---

What is difference between foreign key and unique key?

960

---

What is table join?

1065

---

What is the difference between a check constraint and a rule?

1129

---

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

932

---

What is the full form of ddl?

864

---