--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

Find first and last day of current month in sql server

1028

What is difference between getdate and sysdatetime in sql server 2008?

1054

What is the name of the Database which IBM mainframe uses?

987

What are the three different part of rdl file explain them?

269

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

1270

What is the sql case statement used for? Explain with an example?

995

Explain the properties of the relational tables?

996

What are the advantages of using third-party tools?

998

What is bit data type?

1042

What is the use of sql profiler in sql server 2012?

900

How to rebuild the master database?

1082

explain declarative management framework (dmf) in sql server 2008?

998

What is the log shipping?

1010

What are the different types of indexes?

1120

List some advantages and disadvantages of stored procedure?

1016