Answer / Kranti Kumar

"The DELETE command in Microsoft SQL Server is used to remove records from a table. The syntax for the DELETE command is as follows:nDELETE FROM table_name WHERE condition;nIn this command, 'table_name' is the name of the table you want to delete records from, and 'condition' specifies which rows should be deleted."

How the authentication mode can be changed?

1 Answers  

---

How can I create a table from another table without copying any values from the old table?

3 Answers  

---

What are the types of sql server?

1 Answers  

---

i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj

9 Answers   IBM,

---

Explain features and concepts of analysis services?

1 Answers  

---

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1 Answers  

---

What is the difference between resultset and resultsetmetadata?

1 Answers  

---

Define outer join?

1 Answers  

---

How to insert multiple rows with a subquery?

1 Answers  

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

How can windows applications connect to sql servers via odbc?

1 Answers  

---

What is forward - only cursors / read only cursor?

1 Answers  

---