T-SQL differences between SQL Server Compact Edition and real SQL Server?

views:

answers:

+3 Q:

T-SQL differences between SQL Server Compact Edition and real SQL Server?

Coming from an extensive SQL Server T-SQL background, I'm having trouble finding any specific documentation describing the differences in T-SQL support between SQL CE and full blown SQL Server. What are some of the differences you've run into? Is there a side-by-side T-SQL comparison somewhere? I've seen the MSDN documentation here, but I cannot seem to find any details about what T-SQL statements aren't portable between the two. One difference I found right away is the lack of an ISNUMERIC() function. Any others?

NOTE: I'm specifically more interested in differences in DML functionality than DDL and administrative functions which I'm sure are numerous and completely uninteresting.

+4 A:

Here you go, some of the stuff is here http://msdn.microsoft.com/en-us/library/bb896140(SQL.100).aspx

SQLMenace 2010-08-30 20:16:29

Thank you so much. Google just wasn't getting me there. Interestingly, the first problems I ran into (lack of `IsNumeric()` / `IsDate()`, etc) aren't listed at that URL. Anyone else have any other resources that provide a more complete list of differences?

mattmc3 2010-08-30 20:19:47

There is this, but it list only what is supported in terms of functions http://msdn.microsoft.com/en-us/library/ms174077(v=SQL.100).aspx not sure if what you want exactly exists

SQLMenace 2010-08-30 20:22:16

I think that's close enough, thank you. Though I'm surprised at how many serious gotchas there are that just don't appear to be documented anywhere. For example, `IsNull()` behaves like a boolean expression in SQLCE instead of the mini-coalesce() behavior from SQL Server. Not that I expected them to be *completely* the same, but changing the expected behavior on a product sharing the same name and providing incomplete supporting documentation seems pretty crappy.

mattmc3 2010-08-30 20:34:56

ansaurus

tags:

views:

answers:

T-SQL differences between SQL Server Compact Edition and real SQL Server?

related questions