I'm using VWD 2008 (SP1) and SQLExpress 2008. I'm creating a database first and then looking at using DynamicDataControls (seem useful and staright foward for a beginner like me).
我正在使用VWD 2008(SP1)和SQLExpress 2008.我首先创建一个数据库,然后使用DynamicDataControls(对于像我这样的初学者来说看起来很有用而且很明星)。
Within VWD I created a new Dynamic Data Web Application. Then I added a new SQL database item. I noticed that this doesn't include stored procedures or...anything. Is this normal?
在VWD中,我创建了一个新的动态数据Web应用程序。然后我添加了一个新的SQL数据库项。我注意到这不包括存储过程或......任何东西。这是正常的吗?
I imagine that stored procedures may not be used with the DataControls, but just in case I need ot know, should I be alarmed that stored procedures are not included? How to I include them?
我想存储过程可能不会与DataControls一起使用,但为了防止我需要知道,我是否应该警惕不包含存储过程?我如何包括它们?
Thanks again for any advice you send my way.
再次感谢您发送我的任何建议。
Mike.
1 个解决方案
#1
When you create a new database only system objects are included, tables, views, UDFs, triggers, indexes etc etc have to be created by the user
创建新数据库时,只包含系统对象,用户必须创建表,视图,UDF,触发器,索引等
whatever is in the model database will be in any new user generated database. If you want objects to be created every time you create a new database, create them in the model DB first
模型数据库中的任何内容都将出现在任何新的用户生成的数据库中。如果希望每次创建新数据库时都创建对象,请首先在模型数据库中创建它们
Take a look at Automatically create a SQL Server table in a new database.
查看在新数据库中自动创建SQL Server表。
#1
When you create a new database only system objects are included, tables, views, UDFs, triggers, indexes etc etc have to be created by the user
创建新数据库时,只包含系统对象,用户必须创建表,视图,UDF,触发器,索引等
whatever is in the model database will be in any new user generated database. If you want objects to be created every time you create a new database, create them in the model DB first
模型数据库中的任何内容都将出现在任何新的用户生成的数据库中。如果希望每次创建新数据库时都创建对象,请首先在模型数据库中创建它们
Take a look at Automatically create a SQL Server table in a new database.
查看在新数据库中自动创建SQL Server表。