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
- 6586 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
What is the difference between clustered and a non-clustered index?
How to create a dml trigger using create trigger statements?
How to get the definition of a stored procedure back?
Explain timestamp datatype?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
Explain difference between control flow and data flow?
Can you explain the disadvantages/limitation of the cursor?
Explain the rules for designing files and file groups in sql server?
Which tcp/ip port does the sql server run on? How can it be changed?
Why are you getting errors when creating a new odbc dsn?
Do you know what are acid properties of transaction?
How to send email from database?
When columns are added to existing tables, what do they initially contain?
What are cursors and when they are useful?
What are the basic features of a trigger in ms sql server?
