#Dev-co Snippets

View more - Cambiar o Restaurar Autonumerico SQL Server
Posted by totho44 on Tue Mar 30 22:13:17 UTC 2010. Language sql

DBCC CHECKIDENT ([tabla], RESEED, <num>)

--RESEED:Constante
--<num>: numero al cual queremos restaurar autonumerico
        

View more - Consulta Oracle SQL (para DBA) que muestra en detalle los DataFiles y los Tablespaces creados (tamaño, espacio ocupado, espacio libre, etc)
Posted by procesoft on Fri Mar 12 21:30:58 UTC 2010. Language sql

Select t.tablespace_name “Tablespace”, t.status “Estado”,
ROUND(MAX(d.bytes)/1024/1024,2) “MB Tamaño”,
ROUND((MAX(d.bytes)/1024/1024) -
(SUM(decode(f.bytes, NULL,0, f.bytes))/1024/1024),2) “MB Usados”,
ROUND(SUM(decode(f.bytes, NULL,0, f.bytes))/1024/1024,2) “MB Libres”,
t.pct_increase “% incremento”,
SUBSTR(d.file_name,1,80) “Fichero de datos”
FROM DBA_FREE_SPACE f, DBA_DATA_FILES d, DBA_TABLESPACES t
WHERE t.tablespace_name = d.tablespace_name AND
f.tablespace_name(+) = d.tablespace_name
        

View more - Consulta Oracle SQL para conocer espacio ocupado por los objetos de la Base de Datos
Posted by procesoft on Fri Mar 12 21:25:23 UTC 2010. Language sql

SELECT SEGMENT_NAME, SUM(BYTES)/1024/1024 MB
FROM DBA_EXTENTS MB
group by SEGMENT_NAME
order by 2 desc;
        

View more - Procedimiento Almacenado en PostgreSQL que retorna un resultset
Posted by layonman98 on Mon Mar 01 03:24:37 UTC 2010. Language sql

-- Ejemplo de procedimiento que recupera un registro de la tabla User
-- CREATE FUNCTION schema.func_name( params ) RETURNS type AS $$ ...

CREATE OR REPLACE FUNCTION public.user_read( IN_user_id INTEGER ) RETURNS SETOF public.user AS
$$
BEGIN
  RETURN QUERY
    SELECT user_id, name, age
    FROM   public.user
    WHERE  user_id = IN_user_id;
        

View more - User entity
Posted by layonman98 on Fri Feb 19 22:20:45 UTC 2010. Language sql

CREATE TABLE user(
  user_id   INT AUTO_INCREMENT,
  user_name VARCHAR ( 16 ) NOT NULL,
  user_age  INT,
  CONSTRAINT pk_user_id PRIMARY KEY ( user_id )
);