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 difference between table aliases and column aliases? Do they affect performance?

1016

---

What are the restrictions that views have to follow? : SQL Server Architecture

1058

---

Explain forward - only cursors?

1127

---

Do you know the cursor optimization tips?

1035

---

What are parameterized reports?

204

---

Can you move the resources after pausing the node? : sql server database administration

1160

---

How to drop an existing table?

1049

---

List out different types of normalizations in sql server and explain each of them?

970

---

How can I check if a view exists in a sql server database?

1076

---

What are transactions in sql?

1128

---

How are the exceptions handled in sql server programming?

1116

---

What are the new features in sql server 2016?

1032

---

what are the new features in SSRS?

145

---

what's the difference between delete table and truncate table commands? : Sql server database administration

1037

---

What is provisioning, billing and metering, and connection routing concepts in the service layer?

115

---