what is the query and condition to delete datas in sql server.

what is the query and condition to delete datas in sql
server.

Question Posted / karthikeyan

Answers were Sorted based on User's Feedback

what is the query and condition to delete datas in sql server...

Answer / gunasekaran

delete from table_name where ( condition )

Is This Answer Correct ?

3 Yes

0 No

what is the query and condition to delete datas in sql server...

Answer / ram suresh.l

Delete (primarykey number ex:empid) from databasename

Is This Answer Correct ?

2 Yes

4 No

More SQL Server Interview Questions

what are the types of indexes? : Sql server database administration

Explain why variables called the most powerful component of ssis?

What are ddl (data definition language) statements for tables in ms sql server?

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

What is mean by dml?

What are the 3 types of schema?

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...

What is the dbcc command and why is it used?

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

How to create a large table with random data for index testing in ms sql server?

Can primary key be a foreign key?

How to disable a login name in ms sql server?

For more SQL Server Interview Questions Click Here