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
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
What is cube dimension? : sql server analysis services, ssas
Is it possible to have clustered index on separate drive from original table location?
What are the new features in sql server 2016?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
What is the difference between sdf and mdf?
What do you understand by physical_only option in dbcc checkdb?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
Why use “in” clause in sql server?
How can we use ConnectorJ JDBC Driver with MS SQL?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
how many type of indexing in database?
How to create function without parameter in sql server?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
How do I install only the client tools of sql server 2000?