What does '|' do? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

What does '|' do?

Author

Topic

theboyholty
Posting Yak Master

226 Posts

Posted - 2011-12-20 : 08:50:17

I'm just working through a piece of code and I found a thing that I don't understand. It looks random to me, I can't see any consistency.

if you run this code and build a temp table then run the SELECT statement below,

SELECT 1 AS Number INTO #Test UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9UNION ALL SELECT 10 UNION ALL SELECT NULL
SELECT Number FROM #Test

select Number,Number|0 as P_0, Number|1 as P_1, Number|10 as P_10 from #test order by 1

I'd love to know what this | function is doing . . .

---------------------------------------------------------------------------------
http://www.mannyroadend.co.uk A Bury FC supporters website and forum

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-20 : 08:54:25

| represents bitwise OR operator

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

X002548
Not Just a Number

15586 Posts

Posted - 2011-12-20 : 10:00:09

this is an Oracle concat symbol (or DB2)

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-12-20 : 11:02:12

quote:
Originally posted by X002548

this is an Oracle concat symbol (or DB2)

Concat uses || (two pipes) in Oracle and DB2.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-20 : 11:14:06

quote:
Originally posted by X002548

this is an Oracle concat symbol (or DB2)

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

here it cant be concat as operands involved are numeric values without any casting involved

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-12-21 : 02:38:32

quote:
Originally posted by X002548

this is an Oracle concat symbol (or DB2)

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

Look at the full code that OP posted. It is for SQL Server and as Rob already pointed ORACLE uses || for concatination

Madhivanan

Failing to plan is Planning to fail

X002548
Not Just a Number

15586 Posts

Posted - 2011-12-21 : 13:07:22

rough morning

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources