Question about Microsoft SQL Server Standard Edition for PC

1 Answer

Stored procedures what is stored procedures

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that gotĀ 5 achievements.


    An expert who has written 50 answers of more than 400 characters.


    An expert whose answer gotĀ voted for 20 times.

  • Expert
  • 150 Answers
Re: stored procedures

They are permanent procedures stored in the database that allow repeated execution of reusable SQL code. They are also compiled and stored in a cache repository to make their repeated execution more efficient.

The alternative to Stored Procedures is to use in-line queries "select * from table where field1 = value" hard-coded in your VB or C# application. This option though is less than ideal. Any change to the in-line query and you have to recompile the application.

The better way is to use a stored procedure, whose name doesn't change, and the parameters don't change. If the code has to change, then it's done in the stored procedure and recompiling the application isn't needed.

Posted on Nov 24, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

4 Answers

What the presager of SQL repair by any tool

Latest tool is here if you want try please use SQL repair tool to repair and recover MDF file with loss of any data. Visit here:-

Jun 04, 2014 | Microsoft SQL Server 2000 Standard Edition...

1 Answer

I want to decrypt encrypted SQL Stored Procedure 2008?

Hi walllerry,
I have read your problem and I go through it by reading some tutorials or searching some best software that quickly solves your problem. At last I found SysTools SQL Decryptor Software and read its features or information. It's really amazing software and it also having the solution for your problem that it decrypt encrypted SQL Stored procedure 2008. I am giving you the link please visit:

May 22, 2013 | Business & Productivity Software

2 Answers

Sql procedure

Dear friend you can get all your answers about stored procedure in sql server through this link:

good luck

Feb 25, 2009 | Microsoft SQL Server 2005 Enterprise...

1 Answer

Loading images into Oracle database

You need to use a blob or cblob field to store a jpg file in Oracle

see this site

Jan 14, 2009 | Oracle 10g Database Standard (ODBSEONUPP0)

1 Answer

Lost product key

Every manufacturer has procedures for these situations. They'll ask for your proof of purchase. If you no longer have the receipt, you may be able to download a copy of the invoice from a mail-order store you bought from.

Oct 19, 2008 | Corel Paint Shop Pro Photo X2 Full Version...

1 Answer

SQL Server 2000

An easy way to transfer objects (tables, user defined functions, stored procedures, etc.) is to use Enterprise Manager's "Generate SQL" feature. Use this process at your own risk. Doing it wrong could mess up your existing database.

1. In Enterprise Manager, right-click on the old database and choose "All Tasks" then "Generate SQL Script".
2. In the dialog that comes up, click "Show All" then select the checkboxes for "all stored procedures" and "all user defined functions". (You might also want to check some other boxes, depending on your exact situation.)
3. Click the "generate" button and save the script that it creates.
4. Run the script in the NEW database.

If you run the script in your OLD database, it may destroy your objects, and that would be very bad. Make sure you run the script in your NEW database. (While we're on this subject, it's a good time to mention that you should back up your database before you start this process, and you should make changes to a test system before migrating it to production.)

That should move your stored procedures and user defined functions over.

You can use a similar process to move tables, views, users, and other objects over as well.

Jan 17, 2008 | Business & Productivity Software

1 Answer

How to stop sql sp_procedure_params_rowset

sp_procedure_params_rowset is called internally by client APIs to get stored
procedure meta data. For example, I believe the .Net SqlCommandBuilder uses
it. If you don't want to call it, you can change the application code to
avoid using the functionality provided by the proc.

Dec 17, 2007 | Microsoft SQL Server 2000 Standard Edition...

1 Answer

Ms access

Stored Procedures don't exist in MS Access. You do have the following options though. Queries, which are just select or action queries. VB Code, which you can write using Query Objects as if you were writing a Visual Basic application. These can be Functions or Subroutines. In these, you would use the standard programming techniques with while and for loops, etc.

You can create complex situations combining the two of these. A function in the VB code area can accept through parameters, the single values (line by line, record by record) in a query and act on them and manipulate the values.

For example: create a query that does a select phone from address. Create a function in vb called public function StripDashesInPhone(Phone as string) which then uses VB coding to strip dashes from each phone value passed in. To make it all work, in the query on one of the field columns put "NewPhone: StripDashesInPhone([Phone])" and for every record processed in the query, the function is called with the [Phone] field value passed in to the function and the action is processed and returned.

Other than writing a function that is activated by a form button click, which opens the current db and opens a table and process it, just like in VB, this is about as close to cursors and oracle procedures as you get.

I wish it was more, but ...

Oct 09, 2007 | Microsoft Office Standard for PC

1 Answer

How to write stored procedures

SQL: A Beginner's Guide (Paperback) by Forrest Houlette, a pretty easy to follow book! ZT3000 "Beta tester of "0"s and "1's"

Aug 23, 2007 | Microsoft SQL Server Standard Edition for...

Not finding what you are looking for?
Microsoft SQL Server Standard Edition for PC Logo

Related Topics:

95 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides