The Tech Pursuit
The Dev Shelf
Pages
Home
Interview Questions
About Me
April 8, 2015
Effective use of COALESCE in SQL Server
DECLARE
@Table
TABLE
(
Phone1
VARCHAR
(
10
),
Phone2
VARCHAR
(
10
),
Phone3
VARCHAR
(
10
)
)
INSERT
INTO
@Table
SELECT
'998888'
,
'385832'
,
'83853385'
UNION
ALL
SELECT
Null,Null,
'83853385'
UNION
ALL
SELECT
Null,
'84282484'
,
'83853385'
SELECT
COALESCE
(
Phone1
,
Phone2
,
Phone3
)
FROM
@Table
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment