Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 6832 Views
- I also Faced
- E-Mail Answers
Answer Posted / sandeep modapathi
select name from ship where where PATINDEX ('% %',name )>0
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to make conditional sum in ssrs?
What are the advantages of mirroring?
Can you explain what is sql server english query?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
Explain the database you used in your final year project?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
What is report subscription?
Explain about link server in sql server?
What are the advantages of log shipping?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
What is the index requirement in SQL Azure?
How much memory that we are using in Logshipping Concept?
What is sqlcmd?
Explain cursor as data base object?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
