Sistemas
Páginas: 3 (732 palabras)
Publicado: 2 de junio de 2014
!
"
#
$
'(
#%
&
'(
)
)
*
*
% &
+,,, +,,-! .
!
&
%
"
/
2! .
•
4
"
)
"
!
*
0
3
'(
1
+
/
#
#
/
5
#
!
5#
!
5
#
!
1!
"
6**
!
1!
6
#
!
"
!0
!
•
7
"
.
3/
!
9
5
•
)8 0
0
2* *
19
*
!0
.
"
6
•
+
*
6*
* *9
3*
:
&
/
* *0
*
;
&
5
/
o
.
8 0
<
1
<
+
<
0
2
=
1
6<
+
2
6<
1
>#
+
?
%6<
2
o
$
/
%
1
+
2
>
!
."#$"
)
*! @
&
/
"
% ! &%! ' $
&( & )**+
&
,% % ! % -
"
%
/
"
#
$
"
%
)
A *
"
B
9
&
#
3
)
A *
#
3
!
#
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','mi direccion', '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
3
#3
A
=
"
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 % -! -! 1 0...
"
#
$
'(
#%
&
'(
)
)
*
*
% &
+,,, +,,-! .
!
&
%
"
/
2! .
•
4
"
)
"
!
*
0
3
'(
1
+
/
#
#
/
5
#
!
5#
!
5
#
!
1!
"
6**
!
1!
6
#
!
"
!0
!
•
7
"
.
3/
!
9
5
•
)8 0
0
2* *
19
*
!0
.
"
6
•
+
*
6*
* *9
3*
:
&
/
* *0
*
;
&
5
/
o
.
8 0
<
1
<
+
<
0
2
=
1
6<
+
2
6<
1
>#
+
?
%6<
2
o
$
/
%
1
+
2
>
!
."#$"
)
*! @
&
/
"
% ! &%! ' $
&( & )**+
&
,% % ! % -
"
%
/
"
#
$
"
%
)
A *
"
B
9
&
#
3
)
A *
#
3
!
#
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','mi direccion', '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
3
#3
A
=
"
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 % -! -! 1 0...
Leer documento completo
Regístrate para leer el documento completo.