- smc_source_1.zip
- SMC_Source
- Smc.jar
- SMC_Demo
- DataAccess
- DataAccess
- Domain
- Domain
- ServicesProvider
- ServicesProvider
- SMC_Demo
- SMCWebsite
- SQL Database Script
- SMC_Source.zip
|
��U S E [ C a r A u t o m a t i o n ]
G O
/ * * * * * * O b j e c t : S t o r e d P r o c e d u r e [ d b o ] . [ i s p _ S t a t e A u d i t L o g ] S c r i p t D a t e : 1 0 / 2 0 / 2 0 0 8 1 8 : 5 5 : 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
C R E A T E P R O C E D U R E [ d b o ] . [ i s p _ S t a t e A u d i t L o g ]
- - A d d t h e p a r a m e t e r s f o r t h e s t o r e d p r o c e d u r e h e r e
@ C a r _ I D N V A R C H A R ( 2 0 ) ,
@ U p d a t e d _ B y I N T ,
@ C u r r e n t _ S t a t e _ I D I N T ,
@ R e m a r k s V A R C H A R ( m a x )
A S
I N S E R T I N T O [ C a r A u t o m a t i o n ] . [ d b o ] . [ S t a t e A u d i t L o g ]
( [ C a r _ I D ]
, [ S t a t e _ I D ]
, [ R e m a r k s ]
, [ C r e a t e d _ B y ]
, [ C r e a t e d _ D a t e ]
, [ L a s t _ U p d a t e d _ B y ]
, [ L a s t _ U p d a t e d _ D a t e ] )
V A L U E S
( @ C a r _ I D
, @ C u r r e n t _ S t a t e _ I D
, @ R e m a r k s
, @ U p d a t e d _ B y
, G e t D a t e ( )
, @ U p d a t e d _ B y
, G e t D a t e ( ) )
|
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.