开发者

What's the name of MS's (ongoing?) embedded (serverless) SQL Server version with stored procedures support?

开发者 https://www.devze.com 2023-03-08 14:08 出处:网络
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 ver

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消