Answer / gunasekaran

delete from table_name where ( condition )

Answer / ram suresh.l

Delete (primarykey number ex:empid) from databasename

How to filter out duplications in the returning rows in ms sql server?

0 Answers  

---

What is the difference between indexing and hashing?

0 Answers  

---

What is the correct order of the logical query processing phases?

0 Answers  

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

How do you persist objects, permissions in tempdb

1 Answers  

---

---

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

0 Answers  

---

What is query optimization process?

0 Answers  

---

explain query execution plan

1 Answers  

---

What is subquery in sql?

0 Answers  

---

what is the signification difference of this bit data type between sql 6.5 and later version sql server?

1 Answers  

---

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 Answers  

---

What is resource governor?

0 Answers  

---