I am trying to run Queries in MS SQL Server and it comes up with errors if I specify table names or column names in a different case. The query is case-sensitive….!!!!
If you are using the SQLCMD utility and want to avoid or suppress the column header in the output of SQL Script. You can do it just by setting the Variable SQLCMDHEADERS to -1 by default its 0
How to retrieve records from table which has null values.
Here is the Script which will list records which has null values for CountryID column.
select * from yourTable where CountryID is null