Answer Posted / mohan kumar.a
The main four query statements are:-
1.) select
ex:select * from table_name
2.) insert
ex:insert into table_name(c1,c2,c3...) values(v1,v2,v3..)
3.) delete
ex: delete * from table_name
4.) update
ex:update table_name
set col_name='value'
where col_name='something'
note:examples are based on ms sql server database.k
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What happens if you insert a duplicate key for the primary key column in ms sql server?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
Can you explain different types of joins?
What is outer join in sql server joins?
How to set the current database in ms sql server?
What are the differences between triggers and stored procedures?
What it means to be triggered?
What is the difference between coalesce() & isnull()?
Difference between primary key and clustered index?
Write a sql query to get zero records from a table having n number of records?
How to receive output values from stored procedures?
What are the built in functions in sql server?
what are database files and filegroups? : Sql server database administration
What is SQL Azure?
Can two different columns be merged into single column? Show practically?
