Skip to Content.
Sympa Menu

freetds - Re: [freetds] MSSQL syntax flavors

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Arnar Birgisson" <ArnarB AT oddi.is>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] MSSQL syntax flavors
  • Date: Thu, 03 Jul 2003 08:27:02 +0000

>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




Archive powered by MHonArc 2.6.24.

Top of Page