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 is the definition for sql server 2000?
What are click through reports?
What are the restrictions that views have to follow?
What is the default fill factor value?
What do you know about system database? : SQL Server Architecture
What is usually the first word in a sql query?
Do you know what are pages and extents? : SQL Server Architecture
Can two different columns be merged into single column? Show practically?
What is meant by indexing files?
How we can compare two database data?
What is a matrix in ssrs?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
What are the database objects? : SQL Server Architecture
Why use update_statistics command in sql server?
You want to implement the many-to-many relationship while designing tables. How would you do it?