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 |
|
siumui
Yak Posting Veteran
54 Posts |
 Posted - 2012-03-14 : 09:13:18
|
| Hello all.What happen when you Insert a non-numeric data type into a numeric data type column?I insert values into a column below and it didn't give me any error. id column is numeric.INSERT INTO myTable (id) VALUES (123/4321)Thankssiumui |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-03-14 : 09:21:00
|
123/4321 is treated as 123 devided by 4321
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
siumui
Yak Posting Veteran
54 Posts |
Posted - 2012-03-14 : 09:26:17
|
| Got it.Thanks webfred!siumui |
|
|
|
|
|
|
INSERT