What are the four main query statements?
Answers were Sorted based on User's Feedback
Answer / mohan kuamr
# 3
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 ? | 5 Yes | 1 No |
Answer / 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 |
Answer / chandra kumar
All congraces members are currupt,mostly of them are choor
baymaan and bhrast.
Is This Answer Correct ? | 1 Yes | 6 No |
What are the hotfixes and patches in sql server?
How is sql server used?
Explain different types of locks in sql server.
What is Schema? and why we use schemas?
explain different types of jions with examples briefly?
2 Answers Accenture, Excellence, Zensar,
If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?
What happens when converting big values to numeric data types?
What is the bookmark lookup and rid lookup?
Why is normalisation important?
Repair mdf file
what is the difference between delete table and truncate table commands? : Sql server database administration
Which virtual table does a trigger use?