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 |
|
tech1234
Starting Member
4 Posts |
 Posted - 2010-08-01 : 12:33:47
|
| HiI am creating a db that includes a part number that is alpha numeric, ez ER123. What data type should I set it please.Thanks in advance |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-08-01 : 13:31:25
|
varchar(length)length can be for example 25
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
tech1234
Starting Member
4 Posts |
Posted - 2010-08-01 : 13:39:20
|
| Thanks, One last question. how do you insert images in the field with data type image. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-08-01 : 13:45:00
|
I've never done that.I am storing images in file system and the path in the database.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
tech1234
Starting Member
4 Posts |
Posted - 2010-08-01 : 14:08:54
|
| Thats ok, Thanks anyway. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-08-01 : 14:52:54
|
IMAGE is deprecated. Use VARBINARY(MAX) instead.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
|
|
|
data type