Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ratheeshsql
Starting Member
17 Posts |
 Posted - 2006-11-14 : 04:15:22
|
| Hi,I am using Sql server with my web application written in asp.net and c#.I want to deploy the web application so that when i install the application the database and all other objects like tables, views,functions and stored procedures shuold be created automatically. I have created the database,tables etc.I have created a sql file (eg: queriies.sql)including all the queries to generate the views. But there occurs some error when i am trying to create multiple views from a single sql file.Is it possible that i can create multiple views by executing the different queries containing in one sql file?please reply me..thanx |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-14 : 04:19:11
|
| Try to include a "GO" between CREATE statements.Peter LarssonHelsingborg, Sweden |
 |
|
|
ratheeshsql
Starting Member
17 Posts |
Posted - 2006-11-14 : 04:34:03
|
| hi,When the 'GO' is included in the file, it produces some errors while executing. It w'l work in the query window if i give the 'GO' in between each query. But while executing from ASP.net its not possible. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-14 : 04:37:00
|
| Try a ; Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
Dynammically creating databases