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 is the difference between resultset and resultsetmetadata?
What functions can a view be used to performed?
What is the purpose of grouping data in a report?
What are .mdf files?
What are the different types of sub-queries?
What is the default Port No on which SQL Server listens?
What are subqueries in sql server? Explain its properties.
What is mscorsvw.exe - process - microsoft .net framework ngen?
What happens if strings are casted into wrong code pages in ms sql server?
How do you create type- insensitive operator?
Why are views required in the sql server or in any other database?
Explain what role entity and relationship play in an ER diagram.
What does ss stand for sexually?
What types of replication are supported in sql server?
What do you mean by sql server 2005 express management tools?