Help on a join - 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

General SQL Server Forums

New to SQL Server Programming

Help on a join

Author

Topic

gadjo72
Starting Member

3 Posts

Posted - 2011-06-10 : 08:05:22

Hi every one

I've got this Sybase SQL Where clause:

WHERE cb_depots.depotKey = :depotKey
can you guys tell me what "=:" means ?

I think a right join is like "=*" so i really don't know about this one

Cheers

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2011-06-10 : 08:07:21

Try Sybase forum at dbforums.com

SqlTeam is a MS SQL Server site...

Corey

I Has Returned!!

jcelko
Esteemed SQL Purist

547 Posts

Posted - 2011-06-10 : 22:40:03

The colon prefix is ANSI/ISO SQL and it marks parameters. Use @ for T-SQL dialect.

--CELKO--
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources