If suppose in a table ship(name,year),find ship name having
first and last name(i.e having space in between)
ex: SAINT LOUIS,JET LAKE.
Answer Posted / suresh
select name,year
from ship
where name like '%,%';
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
List the types of recovery model available in sql server?
what is a schema in sql server 2005? : Sql server database administration
Where do we use trace frag?
How do I know if localdb is running?
What stored by the master?
How to get a list of columns in a view using the "sp_columns" stored procedure?
Explain time data type in sal server 2008?
How can I add Reporting Services reports to my application?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What is the function of inner join?
How to select some specific columns from a table in a query in ms sql server?
Why use “pivot” in sql server?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
Explain system views?
How extra digits are handled with numeric data type literals?