• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 253
  • Last Modified:

insert null to a column

Hi,

Kindly assist how can we insert a record with nothing in it?

Select delivery as [Average Total]
From #tempscorecard
UNION ALL
Select [.]
UNION ALL
Select [Listening Skills]
From #tempscorecard
UNION ALL
Select [Communication Skills]
From #tempscorecard


Output:
Average Total
NULL              <-----------placing null
Listening Skills
Communication Skills

Thanks.
0
EdwardPeter
Asked:
EdwardPeter
  • 2
1 Solution
 
Anthony PerkinsCommented:
Select delivery as [Average Total]
From #tempscorecard
UNION ALL
Select Null
UNION ALL
Select [Listening Skills]
From #tempscorecard
UNION ALL
Select [Communication Skills]
From #tempscorecard
0
 
Anthony PerkinsCommented:
Or depending on your definition of "nothing":

Select delivery as [Average Total]
From #tempscorecard
UNION ALL
Select ''
UNION ALL
Select [Listening Skills]
From #tempscorecard
UNION ALL
Select [Communication Skills]
From #tempscorecard
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now