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
How does recursive cte works in sql server?
What programming language would you use to create embedded functions in ssrs?
Define right outer join?
How self join is different from outer join?
What is a coalesce function?
How does a profiler work?
What is rtm version in sql server?
What are the steps you must follow to hide sql server instances?
What are translations and its use? : sql server analysis services, ssas
What is compound operators?
Is foreign key a primary key?
Can you import Microsoft Excel data to SSRS?
Which tools are available to manage SQL Azure databases and servers?
What are pessimistic lock and optimistic lock?
What is merge statement?