Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4561 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
How to recompile stored procedure at run time?
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.
What is dynamic cursor in SQL SERVER?
Explain primary key?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
How do you drop an index?
Can we join two tables without primary key?
What are the authentication modes in sql server? How can it be changed?
What is “asynchronous” communication in sql server service broker?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
how to avoid cursors? : Sql server database administration
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
Why is the need for data conversion transformations?
