Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-04-23 : 07:36:24
|
| Dear all,i've a small doubt....i've a table like this....create table t(sno nchar(2))goinsert into t select 'Alt+9'(here i'm taking the value which is the output of press alt key with 9 and release).how can iget the exact result for this?i'm getting the question mark there when i'm selecting the data.for the rest of the characters, i'm getting the exact and expected resultVinodEven you learn 1%, Learn it with 100% confidence. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-23 : 07:38:46
|
What should "Alt+9" return?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-04-23 : 07:43:49
|
By Alt+9 I guess you want to save TAB character.INSERT INTO TSELECT CHAR(9) Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
insert statement conflict