--select name from #t where ISNUMERIC(name)<>1 --union --select nam

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

Question Posted / rakesh c sunagar

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

Please Help Members By Posting Answers For Below Questions

How to count groups returned with the group by clause in ms sql server?

1142

explain different types of backups avaialabe in sql server? : Sql server database administration

1034

What is function of CUBE ?

1076

Do you know what is a trace frag? Where do we use it?

1040

Write a sql query to sort on different column name according to the parameters passed in the function?

962

What are types of scd? : sql server analysis services, ssas

1077

What is sql server english query?

1198

What is nested transaction?

1137

How will you go about resolving deadlocks?

1033

What are cursors stored procedures and triggers?

1082

What is a unique key constraint?

1086

Tell me what do we need queues in sql service broker?

1051

what are the new features in SSRS?

145

How retrieve field names from the table in SQL through JAVA code?

1957

Explain transaction server explicit transaction?

972