select name,year from ship where name like '% %';

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.

Question Posted / challa yerriswamy

Answer Posted / challa yerriswamy

select name,year
from ship
where name like '% %';

Is This Answer Correct ?

10 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the limitations/drawbacks or ssrs 2008 r2?

152

Equi join and non equi join is possible with sql server?

1097

What are different types of replication in sql server?

1147

What is the process of normalization?

1182

How will you go about resolving deadlocks?

1036

How many servers can we create in a single subscription?

162

How do you test your database? : sql server database administration

1072

What are the advantages of partitioning?

1178

What is the difference between count () and rowcount ()?

1080

What is default constraint in ms sql server?

1106

Explain tables in SQL Azure?

122

What are the new scripting capabilities of ssms? : sql server management studio

1122

What is TDS(Tabular Data Stream) Gateway?

127

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1072

what is a schema in sql server 2005? : Sql server database administration

1083