syntex of insert

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the most common trace flags used with sql server?

528


Explain syntax for dropping triggers?

533


How to optimize stored procedures in sql server?

640


What is the meaning of lock escalation and why/how to stop this? : sql server database administration

621


Why the trigger fires multiple times in single login?

736






What is tabulation?

566


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1995


Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

533


what's new in sql server 2016?

567


What are the different authentication modes in sql server? How can it be changed?

577


What is difference between stored procedure and user defined function?

560


What is "scheduled jobs" or "scheduled tasks"?

566


How to write a query with a left outer join in ms sql server?

585


What is user-defined functions? What are the types of user-defined functions that can be created?

579


Explain having clause?

538