Interested to Buy Any Domain ? << Click Here >> for more details...
in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
- 8 Answers
- 9357 Views
- I also Faced
- E-Mail Answers
Answer Posted / ashok
select * from Emp where name like '%j%'
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
How to update a field in SQL after ALTERING a row?
How does Report Builder support Analysis Services cubes?
How to delete existing triggers using "drop trigger"?
Why is normalisation important?
what types of replication are supported in sql server? : Sql server database administration
Is it possible to have clustered index on separate drive from original table location?
Differentiate between a having clause and a where clause.
How many replicas are maintained for each SQL Azure database?
What is executereader?
What is temporary table in sql server? Why we use temp table?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What are key, name and value columns of an attribute? : sql server analysis services, ssas
What are group functions in query statements in ms sql server?
How many triggers you can have on a table?
