|
��U S E [ C A R S D B ]
G O
/ * * * * * * O b j e c t : T a b l e [ d b o ] . [ c a r s ] S c r i p t D a t e : 0 8 / 1 5 / 2 0 0 9 0 9 : 3 1 : 1 7 * * * * * * /
S E T A N S I _ N U L L S O N
G O
S E T Q U O T E D _ I D E N T I F I E R O N
G O
S E T A N S I _ P A D D I N G O N
G O
C R E A T E T A B L E [ d b o ] . [ c a r s ] (
[ i d ] [ i n t ] I D E N T I T Y ( 1 , 1 ) N O T N U L L ,
[ m a k e ] [ n v a r c h a r ] ( 5 0 ) N U L L ,
[ m o d e l ] [ n v a r c h a r ] ( 5 0 ) N U L L ,
[ t y p e ] [ n v a r c h a r ] ( 1 0 0 ) N U L L ,
[ p i c t u r e ] [ v a r b i n a r y ] ( m a x ) N U L L ,
[ d o o r s ] [ i n t ] N U L L ,
[ g e a r s ] [ i n t ] N U L L ,
[ w e i g h t ] [ i n t ] N U L L ,
[ c o 2 ] [ n c h a r ] ( 1 0 ) N U L L ,
[ p r i c e ] [ d e c i m a l ] ( 1 8 , 2 ) N U L L ,
[ f u e l t y p e ] [ n v a r c h a r ] ( 2 0 ) N U L L ,
[ v e r s i o n ] [ t i m e s t a m p ] N U L L ,
C O N S T R A I N T [ P K _ c a r s ] P R I M A R Y K E Y C L U S T E R E D
(
[ i d ] A S C
) W I T H ( P A D _ I N D E X = O F F , S T A T I S T I C S _ N O R E C O M P U T E = O F F , I G N O R E _ D U P _ K E Y = O F F , A L L O W _ R O W _ L O C K S = O N , A L L O W _ P A G E _ L O C K S = O N ) O N [ P R I M A R Y ]
) O N [ P R I M A R Y ]
G O
S E T A N S I _ P A D D I N G O F F
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
I'm working since 1999 in an IT environment: started developing in PROGRESS 4GL, then VB6 and am working since 2003 with C#. I'm currently transitioning to HTML5, CSS3 and JavaScript for the front-end development.
I started my own company (TRI-S) in 2007 and co-founded another one (Cogenius) in 2012.
Besides being a Microsoft Certified Professional Developer (MCPD) I'm also a Microsoft Certified Trainer (MCT) and am teaching .NET and JavaScript courses.