Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


syntex of insert

Answers were Sorted based on User's Feedback



syntex of insert..

Answer / mahathi

insert into tablename (col1,col2,........) values
(val1,val2,........)

Is This Answer Correct ?    9 Yes 1 No

syntex of insert..

Answer / dk

Insert into tablename (c1,c1,c3,...) values(v1,v2,v3,...)

and we can also use
Insert into tablename values(v1,v2,v3,...)
but in this we must have to know numbers of columns and we
have to insert values for all not null columns

Is This Answer Correct ?    2 Yes 1 No

syntex of insert..

Answer / d

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


for ex:

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

Is This Answer Correct ?    0 Yes 0 No

syntex of insert..

Answer / jasmeet kaur

insert into table_name("column_name1","column_name2")
value("value1","value2")

Is This Answer Correct ?    0 Yes 0 No

syntex of insert..

Answer / gajanan.waghode

INSERT INTO table[(cloumn [,cloumn...])]
VALUES (value[,value...]);

with this syntax only one row is inserted at a time.

Is This Answer Correct ?    0 Yes 0 No

syntex of insert..

Answer / s

insert table <tablename>(col1,col2,.)values(..)

Is This Answer Correct ?    0 Yes 2 No

syntex of insert..

Answer / 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

More SQL Server Interview Questions

How can I create a new template for import ? : sql server management studio

0 Answers  


What is row_number () and partition by in sql server?

0 Answers  


What is row_number function?

0 Answers  


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

0 Answers  


Difference between report and query parameter.

0 Answers  


How to connect php with different port numbers?

0 Answers  


Explain filtered indexes benefits?

0 Answers  


What is the difference between ‘having’ clause and a ‘where’ clause?

0 Answers  


Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  


What is a trigger in sql server?

0 Answers  


what's the difference between a primary key and a unique key? : Sql server database administration

0 Answers  


How do I shrink an ldf file?

0 Answers  


Categories