in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
Answer Posted / muthu kumar
select * from emp where empname like '%j%'
Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
How do I debug a stored procedure in sql server?
what is a join? : Sql server database administration
When would you use the stored procedures or functions?
What is the purpose of update statistics and scope_identity() function?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
What is a subquery in a select query statement in ms sql server?
what is an extended stored procedure? : Sql server database administration
How to provide default values to stored procedure parameters?
what are the important architecture components of SSRS?
Which is faster statement or preparedstatement?
ow to bring suspect mode datbase online from scratch
Explain unique key in sql server?
How is sql used in sql server?
What is a rownum?
What is meant by indexing?