jueves, 17 de mayo de 2012

Validar Base de Datos usando Variables SQL


CREATE PROCEDURE tabla_valida (@name_bd varchar(100))
AS
BEGIN
    set quoted_identifier off
    execute ('IF NOT EXISTS (SELECT 1 FROM '+@name_bd+'..sysobjects o, '+@name_bd+'..sysusers
              u where o.uid=u.uid and o.name="conteo_sql" and u.name="dbo" and o.type="U"')
   
    BEGIN --001
        create table conteo_sql
           (
        bd  varchar(200),
        tabla varchar(200) null,
        row_count integer null )
        print 'conteo_sql creada'
    END --001/
END --000/

No hay comentarios:

Publicar un comentario