|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
saving ad-hoc sqlserver scripts via Visual StudioI come from an Oracle background, where one can, in addition to having
stored procedures in the db, load and run text files containing sql DDL or DML commands. But I can't seem to find an equivalent in VS2005. I can create and run an ad-hoc query in the SQL Pane, provided I have already opened a particular table, but then I don't see how to save that ad-hoc query as an external script for later use. Is there a way to do this, rather than making a formal stored procedure? thanks Yes, by creating a database project. It has the ability to help you create
and store SQL scripts. -- Show quote____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP INETA Speaker www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ Visit www.hitchhikerguides.net to get more information on my latest book: Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ----------------------------------------------------------------------------------------------------------------------- "Fred Exley" <j**@dslextreme.com> wrote in message news:12pqqgta97n7798@corp.supernews.com... >I come from an Oracle background, where one can, in addition to having >stored procedures in the db, load and run text files containing sql DDL or >DML commands. But I can't seem to find an equivalent in VS2005. I can >create and run an ad-hoc query in the SQL Pane, provided I have already >opened a particular table, but then I don't see how to save that ad-hoc >query as an external script for later use. Is there a way to do this, >rather than making a formal stored procedure? thanks > Bill,
I have not used it (I know it but only have looked slightly to it, it really seems nice to me for documentation but than I have to start a new (hug) project), but the question was Run as well. Is that possible from that database project? serious question. Cor Yes, it is. At least, it's possible to run the script to update the
stored procedure. I think you can test the stored procedure using the Server Explorer in VS2005. Robin S. ---------------------------- Show quote "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message news:eFVLHnIMHHA.780@TK2MSFTNGP03.phx.gbl... > Bill, > > I have not used it (I know it but only have looked slightly to it, it > really seems nice to me for documentation but than I have to start a > new (hug) project), but the question was Run as well. Is that possible > from that database project? > > serious question. > > Cor > Robin,
> stored procedure. I think you can test the stored procedure using You had the idea that I did not know that?> the Server Explorer in VS2005. > :-) Cor"Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message Sorry, I thought you were asking about the Database Project stuff,news:%230KiaAJMHHA.4848@TK2MSFTNGP04.phx.gbl... > Robin, > >> stored procedure. I think you can test the stored procedure using >> the Server Explorer in VS2005. >> > You had the idea that I did not know that? > > :-) > > Cor but wasn't completely sure, so I threw in a little extra. Frankly, I think you know everything, and just post questions like this to test the rest of us. ;-) Robin S. Don't encourage him!!!!!!
Show quote "RobinS" <RobinS@NoSpam.yah.none> wrote in message news:rcydnbez1u_kbgDYnZ2dnUVZ_sapnZ2d@comcast.com... > > "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message > news:%230KiaAJMHHA.4848@TK2MSFTNGP04.phx.gbl... >> Robin, >> >>> stored procedure. I think you can test the stored procedure using >>> the Server Explorer in VS2005. >>> >> You had the idea that I did not know that? >> >> :-) >> >> Cor > > Sorry, I thought you were asking about the Database Project stuff, > but wasn't completely sure, so I threw in a little extra. Frankly, > I think you know everything, and just post questions like this > to test the rest of us. ;-) > > Robin S. > I can't help but respect people with more knowledge than I,
and the willingness to share it. Like you, bucko. Robin S. ------------------------------ Show quote "Stephany Young" <noone@localhost> wrote in message news:er8EaWJMHHA.3312@TK2MSFTNGP03.phx.gbl... > Don't encourage him!!!!!! > > > "RobinS" <RobinS@NoSpam.yah.none> wrote in message > news:rcydnbez1u_kbgDYnZ2dnUVZ_sapnZ2d@comcast.com... >> >> "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message >> news:%230KiaAJMHHA.4848@TK2MSFTNGP04.phx.gbl... >>> Robin, >>> >>>> stored procedure. I think you can test the stored procedure using >>>> the Server Explorer in VS2005. >>>> >>> You had the idea that I did not know that? >>> >>> :-) >>> >>> Cor >> >> Sorry, I thought you were asking about the Database Project stuff, >> but wasn't completely sure, so I threw in a little extra. Frankly, >> I think you know everything, and just post questions like this >> to test the rest of us. ;-) >> >> Robin S. >> > > "William (Bill) Vaughn" <billvaRemoveT***@nwlink.com> wrote in message OK thanks, I'll look into it.news:OsZ91qGMHHA.420@TK2MSFTNGP06.phx.gbl... > Yes, by creating a database project. It has the ability to help you create > and store SQL scripts.  |
|||||||||||||||||||||||
Other interesting topics