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
- 4670 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 different normalization forms?
How to generate random numbers with the rand() function in ms sql server?
What is an execution plan? When would you use it?
What is merge statement?
What are pessimistic lock and optimistic lock?
Explain intellisense for query editing
Explain trigger classes i.e. Instead of and after trigger?
How to use values from other tables in update statements in ms sql server?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
When cursors are useful?
What is inline variable assignment?
Can a synonym name of a table be used instead of a table name in a select statement?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
When would you use a before or after trigger?
What does COMMIT command do?
