Answer Posted / vanitha

insert into table tablename((field name datatype()))

Ex:
{
insert into table emp((eno int, ename varchar(10),eid int))
}

What is factless fact table? : sql server analysis services, ssas

1028

---

Do you know query execution plan?

1172

---

What is merge?

1018

---

How to get the definition of a view out of the sql server?

987

---

Tell me what is the stuff and how does it differ from the replace function?

981

---

What is clustered vs nonclustered index?

946

---

How do you implement session management in SQL Server mode?

1099

---

How can we use ConnectorJ JDBC Driver with MS SQL?

999

---

Why we use trigger in sql server with example?

959

---

How to download microsoft sql server 2005 express edition?

1047

---

What is the syntax for encrypting a column in SQL Server?

1120

---

Can I use sql azure as a backup with log shipping or database mirroring?

156

---

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1107

---

What is transaction server implicit?

1009

---

What are the different types of replication you can set up in sql server?

1052

---