Answer Posted / poornima k

create table &t_name(&f_name1 &datatype1);

Call by value and call by reference in procedure and function, with NOCOPY.

1045

---

Explain the usage of floor function in sql server.

679

---

What is an entity-relationship diagram (erd)?

815

---

What is the ‘fillfactor’?

731

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

722

---

---

What is ms sql server reporting services?

726

---

What does the on delete cascade option do?

747

---

When I delete any data from a table, does the sql server reduce the size of that table?

760

---

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

844

---

List out what other servers you can use with ssrs?

115

---

What is the difference between count and distinct count?

624

---

How many types of attribute relationships are there? : sql server analysis services, ssas

776

---

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

657

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

812

---

What is the index requirement in SQL Azure?

86

---