Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by PeterHegRT
-
Connection without ODBC
Something I've noticed... If you have a plain old linked table, and you set up the linked table with a dsn, the dsn information gets embedded into the linked table and the link will still work if you delete the dsn. And will work from any other PC. Peter Hegarty (No Relation!)- PeterHegRT
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Length of Numeric Columns
I'm puzzled about the space used to store numbers. If you create the table... create table testN ( cInt integer ,cNum10 numeric(10,0) ,cNum8_2 numeric(8,2) ) and then do sp_help testN, you find that the integer takes 4 bytes, yet the numeric(10,0) takes 9, and the 8 with 2 dec...- PeterHegRT
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
