Answer Posted / poornima k

create table &t_name(&f_name1 &datatype1);

Difference between Sql server reporting services and Crystal reports?

124

---

What factors you will consider calculating the storage requirement for that view?

536

---

Write an sql query for deleting duplicate rows?

547

---

What happens when converting big values to numeric data types?

561

---

How do I create a stored procedure in sql server?

512

---

---

What is the difference between clustered and non-clustered indexes in ms sql server?

482

---

What are dml (data manipulation language) statements in ms sql server?

546

---

What purpose does the model database server?

650

---

What is tempdb database? : SQL Server Architecture

598

---

How many types of built in functions are there in sql server 2012?

485

---

Which data type columns are the best candidates for full-text indexing?

594

---

What is raid, and how it can influence database performance?

568

---

What is truncate table?

544

---

Explain sql server authentication modes?

602

---

What is subquery in sql?

566

---