July 30, 2008 at 9:27 am
Hi,
Can I create a package in SQL Server 2005? With couple of procedures and functions in it?
If so, How?
I am using SQL Server 2005 express edition (Sql Server Management Studio Express).
Thanks
July 31, 2008 at 10:14 am
Hi,
Anybody knows answer to my question?
July 31, 2008 at 10:18 am
There is nothing in SQL server called "Packages". Perhaps you could explain what they are and we could tell you if it exists by a different name.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 31, 2008 at 9:33 pm
Hi,
I was asking is there anything like oracle has..
I want to write my all procedures, functions in one file (package in oracle).. and I want to call that in my program
groupfile.sp_one
groupfile.sp_two
etc etc...
Thanks
August 7, 2008 at 8:18 am
Hi,
Anybody?
August 7, 2008 at 8:26 am
netpicker9 (7/31/2008)
Hi,I was asking is there anything like oracle has..
I want to write my all procedures, functions in one file (package in oracle).. and I want to call that in my program
groupfile.sp_one
groupfile.sp_two
etc etc...
Thanks
SQL Server is not File-based the way that Oracle is. Except through extreme gyrations, SQL Server cannot "run a file" at all in SQL Server (yes YOU can, but that is using a client tool, it's not SQL Server itself). You run stored procedures which are objects internal to SQL Server. So the Package concept ("all procedures, functions in one file") has no meaning in SQL Server because procedures and functions are not in files in the first place.
So I would have to say that No, SQL Server has no comparable concept.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 7, 2008 at 8:28 am
You can however, use Schemas to have a similar naming and organizational format. But it is still a lot different.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply