Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Syntax error on one server, no problem on another in microsoft.public.sqlserver.programming
Started 1 month ago by Tom Dacon
Two SQL Server 2005 SP3 instances, and a script that pulls a syntax error on one server, but runs fine on the other: Here's about the simplest SQL that shows the problem: select * from dp_order as o where o.customer_id in (select customer_id from dbo.dummy_function(o.customer_id)) and here's the error in SQL ...
Site: Discussions in microsoft.public.sqlserver.programming  Discussions in microsoft.public.sqlserver.programming - site profile
Forum: microsoft.public.sqlserver.programming  microsoft.public.sqlserver.programming - forum profile
Total authors: 1 author
Total thread posts: 2 posts
Thread activity: no new posts during last week
Domain info for: microsoft.com

Other posts in this thread:

Tom Dacon replied 1 month ago
Answered the question myself, as is the usual way of things... The database that the script failed on was in SQL Server 2000 compatibility mode. Looks like 2000 didn't SQL allow table valued UDFs in WHERE clauses if the UDF is passed the value of a column from a table in the query. Tom Dacon...
Size: 695 bytes
Customize:  Customize "<b>Reply 1</b>: Syntax error on one server, no problem on another in microsoft.public.sqlserver.programming :: microsoft.public.sqlserver.programming :: Discussions in microsoft.public.sqlserver.programm..."

 

Top contributing authors

Name
Posts
Tom Dacon
2
user's latest post:
Syntax error on one server, no...
Published (2009-11-05 15:32:00)
&nbsp; Answered the question myself, as is the usual way of things... The database that the script failed on was in SQL Server 2000 compatibility mode. Looks like 2000 didn't SQL allow table valued UDFs in WHERE clauses if the UDF is passed the value of a column from a table in the query. Tom Dacon &nbsp;

Related threads on "Discussions in microsoft.public.sqlserver.programming":

WHILE syntax description is wrong? in...  Discussions in microsoft.public.sqlserver.programming - site profile microsoft.public.sqlserver.programming - forum profile WHILE syntax description is wrong? in microsoft.public.sqlserver.programming
WHILE syntax description is wrong? in microsoft.public.sqlserver.programming
Syntax error converting datetime from from character...  Discussions in microsoft.public.sqlserver.programming - site profile microsoft.public.sqlserver.programming - forum profile Syntax error converting datetime from from character string in microsoft.public.sqlserver.programming
Syntax error converting datetime from from character string in microsoft.public.sqlserver.programming
Error : Incorrect syntax near '('. in...  Discussions in microsoft.public.sqlserver.programming - site profile microsoft.public.sqlserver.programming - forum profile Error : Incorrect syntax near '('. in microsoft.public.sqlserver.programming
Error : Incorrect syntax near '('. in microsoft.public.sqlserver.programming
Help with stored procedure syntax please in...  Discussions in microsoft.public.sqlserver.programming - site profile microsoft.public.sqlserver.programming - forum profile Help with stored procedure syntax please in microsoft.public.sqlserver.programming
Help with stored procedure syntax please in microsoft.public.sqlserver.programming
Incorrect syntax near the keyword 'IDENTITY' -- need help...  Discussions in microsoft.public.sqlserver.programming - site profile microsoft.public.sqlserver.programming - forum profile Incorrect syntax near the keyword 'IDENTITY' -- need help in microsoft.public.sqlserver.programming
Incorrect syntax near the keyword 'IDENTITY' -- need help in microsoft.public.sqlserver.programming
Sqlcmd syntax help in microsoft.public.sqlserver.programming  Discussions in microsoft.public.sqlserver.programming - site profile microsoft.public.sqlserver.programming - forum profile Sqlcmd syntax help in microsoft.public.sqlserver.programming
Sqlcmd syntax help in microsoft.public.sqlserver.programming
Calculated field syntax error in...  Discussions in microsoft.public.sqlserver.programming - site profile microsoft.public.sqlserver.programming - forum profile Calculated field syntax error in microsoft.public.sqlserver.programming
Calculated field syntax error in microsoft.public.sqlserver.programming
FULLTEXT CONTAINSTABLE ISABOUT WEIGHT - SYNTAX RANKING...  Discussions in microsoft.public.sqlserver.programming - site profile microsoft.public.sqlserver.programming - forum profile FULLTEXT CONTAINSTABLE ISABOUT WEIGHT - SYNTAX RANKING in microsoft.public.sqlserver.programming
FULLTEXT CONTAINSTABLE ISABOUT WEIGHT - SYNTAX RANKING in microsoft.public.sqlserver.programming
Syntax For Join in microsoft.public.sqlserver.programming  Discussions in microsoft.public.sqlserver.programming - site profile microsoft.public.sqlserver.programming - forum profile Syntax For Join in microsoft.public.sqlserver.programming
Syntax For Join in microsoft.public.sqlserver.programming
Basic t-sql syntax question (select column = ....) in...  Discussions in microsoft.public.sqlserver.programming - site profile microsoft.public.sqlserver.programming - forum profile Basic t-sql syntax question (select column = ....) in microsoft.public.sqlserver.programming
Basic t-sql syntax question (select column = ....) in microsoft.public.sqlserver.programming

Related threads on other sites:

Microsoft.public.sqlserver.olap,microsoft.public.sqlserve...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.newusers - site profile microsoft.public.sqlserver.newusers - forum profile Microsoft.public.sqlserver.olap,microsoft.public.sqlserver.programming,microsoft.public.sqlserver.relationalserver.performance,microsoft.public.sqlserver.replication,microsoft.public.sqlserver.reportingsvcs in microsoft.public.sqlserver.newusers
Microsoft.public.sqlserver.olap,microsoft.public.sqlserver.programming,microsoft.public.sqlserver.relationalserver.performance,microsoft.public.sqlserver.replication,microsoft.public.sqlserver.reportingsvcs in microsoft.public.sqlserver.newusers
Microsoft.­public.­sqlserver.­programming,...  Discussions in microsoft.public.crm - site profile microsoft.public.crm - forum profile Microsoft.­public.­sqlserver.­programming, microsoft.­public.­sqlserver.­reportingsvcs, microsoft.­public.­crm.­developer in microsoft.public.crm
Microsoft.­public.­sqlserver.­programming, microsoft.­public.­sqlserver.­reportingsvcs, microsoft.­public.­crm.­developer in microsoft.public.crm
Hoping someone at Microsoft.public.sqlserver.programming...  hockeyfan - Identi.ca - site profile hockeyfan - forum profile Hoping someone at Microsoft.public.sqlserver.programming can help. Published about 10 months ago From Ping.fm
Hoping someone at Microsoft.public.sqlserver.programming can help. Published about 10 months ago From Ping.fm
AZGroups.com - Microsoft SQLServer programmer with strong...  AZGroups.com - Forums - site profile SQL Jobs/Announcements - forum profile AZGroups.com - Microsoft SQLServer programmer with strong T-SQL programming skills
AZGroups.com - Microsoft SQLServer programmer with strong T-SQL programming skills
Bcp problem (2005), previously posted to...  eggheadcafe community - site profile SQL Server tools - forum profile Bcp problem (2005), previously posted to microsoft.public.sqlserver.programming
Bcp problem (2005), previously posted to microsoft.public.sqlserver.programming
A syntax error when programming with MSComm in...  Discussions in microsoft.public.vb.controls - site profile microsoft.public.vb.controls - forum profile A syntax error when programming with MSComm in microsoft.public.vb.controls
A syntax error when programming with MSComm in microsoft.public.vb.controls
Java.sql.SQLException: [Microsoft][SQLServer 2000 Driver...  Discussions in microsoft.public.sqlserver.jdbcdriver - site profile microsoft.public.sqlserver.jdbcdriver - forum profile Java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. in microsoft.public.sqlserver.jdbcdriver
Java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. in microsoft.public.sqlserver.jdbcdriver
Method not found: 'Void...  MSDN Forums - site profile SQL Server Tools General - forum profile Method not found: 'Void Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'. (Microsoft.SqlServer.Maintenanc - MSDN Forums
Method not found: 'Void Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'. (Microsoft.SqlServer.Maintenanc - MSDN Forums
Problem with name space: Imports...  Discussions in microsoft.public.dotnet.framework - site profile microsoft.public.dotnet.framework - forum profile Problem with name space: Imports Microsoft.SqlServer.Management.Smo in microsoft.public.dotnet.framework
Problem with name space: Imports Microsoft.SqlServer.Management.Smo in microsoft.public.dotnet.framework
Failed to connect to server...  Discussions in microsoft.public.sqlserver.connect - site profile microsoft.public.sqlserver.connect - forum profile Failed to connect to server Microsoft.SqlServer.ConnectionInfo for database mirroring in microsoft.public.sqlserver.connect
Failed to connect to server Microsoft.SqlServer.ConnectionInfo for database mirroring in microsoft.public.sqlserver.connect
Thread profile page for "Syntax error on one server, no problem on another in microsoft.public.sqlserver.programming" on http://www.microsoft.com/communities/newsgroups.... This report page is a snippet summary view from a single thread "Syntax error on one server, no problem on another in microsoft.public.sqlserver.programming", located on the Message Board at http://www.microsoft.com/communities/newsgroups.... This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity