Answer Posted / vanitha

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

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

What is replication and database mirroring?

1053

---

Define outer join?

1004

---

How to display a past time in days, hours and minutes?

1019

---

what is a mixed extent? : Sql server administration

1111

---

Define right outer join in sql server joins?

1055

---

Why should we go for stored procedures? Why not direct queries?

1105

---

What is raid? : SQL Server Architecture

1184

---

What are alternate keys?

985

---

What is the use of stored procedure?

943

---

How to implement service broker?

1017

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1113

---

What is index in an assignment?

960

---

explain different types of joins? : Sql server database administration

991

---

Where the sql logs gets stored? : sql server database administration

971

---

What’s the distinction between dropping a info and taking a info offline?

1041

---