Visual Fox Pro
Páginas: 3 (742 palabras)
Publicado: 9 de agosto de 2012
! " $ '( ) #% * & ) & % " / 2! . " 3 / ) * # '( % & +,,, +,,-! . ! " * 0 1 + '( !
•
4
# # 5 5 5 # # # ! ! ! " 1! 1! ! 6 # ! " !0 6** /
!
•
7 " . 9 5 !0 ! 2* * 6* )8 0 * * 0 * *9 3/19 +
•
. " 6 * : & 3 * *0 / *
•
; & o . < < < = 1 6< o $ % / 1 + 2 > 1 + 2 6< ># + ? %6< 1 + 2 8 0 0 5 /
2
!
"#$"
.
)
*! @
&
/
"
% ! &%! ' $
&( & )**+& ,% % ! % %
" "
/
#
$ #
"
% B 3 )
)
A * 9 & 3 #
"
A *
!
# 1 1 % 1
! #
&
& " !
#
=
"
/
DBCC CHECKIDENT ( 'table_name' [ , { NORESEED | {RESEED [ , new_reseed_value ] } } ] ) [ WITH NO_INFOMSGS ] Ejemplo: DBCC CHECKIDENT ('cliente', RESEED, 0).
Reseteará el campo identidad a 0. INSERT INTO clientes values ('Juan Perez','midireccion', '88377666') SELECT @@IDENTITY
;
)
*
&
!
,% % ! . %
#/ ' 0
"
3 3 % = 3 " 3 / # 3
# ! & !
# "
CREATE NONCLUSTERED INDEX [IX_cliente] ON [dbo].[cliente] ([nomcli]ASC) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON
$ [PRIMARY]
DEFINIENDO INDICES UNICOS
$ 7 A = 3 "
3 # # 3 / ) *! 3 C
" 3
&
CREATE UNIQUE NONCLUSTERED INDEX [IX_cabe_factura] ON [dbo].[cabe_factura] ([nro_fact] ASC) WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON , ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
%
, % % ! % - 0 % -! -! 10
!
=3 # @ 3 "
#
3 " 3 ! # !
CREATE UNIQUE NONCLUSTERED INDEX [IX_deta_factura] ON [dbo].[deta_factura] ([id_fact] ASC,[procod] ASC) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
-"1 ! -"$-0 $" !
&
D " ). E * # & & ) *! # ) * &...
•
4
# # 5 5 5 # # # ! ! ! " 1! 1! ! 6 # ! " !0 6** /
!
•
7 " . 9 5 !0 ! 2* * 6* )8 0 * * 0 * *9 3/19 +
•
. " 6 * : & 3 * *0 / *
•
; & o . < < < = 1 6< o $ % / 1 + 2 > 1 + 2 6< ># + ? %6< 1 + 2 8 0 0 5 /
2
!
"#$"
.
)
*! @
&
/
"
% ! &%! ' $
&( & )**+& ,% % ! % %
" "
/
#
$ #
"
% B 3 )
)
A * 9 & 3 #
"
A *
!
# 1 1 % 1
! #
&
& " !
#
=
"
/
DBCC CHECKIDENT ( 'table_name' [ , { NORESEED | {RESEED [ , new_reseed_value ] } } ] ) [ WITH NO_INFOMSGS ] Ejemplo: DBCC CHECKIDENT ('cliente', RESEED, 0).
Reseteará el campo identidad a 0. INSERT INTO clientes values ('Juan Perez','midireccion', '88377666') SELECT @@IDENTITY
;
)
*
&
!
,% % ! . %
#/ ' 0
"
3 3 % = 3 " 3 / # 3
# ! & !
# "
CREATE NONCLUSTERED INDEX [IX_cliente] ON [dbo].[cliente] ([nomcli]ASC) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON
$ [PRIMARY]
DEFINIENDO INDICES UNICOS
$ 7 A = 3 "
3 # # 3 / ) *! 3 C
" 3
&
CREATE UNIQUE NONCLUSTERED INDEX [IX_cabe_factura] ON [dbo].[cabe_factura] ([nro_fact] ASC) WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON , ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
%
, % % ! % - 0 % -! -! 10
!
=3 # @ 3 "
#
3 " 3 ! # !
CREATE UNIQUE NONCLUSTERED INDEX [IX_deta_factura] ON [dbo].[deta_factura] ([id_fact] ASC,[procod] ASC) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
-"1 ! -"$-0 $" !
&
D " ). E * # & & ) *! # ) * &...
Leer documento completo
Regístrate para leer el documento completo.