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