Click here to Skip to main content
15,867,308 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
Employee is a table, Ename is column. Write query to insert the text Jagan's Interview in Ename column
Posted
Comments
Prerak Patel 7-Nov-11 6:27am    
Not a question. Did you even try it?

try this

SQL
insert into Employee(Ename) values('jagan''s interview');
 
Share this answer
 
v2
Comments
thatraja 7-Nov-11 6:54am    
I think your answer is right one. OP asked this question because of '(Single quote)
5!
P.Salini 7-Nov-11 7:04am    
Thanks thatraja
Bala Selvanayagam 7-Nov-11 13:08pm    
5ed
P.Salini 7-Nov-11 23:28pm    
Thank you bala
Use this
SQL
INSERT INTO Employee(Ename) values('interview matter');
 
Share this answer
 
v2
SQL
INSERT INTO Employee(Ename) values('I am going to fail my exam if I dont do lots of revision');
 
Share this answer
 
v2
Comments
Mehdi Gholam 7-Nov-11 6:45am    
5'ed
thatraja 7-Nov-11 6:55am    
INSERT INTO Employee(Ename) values('I am going to fail my exam if I dont do lots of revision get any answers here');
FTFY :D
5!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900