Answer Posted / d

insert into (table name) values(fieldname datatype);


for ex:

insert into emp values(eno number(3),ename varchar2(20));

What are system databases in ms sql server?

966

---

How to get a list of all tables with "sys.tables" view in ms sql server?

982

---

what are user defined datatypes and when you should go for them? : Sql server database administration

961

---

How do triggers work?

879

---

How to create indexed view?

985

---

Explain Geography datatype in SQL Server

1060

---

What do I need to start working with sql studio? : sql server management studio

1049

---

Explain forward - only cursors?

980

---

Where are stored procedures in sql server?

1007

---

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1127

---

What is trace flag in sql server?

975

---

What are the indexes in sql server?

1023

---

What happens if the update subquery returns multiple rows in ms sql server?

1056

---

What are the disadvantages of using the stored procedures?

1017

---

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1987

---