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
Can we do dml on views?
What is dknf in normalization form?
Explain what is the difference between union and union all?
What is raid and what are different types of raid levels?
New concepts of sql server 2005 use in your project.
How to see the event list of an existing trigger using sys.trigger_events?
Explain what are partitioned views and distributed partitioned views?
When would you use it?
What is explicit mode in sql server?
Explain how you can configure a running aggregate in SSRS?
why would you call update statistics? : Sql server database administration
What is a primary key?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
How would we use distinct statement? What is its use?
What is the maximum size per database for sql server express?