|
|
��U S E [ T e s t D a t a b a s e ]
G O
/ * * * * * * O b j e c t : T a b l e [ d b o ] . [ C o n t a c t ] S c r i p t D a t e : 1 1 / 2 6 / 2 0 1 2 1 0 : 1 8 : 3 8 * * * * * * /
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 o n t a c t ] (
[ I d ] [ i n t ] I D E N T I T Y ( 1 , 1 ) N O T N U L L ,
[ N a m e ] [ v a r c h a r ] ( 1 0 0 ) N U L L ,
[ S e x ] [ v a r c h a r ] ( 5 0 ) N U L L ,
[ T y p e ] [ v a r c h a r ] ( 5 0 ) N U L L ,
[ I s A c t i v e ] [ b i t ] N U L L ,
C O N S T R A I N T [ P K _ C o n t a c t _ 1 ] 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
G O
I N S E R T I N T O C o n t a c t v a l u e s ( ' A s h r a f u r R a h a m a n ' , ' M a l e ' , ' 3 ' , 1 ) ;
G O
/ * * * * * * O b j e c t : T a b l e [ d b o ] . [ C o n t a c t T y p e ] S c r i p t D a t e : 1 1 / 2 6 / 2 0 1 2 1 0 : 1 8 : 5 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 ] . [ C o n t a c t T y p e ] (
[ I d ] [ i n t ] I D E N T I T Y ( 1 , 1 ) N O T N U L L ,
[ T y p e N a m e ] [ v a r c h a r ] ( 5 0 ) N U L L ,
C O N S T R A I N T [ P K _ C o n t a c t T y p e ] 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
G O
I N S E R T I N T O C o n t a c t T y p e v a l u e s ( ' F r i e n d s ' ) ;
I N S E R T I N T O C o n t a c t T y p e v a l u e s ( ' F a m i l y ' ) ;
I N S E R T I N T O C o n t a c t T y p e v a l u e s ( ' B u s i n e s s ' ) ;
I N S E R T I N T O C o n t a c t T y p e v a l u e s ( ' P e r s o n a 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.
Software engineer with broad experience in enterprise application development, product deployment automation, software test & test automation, application & system management, and manage big projects and team using proven agile technologies.
Passionate on Microsoft technologies, developed solutions using C#, .net (1.1/2.0/3.5/4), SQL Server (2005/2008). Work on Powershell, SSRS, SSIS, WPF, Ajax, WCF, JQuery.
Develop innovative application with cutting edge technologies always boosting inside.
Submit an article or tip