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