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 horizontal and vertical scaling?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
Which is better statement or preparedstatement?
What is a field in a table?
What is database replication? What are the different types of replication you can set up in sql server?
What is nolock hint in sql server 2008
How to convert character strings into numeric values?
What is the current limitation of the size of SQL Azure DB?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What is the data tier application?
What is 2nf in normalization?
What are binary string data types in ms sql server?
Why truncate is ddl?
What are ddl triggers and types of ddl trigger?
What is t-sql script to take database offline – take database online.