QUERIES AND SINTAX

What is the syntax for :

SELECT     *
FROM         dbo.[TableName]
WHERE     (Status = 'NULL') If I want a view to show all records that have a NULL value in a specified field.

Thanks.
gabepcsolutionsAsked:
Who is Participating?
 
indianguru2Commented:
Sorry this one ...

SELECT     *
FROM         dbo.[TableName]
WHERE     (Status is NULL)
0
 
indianguru2Commented:
SELECT     *
FROM         dbo.[TableName]
WHERE     (Status is 'NULL')
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
SELECT *
FROM TableName
WHERE Status IS NULL

btw, it's spelled Syntax.  
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
gabepcsolutionsAuthor Commented:
Thanks guys.

How do I copy one or multiple tables from one database to another ?
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>How do I copy one or multiple tables from one database to another ?
EE etiqute dictates that you ask this as a separate question, as it's completely different from your original question, and not as a follow-on.
0
 
gabepcsolutionsAuthor Commented:
You're right, sorry.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.