[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