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
What do you understand by coalesce in sql server?
How to use transact-sql statements to access the database engine?
How to set database to be read_only in ms sql server?
What is primary key, unique key, and foreign key?
what is database replication? : Sql server database administration
What does asynchronous call backs means?
Define synonym?
How you would rewrite the sql query to return the customerid sorted numerically?
What is the difference between having clause and where clause in sql server?
What are the ways available in sql server to execute sql statements?
What is the significance of null value and why should we avoid permitting null values?
What are the main differences between #temp tables and @table variables and which one is preferred?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
how you can deploy an ssrs report?
How does the report manager work in SSRS?
