Consider the table T1 it consits
A,2,3,4
consider another table t2 it contain
1,2a,3a,4a
now i need o get the upadted answer
- 3 Answers
- 3681 Views
- I also Faced
- E-Mail Answers
Answer Posted / rakesh c sunagar
--select name from #t where ISNUMERIC(name)<>1
--union
--select name from #t1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the system database in sql server 2005?
What are the grouping functions?
What happens if strings are casted into wrong code pages in ms sql server?
What is sql injection? How to protect against sql injection attack?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What are recommended options to be used while using db mirroring? : sql server database administration
difference between Clustered index and non clustered index ?
Explain foreign key in sql server?
What are the advantages of using stored procedures?
Explain how to use linked server?
What is buffer cash and log cache in sql server?
What is tempdb in sql server?
what are the new features in SSRS?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
Why are you getting errors when creating a new odbc dsn?
