|
|
��< H T M L > < H E A D >
< M E T A N A M E = " C O P Y R I G H T " C O N T E N T = " 2 0 0 8 � P a w J e r s h a u g e " >
< M E T A N A M E = " D E S C R I P T I O N " C O N T E N T = " T h i s s i t e c o n t a i n s i n f o r m a t i o n a b o u t t h e S Q L R e a d e r C l a s s L i b r a r y . " >
< M E T A N A M E = " A U T H O R " C O N T E N T = " P a w J e r s h a u g e " >
< M E T A N A M E = " C O D I N G " C O N T E N T = " P a w J e r s h a u g e " >
< M E T A N A M E = " D E V E L O P E R " C O N T E N T = " P a w J e r s h a u g e [ h t t p : / / p a w . j e r s h a u g e . d k ] " >
< M E T A N A M E = " G E N E R A T O R " C O N T E N T = " A s s e m b l y T o H T M L b y P a w J e r s h a u g e " >
< L I N K R E L = " S T Y L E S H E E T " T Y P E = " T E X T / C S S " H R E F = " . . / d a t / m s d n 2 . c s s " > < / L I N K > < S C R I P T L A N G U A G E = " J a v a s c r i p t 1 . 2 " S R C = " . . / d a t / j s c r . j s " > < / S C R I P T >
< T I T L E > S Q L R e a d e r b y P a w J e r s h a u g e < / T I T L E > < / H E A D > < B O D Y C L A S S = " t y p e c l a s s " o n u n l o a d = " w o ( ' . . / t o o l b a r . h t m ' , ' T O O L B A R ' ) ; C u r r e n t O b j e c t ( ' . . . ' ) ; " >
< P C L A S S = " m e d i u m " > < I M G S R C = " . . / i m g / m i n u s . g i f " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d m g R " I D = " c o l l a p s e _ e x p a n d i m g " N A M E = " c o l l a p s e _ e x p a n d i m g " > < A N A M E = " c o l l a p s e _ e x p a n d " h r e f = " # c o l l a p s e _ e x p a n d " o n c l i c k = " p l u s m i n u s t g l c o n t e n t s h o w i n g ( ) ; t g l C o n t e n t ( ) ; " C L A S S = " l i k e t e x t " > C o l l a p s e / E x p a n d c o n t e n t < / A > < / P >
S Q L R e a d e r C l a s s L i b r a r y
< H 1 > C o l u m n P u b l i c C l a s s < / H 1 >
< P > < B > N a m e s p a c e : < / B > < A H R E F = " S Q L R e a d e r . h t m " > S Q L R e a d e r < / A > < / P >
< P > < B > A s s e m b l y : < / B > < A H R E F = " S Q L R e a d e r ( 1 . 0 . 0 . 0 ) . h t m " > S Q L R e a d e r < / A > ( i n S Q L R e a d e r . d l l ) < / P >
< P > < B > B a s e t y p e ( s ) : < / B > < A H R E F = " S Q L R e a d e r . A b s t r a c t S Q L O b j e c t . h t m " T A R G E T = " _ s e l f " > S Q L R e a d e r . A b s t r a c t S Q L O b j e c t < / A > < / P >
< H 3 > I n t h i s d o c u m e n t t h e f o l l o w i n g h i g h l i g h t a r e a v a i l a b l e : < / H 3 >
< U L > < L I > < A H R E F = " # A N A M E _ P r o p e r t y B o x " > P r o p e r t i e s ( 3 5 ) < / A > < / L I > < L I > < A H R E F = " # A N A M E _ S e e A l s o _ R e f B o x " > S e e a l s o < / A > < / L I > < / U L > < A N A M E = " A N A M E _ P r o p e r t y B o x " > < / A > < H 2 C L A S S = " c l k " o n c l i c k = " p l u s m i n u s t g l ( ' P r o p e r t y B o x ' ) ; " > < I M G S R C = " . . / i m g / m i n u s . g i f " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d m g R " I D = " P r o p e r t y B o x I m g " N A M E = " P r o p e r t y B o x I m g " > P r o p e r t i e s < / H 2 >
< T A B L E C E L L P A D D I N G = " 0 " C E L L S P A C I N G = " 0 " B O R D E R = " 0 " W I D T H = " 1 0 0 % " I D = " P r o p e r t y B o x " N A M E = " P r o p e r t y B o x " > < T R > < T D C L A S S = " t d h e a d " > & n b s p ; < / T D > < T D C L A S S = " t d h e a d " > N a m e < / T D > < T D C L A S S = " t d h e a d " > T y p e < / T D > < T D C L A S S = " t d h e a d " > D e s c r i p t i o n < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > c o l l a t i o n _ n a m e < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . S t r i n g . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > S t r i n g < / A > < / T D > < T D C L A S S = " t d i t e m " > N a m e o f t h e c o l l a t i o n o f t h e c o l u m n i f c h a r a c t e r - b a s e d ; o t h e r w i s e , N U L L & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > c o l u m n _ i d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . I n t 3 2 . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > I n t 3 2 < / A > < / T D > < T D C L A S S = " t d i t e m " > I D o f t h e c o l u m n . I s u n i q u e w i t h i n t h e o b j e c t .
C o l u m n I D s m i g h t n o t b e s e q u e n t i a l & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > d e f a u l t _ o b j e c t _ i d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . I n t 3 2 . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > I n t 3 2 < / A > < / T D > < T D C L A S S = " t d i t e m " > I D o f t h e d e f a u l t o b j e c t , r e g a r d l e s s o f w h e t h e r i t i s a s t a n d - a l o n e o b j e c t s y s . s p _ b i n d e f a u l t [ h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / m s 1 7 7 5 0 3 ( p r i n t e r ) . a s p x ] , o r a n i n l i n e , c o l u m n - l e v e l D E F A U L T c o n s t r a i n t . T h e p a r e n t _ o b j e c t _ i d c o l u m n o f a n i n l i n e c o l u m n - l e v e l d e f a u l t o b j e c t i s a r e f e r e n c e b a c k t o t h e t a b l e i t s e l f .
0 = N o d e f a u l t & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > D e f a u l t C o n s t r a i n t < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " S Q L R e a d e r . D e f a u l t C o n s t r a i n t . h t m " T A R G E T = " _ s e l f " C L A S S = " a R e f " > D e f a u l t C o n s t r a i n t < / A > < / T D > < T D C L A S S = " t d i t e m " > & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > D e s c r i p t i o n < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . S t r i n g . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > S t r i n g < / A > < / T D > < T D C L A S S = " t d i t e m " > & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > E x t P r o p e r t i e s < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " S Q L R e a d e r . E x t e n d e d P r o p e r t y . h t m " T A R G E T = " _ s e l f " C L A S S = " a R e f " > E x t e n d e d P r o p e r t y [ ] < / A > < / T D > < T D C L A S S = " t d i t e m " > & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > F o r e i g n K e y < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " S Q L R e a d e r . f o r e i g n _ k e y . h t m " T A R G E T = " _ s e l f " C L A S S = " a R e f " > f o r e i g n _ k e y < / A > < / T D > < T D C L A S S = " t d i t e m " > & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > F o r e i g n K e y C o l u m n < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " S Q L R e a d e r . f o r e i g n _ k e y _ c o l u m n . h t m " T A R G E T = " _ s e l f " C L A S S = " a R e f " > f o r e i g n _ k e y _ c o l u m n < / A > < / T D > < T D C L A S S = " t d i t e m " > & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > I d e n t i t y < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " S Q L R e a d e r . I d e n t i t y C o l u m n . h t m " T A R G E T = " _ s e l f " C L A S S = " a R e f " > I d e n t i t y C o l u m n < / A > < / T D > < T D C L A S S = " t d i t e m " > & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > i s _ a n s i _ p a d d e d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B o o l e a n . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B o o l e a n < / A > < / T D > < T D C L A S S = " t d i t e m " > 1 = C o l u m n u s e s A N S I _ P A D D I N G O N b e h a v i o r i f c h a r a c t e r , b i n a r y , o r v a r i a n t .
0 = C o l u m n i s n o t c h a r a c t e r , b i n a r y , o r v a r i a n t & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > i s _ c o m p u t e d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B o o l e a n . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B o o l e a n < / A > < / T D > < T D C L A S S = " t d i t e m " > 1 = C o l u m n i s a c o m p u t e d c o l u m n & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > i s _ d t s _ r e p l i c a t e d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B o o l e a n . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B o o l e a n < / A > < / T D > < T D C L A S S = " t d i t e m " > 1 = C o l u m n i s r e p l i c a t e d b y u s i n g S Q L S e r v e r 2 0 0 5 I n t e g r a t i o n S e r v i c e s ( S S I S ) & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > i s _ f i l e s t r e a m < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B o o l e a n . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B o o l e a n < / A > < / T D > < T D C L A S S = " t d i t e m " > R e s e r v e d f o r f u t u r e u s e & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > i s _ i d e n t i t y < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B o o l e a n . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B o o l e a n < / A > < / T D > < T D C L A S S = " t d i t e m " > 1 = C o l u m n h a s i d e n t i t y v a l u e & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > i s _ m e r g e _ p u b l i s h e d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B o o l e a n . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B o o l e a n < / A > < / T D > < T D C L A S S = " t d i t e m " > 1 = C o l u m n i s m e r g e - p u b l i s h e d & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > i s _ n o n _ s q l _ s u b s c r i b e d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B o o l e a n . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B o o l e a n < / A > < / T D > < T D C L A S S = " t d i t e m " > 1 = C o l u m n h a s a n o n - S Q L S e r v e r s u b s c r i b e r & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > i s _ n u l l a b l e < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B o o l e a n . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B o o l e a n < / A > < / T D > < T D C L A S S = " t d i t e m " > 1 = C o l u m n i s n u l l a b l e & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > i s _ r e p l i c a t e d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B o o l e a n . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B o o l e a n < / A > < / T D > < T D C L A S S = " t d i t e m " > 1 = C o l u m n i s r e p l i c a t e d & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > i s _ r o w g u i d c o l < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B o o l e a n . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B o o l e a n < / A > < / T D > < T D C L A S S = " t d i t e m " > 1 = C o l u m n i s a d e c l a r e d R O W G U I D C O L & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > i s _ x m l _ d o c u m e n t < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B o o l e a n . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B o o l e a n < / A > < / T D > < T D C L A S S = " t d i t e m " > 1 = C o n t e n t i s a c o m p l e t e X M L d o c u m e n t .
0 = C o n t e n t i s a d o c u m e n t f r a g m e n t o r t h e c o l u m n d a t a t y p e i s n o t x m l & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > I s F o r e i g n K e y < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B o o l e a n . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B o o l e a n < / A > < / T D > < T D C L A S S = " t d i t e m " > & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > I s P r i m a r y K e y < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B o o l e a n . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B o o l e a n < / A > < / T D > < T D C L A S S = " t d i t e m " > & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > m a x _ l e n g t h < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . I n t 1 6 . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > I n t 1 6 < / A > < / T D > < T D C L A S S = " t d i t e m " > M a x i m u m L e n g t h ( i n b y t e s ) o f t h e c o l u m n .
- 1 = C o l u m n d a t a t y p e i s v a r c h a r ( m a x ) , n v a r c h a r ( m a x ) , v a r b i n a r y ( m a x ) , o r x m l .
F o r t e x t c o l u m n s , t h e m a x _ l e n g t h v a l u e w i l l b e 1 6 o r t h e v a l u e s e t b y s p _ t a b l e o p t i o n ' t e x t i n r o w ' & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > n a m e < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . S t r i n g . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > S t r i n g < / A > < / T D > < T D C L A S S = " t d i t e m " > N a m e o f t h e c o l u m n . I s u n i q u e w i t h i n t h e o b j e c t & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > o b j e c t _ i d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . I n t 3 2 . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > I n t 3 2 < / A > < / T D > < T D C L A S S = " t d i t e m " > I D o f t h e o b j e c t t o w h i c h t h i s c o l u m n b e l o n g s & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c V i r t u a l P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > O b j e c t N a m e < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . S t r i n g . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > S t r i n g < / A > < / T D > < T D C L A S S = " t d i t e m " > & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > O w n e r < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " S Q L R e a d e r . C o l u m n s . h t m " T A R G E T = " _ s e l f " C L A S S = " a R e f " > C o l u m n s < / A > < / T D > < T D C L A S S = " t d i t e m " > & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > p r e c i s i o n < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B y t e . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B y t e < / A > < / T D > < T D C L A S S = " t d i t e m " > P r e c i s i o n o f t h e c o l u m n i f n u m e r i c - b a s e d ; o t h e r w i s e , 0 & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > r u l e _ o b j e c t _ i d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . I n t 3 2 . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > I n t 3 2 < / A > < / T D > < T D C L A S S = " t d i t e m " > I D o f t h e s t a n d - a l o n e r u l e b o u n d t o t h e c o l u m n b y u s i n g s y s . s p _ b i n d r u l e .
0 = N o s t a n d - a l o n e r u l e . F o r c o l u m n - l e v e l C H E C K c o n s t r a i n t s , s e e s y s . c h e c k _ c o n s t r a i n t s ( T r a n s a c t - S Q L ) [ h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / m s 1 8 7 3 8 8 ( p r i n t e r ) . a s p x ] & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > s c a l e < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B y t e . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B y t e < / A > < / T D > < T D C L A S S = " t d i t e m " > S c a l e o f c o l u m n i f n u m e r i c - b a s e d ; o t h e r w i s e , 0 & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > s y s t e m _ t y p e < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " S Q L R e a d e r . S Q L _ T y p e . h t m " T A R G E T = " _ s e l f " C L A S S = " a R e f " > S Q L _ T y p e < / A > < / T D > < T D C L A S S = " t d i t e m " > & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > s y s t e m _ t y p e _ i d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . B y t e . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > B y t e < / A > < / T D > < T D C L A S S = " t d i t e m " > I D o f t h e s y s t e m t y p e o f t h e c o l u m n & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c V i r t u a l P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > U n i q u e O b j e c t N a m e < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . S t r i n g . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > S t r i n g < / A > < / T D > < T D C L A S S = " t d i t e m " > & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > u s e r _ t y p e _ i d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . I n t 3 2 . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > I n t 3 2 < / A > < / T D > < T D C L A S S = " t d i t e m " > I D o f t h e t y p e o f t h e c o l u m n a s d e f i n e d b y t h e u s e r .
T o r e t u r n t h e n a m e o f t h e t y p e , j o i n t o t h e s y s . t y p e s [ h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / m s 1 8 8 0 2 1 ( p r i n t e r ) . a s p x ] c a t a l o g v i e w o n t h i s c o l u m n & n b s p ; < / T D > < / T R >
< T R > < T D C L A S S = " t d i t e m i m g " > < I M G S R C = " . . / o b j i m g / P r o p e r t i e s . p n g " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d " T I T L E = " P u b l i c P r o p e r t y " > < / T D > < T D C L A S S = " t d i t e m " n o w r a p > x m l _ c o l l e c t i o n _ i d < / T D > < T D C L A S S = " t d i t e m " > < A H R E F = " h t t p : / / m s d n 2 . m i c r o s o f t . c o m / e n - u s / l i b r a r y / S y s t e m . I n t 3 2 . a s p x " T A R G E T = " _ b l a n k " C L A S S = " a R e f " > I n t 3 2 < / A > < / T D > < T D C L A S S = " t d i t e m " > N o n z e r o i f t h e d a t a t y p e o f t h e c o l u m n i s x m l a n d t h e X M L i s t y p e d . T h e v a l u e w i l l b e t h e I D o f t h e c o l l e c t i o n c o n t a i n i n g t h e v a l i d a t i n g X M L s c h e m a n a m e s p a c e o f t h e c o l u m n .
0 = N o X M L s c h e m a c o l l e c t i o n & n b s p ; < / T D > < / T R >
< / T A B L E >
< H 2 C L A S S = " c l k " o n c l i c k = " p l u s m i n u s t g l ( ' S e e A l s o _ R e f B o x ' ) ; " > < I M G S R C = " . . / i m g / m i n u s . g i f " W I D T H = " 1 6 " H E I G H T = " 1 6 " B O R D E R = " 0 " C L A S S = " m i d m g R " I D = " S e e A l s o _ R e f B o x I m g " N A M E = " S e e A l s o _ R e f B o x I m g " > S e e A l s o : < / H 2 >
< A N A M E = " A N A M E _ S e e A l s o _ R e f B o x " > < / A > < D I V I D = " S e e A l s o _ R e f B o x " N A M E = " S e e A l s o _ R e f B o x " >
& b u l l ; < A H R E F = " S Q L R e a d e r . A b s t r a c t S Q L O b j e c t . h t m " T A R G E T = " _ s e l f " > S Q L R e a d e r . A b s t r a c t S Q L O b j e c t < / A >
< S P A N > & b u l l ; < A H R E F = " S Q L R e a d e r . D e f a u l t C o n s t r a i n t . h t m " T A R G E T = " _ s e l f " > D e f a u l t C o n s t r a i n t < / A > < / S P A N > & n b s p ; & n b s p ;
< S P A N > & b u l l ; < A H R E F = " S Q L R e a d e r . S Q L _ T y p e . h t m " T A R G E T = " _ s e l f " > S Q L _ T y p e < / A > < / S P A N > & n b s p ; & n b s p ;
< S P A N > & b u l l ; < A H R E F = " S Q L R e a d e r . I d e n t i t y C o l u m n . h t m " T A R G E T = " _ s e l f " > I d e n t i t y C o l u m n < / A > < / S P A N > & n b s p ; & n b s p ;
< S P A N > & b u l l ; < A H R E F = " S Q L R e a d e r . f o r e i g n _ k e y _ c o l u m n . h t m " T A R G E T = " _ s e l f " > f o r e i g n _ k e y _ c o l u m n < / A > < / S P A N > & n b s p ; & n b s p ;
< S P A N > & b u l l ; < A H R E F = " S Q L R e a d e r . E x t e n d e d P r o p e r t y . h t m " T A R G E T = " _ s e l f " > E x t e n d e d P r o p e r t y [ ] < / A > < / S P A N > & n b s p ; & n b s p ;
< S P A N > & b u l l ; < A H R E F = " S Q L R e a d e r . C o l u m n s . h t m " T A R G E T = " _ s e l f " > C o l u m n s < / A > < / S P A N > & n b s p ; & n b s p ;
< S P A N > & b u l l ; < A H R E F = " S Q L R e a d e r . f o r e i g n _ k e y . h t m " T A R G E T = " _ s e l f " > f o r e i g n _ k e y < / A > < / S P A N > & n b s p ; & n b s p ;
< / D I V >
< S C R I P T L A N G U A G E = " J a v a s c r i p t 1 . 2 " >
p a r e n t . M E N U . S h D i v ( ' S Q L R e a d e r ( 1 . 0 . 0 . 0 ) _ A s s e m b l y ' ) ;
p a r e n t . M E N U . S h D i v ( ' S Q L R e a d e r . S Q L R e a d e r _ N a m e s p a c e ' ) ;
p a r e n t . M E N U . S h D i v ( ' S Q L R e a d e r . S Q L R e a d e r _ C l a s s ' ) ;
p a r e n t . M E N U . l o c a t i o n = p a r e n t . M E N U . l o c a t i o n + ' # S Q L R e a d e r _ S Q L R e a d e r . C o l u m n ' ;
C o p y R i g h t ( ' C o p y r i g h t � P a w J e r s h a u g e 2 0 0 8 ' ) ;
C u r r e n t O b j e c t ( ' C o l u m n C l a s s ' ) ;
< / S C R I P T >
< / B O D Y > < / H T M L >
|
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.
Submit an article or tip