• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 255
  • 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
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

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