|
��U S E [ D W _ D A T A M A R T ]
G O
/ * * * * * * O b j e c t : T a b l e [ d b o ] . [ D i m T i m e ] S c r i p t D a t e : 0 4 / 0 8 / 2 0 0 8 1 4 : 5 5 : 1 1 * * * * * * /
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 ] . [ D i m T i m e ] (
[ D i m T i m e K e y ] [ i n t ] N O T N U L L ,
[ T i m e ] [ v a r c h a r ] ( 5 0 ) N O T N U L L ,
[ T i m e 2 4 ] [ v a r c h a r ] ( 5 0 ) N O T N U L L ,
[ H o u r ] [ t i n y i n t ] N O T N U L L ,
[ H o u r N a m e ] [ v a r c h a r ] ( 1 0 ) N O T N U L L ,
[ M i n u t e ] [ t i n y i n t ] N O T N U L L ,
[ M i n u t e K e y ] [ i n t ] N O T N U L L ,
[ M i n u t e N a m e ] [ v a r c h a r ] ( 2 0 ) N O T N U L L ,
[ S e c o n d ] [ t i n y i n t ] N O T N U L L ,
[ H o u r 2 4 ] [ t i n y i n t ] N O T N U L L ,
[ A M ] [ c h a r ] ( 2 ) N O T N U L L ,
C O N S T R A I N T [ P K _ D i m T i m e ] P R I M A R Y K E Y C L U S T E R E D
(
[ D i m T i m e K e y ] 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.
Igor is a business intelligence consultant working in Tampa, Florida. He has a BS in Finance from University of South Carolina and Masters in Information Management System from University of South Florida. He also has following professional certifications: MCSD, MCDBA, MCAD.