[freetds] MSSQL syntax flavors
Arnar Birgisson
ArnarB at oddi.is
Thu Jul 3 09:27:02 EDT 2003
>Interesting - maybe the MSSQL query tool silently removes the
>semi-colon.
No.. executing this batch in Query Analyzer:
declare @rr int;
set @rr = 1
select @rr
works and looking at it in th SQL Profiler shows that the server
recieves the text as-is, with ; in place.
These are the options Query Analyzer sets at startup, I looked up those
I thought might have some relevance, but no one mentions terminating
statements with ;
-- network protocol: TCP/IP
set quoted_identifier off
set implicit_transactions off
set cursor_close_on_commit off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set language us_english
set dateformat mdy
set datefirst 7
Arnar
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
More information about the FreeTDS
mailing list