Blog de Francisco Velázquez

otro blog personal

Consultas en SQL Server con IN

leave a comment »

Al hacer una consulta de este estilo:

SELECT …. WHERE campo NOT IN (…)

No va a incluir las tuplas cuyo campo sea NULL. Por tanto si queremos incluirlos, habrá que indicarlo explícitamente:

SELECT …. WHERE campo NOT IN (…) OR campo IS NULL

Written by fravelgue

August 2, 2011 at 5:56 pm

Posted in development

Tagged with , ,

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: