syntex of insert

Answer Posted / vanitha

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

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

Is This Answer Correct ?    1 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe how to use the linked server?

589


What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

542


What is the query and subquery?

612


Explain what is the function of sql server agent windows service?

540


How do I find the sql server instance name?

526






Which are the important points to note when multilanguage data is stored in a table?

510


How to create function without parameter in sql server?

554


how you can list all the tables in a database?

519


What does it mean to normalize a database and why would you do it?

520


Why the trigger fires multiple times in single login?

715


What is importing utility?

542


Are null values the same as that of zero or a blank space?

567


What are different types of join?

756


What is the process of normalising?

581


What is a primary index?

518