--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 recompile stored procedure at run time?

1005

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2024

What is dynamic cursor in SQL SERVER?

1000

Explain primary key?

897

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

995

How do you drop an index?

861

Can we join two tables without primary key?

978

What are the authentication modes in sql server? How can it be changed?

1051

What is “asynchronous” communication in sql server service broker?

958

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

991

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

958

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

882

how to avoid cursors? : Sql server database administration

901

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

940

Why is the need for data conversion transformations?

977