Answer Posted / srinivas

insert into <table_name> ( <col1> ,<col3>) values ( val1,val2)

Explain about analysis services?

980

---

How to set database to be single_user in ms sql server?

967

---

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

963

---

What is difference between view and materialized view?

889

---

How to view existing indexes on an given table using sp_help?

1054

---

List the different types of collation sensitivities in sql server?

973

---

explain databases and sql server databases architecture? : Sql server database administration

909

---

How to modify the underlying query of an existing view?

931

---

What is filter index?

908

---

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1003

---

How to receive returning result from a query?

1035

---

What have included columns when we talk about sql server indexing?

989

---

What are the differences between union, intersect, and minus operators?

1018

---

How to encrypt data between dialogs?

1031

---

How to enforce security in sql server? : sql server security

1040

---