Answer / sapna

select,insert,update ,delete

Answer / ruchi

The main four query statements are:-
(a) SELECT
(b) INSERT
(c) DELECT
(d) UPDATE

Answer / vikas

1)select
2)insert
3)update
4)delete

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

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

Answer / chandra kumar

All congraces members are currupt,mostly of them are choor
baymaan and bhrast.

Answer / vikas

Create,insert,select,update

What is Stored Procedure? What is Views in sql server? Difference between a User Defined Function and a Stored Procedure Difference between a primary key and a unique key? What is a join and explain different types of joins. Difference between temp table and table variable Difference between Triggers and Stored Procedures Difference between UNION ALL Statement and UNION What is COALESCE / Why do we use COALESCE? Why we use SET ROWCOUNT in Sql How many clustered index can have a table How many types of local tables in SQL SERVER Difference between DELETE and TRUNCATE What is Aggregate Functions? What is Row_Number()? What are Ranking Functions? What is NOLOCK? What is CTE? What are the Advantages of using CTE? What is the STUFF function and how does it differ from the REPLACE function? What are the difference between clustered and a non-clustered index? What are the different index configurations a table can have? Difference between a HAVING CLAUSE and a WHERE CLAUSE? Difference between SET and SELECT Provide all the built in string function of SQL SERVER Difference between char and varchar data types Define candidate key, alternate key, composite key. What are constraints? Explain different types of constraints. What is a self join? Explain it with an example. How will you convert table row to a column comma separated value

4 Answers   ACS,

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

How to a Query to copy data from on table to another table.

6 Answers   Cap Gemini,

What are the advantages of using stored procedures in sql server?

0 Answers  

Tell me what is the order in which the sql query is executed?

0 Answers  

What are the advantages of policy management?

0 Answers  

What is use of dbcc commands?

0 Answers  

What is difference between stored procedure and user defined function?

0 Answers  

What is SQL Server?

0 Answers   Atos Origin,

Can a database be shrunk with users active?

0 Answers  

What is Covering Indexes? Plz explain with example

3 Answers  

Explain temporary table vs table variable by using cursor alternative?

0 Answers