in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
Answer Posted / ashok
select * from Emp where name like '%j%'
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
what are different types of backups available in sql server? : Sql server database administration
How to recompile stored procedure at run time?
What is a cache in ssrs?
How will you decide the active and passive nodes?
Name three of the features managed by the surface area configuration tool? : sql server security
How many replicas are maintained for each SQL Azure database?
Why is normalisation important?
Which language rdl files made of?
What are the differences between triggers and stored procedures?
How to enter date and time literals in ms sql server?
Name and describe few console utilities for ssrs?
What is cursors? And what are the different types of cursor?
How column data types are determined in a view?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
what are defaults? : Sql server database administration