Answer Posted / 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 |
Post New Answer View All Answers
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
Introduction of rollup clause using sum and group by clause?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What is a trigger? Why we need it?
What are four major operators that can be used to combine conditions on a where clause?
What stored by the master? : sql server database administration
How to write character string constants or literals in ms sql server?
Explain full-text indexing?
What is the concept of optimization?
What is failover clustering overview?
what are user defined datatypes and when you should go for them? : Sql server database administration
How to create a local temporary stored procedure?
What are built in functions?
What is use of except clause? How does it differ from not in clause?
Is it possible in sql table to have more than one foreign key?