Reply to Re: Stored procedure to create a new database with tables

Your name:

Reply:


Posted by Shiller on 02/28/07 16:07

On Feb 28, 10:44 am, "Massimo-Mastino" <mast...@hotmail.it> wrote:
> Before the CREATE TABLE statements you should put this:
>
> USE Budget
> go
>
> "Shiller" <shill...@gmail.com> ha scritto nel messaggionews:1172675843.097303.293060@8g2000cwh.googlegroups.com...
>
>
>
> > I want my application to create a new database/tables when run for the
> > first time. I have created a stored procedure to create the new
> > database named "budget". When I run the stored procedure, it creates
> > the budget database but the tables are created in the "master"
> > database. Please help.- Hide quoted text -
>
> - Show quoted text -

I tried using the USE statement, but it's not allowed in stored
procedure: "a USE database statement is not allowed in a procedure,
function or trigger."

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация