Answer Posted / xyz

truncate basically clears the data from the rows of a
specified colomn.
e.g. truncate colomn_name from table_name
then this will only empty the colomn

delete is used to simpy delete anything from the table.
e.g. delete table_name
this will remove the whole table from the database.

what is a self join? Explain it with an example? : Sql server database administration

892

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1061

---

What is exporting and importing utility?

1030

---

What are security principals used in sql server 2005?

918

---

What is it’s similarity with sql server?

160

---

How do I save a stored procedure in sql server?

944

---

What is the use of @@spid?

965

---

Write a sql query to get zero records from a table having n number of records?

1139

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2287

---

What do you mean by recursive stored procedure?

891

---

Explain timestamp datatype?

922

---

What is tabulation?

902

---

What is Sqlpaging in SqlServer 2005 ?

1020

---

Can sql server 2016 run on windows 7?

869

---

What are the rendering extensions of ssrs?

144

---