Script que nos puede servir para validar si existe o no una tabla temporal, funciona para las que tienen # y las ##

IF (SELECT OBJECT_ID(‘tempdb..#Datos’)) IS NOT NULL
BEGIN
select ‘Existe’
END
ELSE
BEGIN
select ‘No Existe’
END

Advertisement

Deja un comentario

Fill in your details below or click an icon to log in:

Logo de WordPress.com

You are commenting using your WordPress.com account. Log Out / Cambiar )

Twitter picture

You are commenting using your Twitter account. Log Out / Cambiar )

Facebook photo

You are commenting using your Facebook account. Log Out / Cambiar )

Connecting to %s

Seguir

Get every new post delivered to your Inbox.