What's the name of MS's (ongoing?) embedded (serverless) SQL Server version with stored procedures support?
Some months ago I've read an announce of Microsoft to be going to release an embedded (serverless, linked to an application as a library/assembly and using a simple file to store data) SQL Server version to replace (for those needing this, not to replace at all) SQL Server Express (full-functional but needing a separate server software to be installed) and SQL Server Compact (embedded but low-functional - without stored procedures, triggers etc.) and support all the candies like stored procedures and triggers.
But I've forgotten how was it meant to be named and ca开发者_Go百科n't find it now.
Do you know of this?
It's called LocalDB:
Introducing LocalDB, an improved SQL Express
SQL Server Compact
Note that SQL CE does not support "Procedural T-SQL" (Select Case, If, etc) or Stored procedures, views, and triggers. In other words it is "light and tight" but that comes at a price.
MS has not released an embedded SQL database that supports stored procedures.
You might have a look at VistaDB if those are your requirements.
精彩评论