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 |
How do we return a record set from a Stored Procedure in SQl server 2000?
How we can refresh the view?
Which command using Query Analyzer will give you the version of SQL server and operating system?
What is difference between rownum and rowid?
What are the new features in SQL Server 2005?
What is a print index?
Write a SQL query to delete a table?
What is the difference between indexing and hashing?
What is an active database?
Does order by actually change the order of the data in the tables or does it just change the output?
How many types of system privileges are there, Can we add or delete privileges?
How to enter comments in transact-sql statements?