Not Null in Azure Sql DB

Rohit Kulkarni 731

Hello Team,

I have created a table in Azure SQL DB and mentioned as Null to all the values :

Once I run the query The Null Value is displaying in Previous_RM_ID and Previous_TM_ID field.
It must display as a Blank .

Please advise .

Thanks in adavcne

Regards
RK

Ronen Ariely 15,206 Reputation points

2021-06-23T11:19:07.42+00:00

Good day,

I have created a table in Azure SQL DB and mentioned as Null to all the values :

What can we do with this image?!?

Instead of image of the query please provide the query that you used to create the table so we could copy it and use it to reproduce the scenario

Once I run the query The Null Value is displaying in Previous_RM_ID and Previous_TM_ID field.

Which query?!?
You did not provided the query which you speak about running

Please provide the missing information
Rohit Kulkarni 731 Reputation points

2021-06-23T16:10:12.98+00:00

If you refer to the 1st screenshot you can able to see the create table statement and you can write the create statement according to your convince.

and 2nd screenshot :

After creating the table.Will run the select statement.

Once you run the select statement you will get Null Values in the select statement.

Now is it clear

1 answer

Olaf Helper 47,436 Reputation points

2021-06-23T11:22:11.893+00:00
You defined the column as nullable and when you don't insert data for the column then query returns NULL as value; that's how nullable columns work.

If you want NULL as blank in a query, then you can use the ISNULL function to retunr blank instead, like

SELECT ISNULL(Previous_RM_ID, '') AS Previous_RM_ID, ...

or you define the column as not-nullable with blank as default value, like

...,Previous_RM_ID nvarchar(255) NOT NULL DEFAULT(''), ...
Please sign in to rate this answer.
Rohit Kulkarni 731 Reputation points

2021-06-23T16:15:14.013+00:00

For this table, we are uploading the data from a flat-file (CSV). And presenting these fields in the tableau report.

I have changed the column to Previous_RM_ID varchar(255) NOT NULL. And not able to upload the data from the flat file to the table. due to the conversion of the fields.

Please advise.

Regards
RK

Samara Soucy - MSFT 5,141 Reputation points

2021-06-24T14:44:31.177+00:00

Hi Rohit,

Just wanted to check, when you set the column to NOT NULL did you also include the default value? Alternatively, have you tested whether the ISNULL() function would serve your needs?

Samara Soucy - MSFT 5,141 Reputation points

2021-06-30T03:42:35.7+00:00

Hello,

Reaching out one last time to see if you were able to resolve your issue or if you are still having trouble with your data load.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer