SQL code errors please help - 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

SQL code errors please help

Author

Topic

ahmadsa
Starting Member

7 Posts

Posted - 2007-12-12 : 07:56:06

SELECT CUSTNO Customer , ORDERNO Order , O_DATE Order Date

FROM cust_order

WHERE O_DATE = 10-20-03 AND EMPO= '%4'

ORDER BY ORDERNO;

please can anybody identify 4 errors

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-12-12 : 07:57:24

quote:
Originally posted by ahmadsa

SELECT CUSTNO Customer , ORDERNO Order , O_DATE Order Date

FROM cust_order

WHERE O_DATE = 10-20-03 AND EMPO= '%4'

ORDER BY ORDERNO;

please can anybody identify 4 errors

Run it in query analyser and follow the errors

Madhivanan

Failing to plan is Planning to fail

ahmadsa
Starting Member

7 Posts

Posted - 2007-12-12 : 08:02:37

anymore help?

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-12-12 : 08:05:39

I think I helped you

Run this

SELECT CUSTNO as Customer , ORDERNO as [Order] , O_DATE as Order_Date
FROM cust_order
WHERE O_DATE = '20031020' AND EMPO like '%4'
ORDER BY ORDERNO

Madhivanan

Failing to plan is Planning to fail

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-12 : 08:08:47

SELECT CUSTNO Customer, ORDERNO Order, O_DATE Order Date
FROM cust_order
WHERE O_DATE = 10-20-03 AND EMPO = '%4'
ORDER BY ORDERNO;

Three errors only.

SELECT CUSTNO As Customer, ORDERNO as Order, O_DATE as Order_Date
FROM cust_order
WHERE O_DATE = '10-20-03' AND EMPO LIKE '%4'
ORDER BY ORDERNO

E 12°55'05.25"
N 56°04'39.16"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-12-12 : 08:11:28

quote:
Originally posted by Peso

SELECT CUSTNO Customer, ORDERNO Order, O_DATE Order Date
FROM cust_order
WHERE O_DATE = 10-20-03 AND EMPO = '%4'
ORDER BY ORDERNO;

Three errors only.

SELECT CUSTNO As Customer, ORDERNO as Order, O_DATE as Order_Date
FROM cust_order
WHERE O_DATE = '10-20-03' AND EMPO LIKE '%4'
ORDER BY ORDERNO

E 12°55'05.25"
N 56°04'39.16"

Did coloring take lot of time?

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources