September 5, 2003 at 8:37 am
This statement is from the SQL Server 2000 online book:
UPDATE titles
SET t.ytd_sales = t.ytd_sales + s.qty
FROM titles t, sales s
WHERE t.title_id = s.title_id
AND s.ord_date = (SELECT MAX(sales.ord_date) FROM sales)
I was wondering if the same sort of FROM clause is available in SQL Server CE ?
jean-luc
Jean-Luc
Jean-Luc
www.corobori.com
September 5, 2003 at 8:50 am
From my understanding it should be. The parser is pretty much the same.
September 5, 2003 at 8:59 am
quote:
From my understanding it should be. The parser is pretty much the same.
Actually the reason I am asking for this is because the parser doesn't seem to like my syntax ! I wrote the whole thing in SQL Query Analyzer and try to run the same statement and I had a message from the parser.
Jean-Luc
Jean-Luc
www.corobori.com
September 5, 2003 at 9:15 am
I have a test copy of CE but not installed on my Pocket. I will try to find and install but you might try the msdn website and search for CE edition information.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply