When to use stored procedure and when function in SQL Server 2008?

When to use stored procedure and when function in SQL Server 2008?
by

1 Answer

Answer :

There’s no technically right answer here – I think I’d do the SP calling SP.
by

Related questions

Where can I learn quickly the differences between using SQL Server 2008 and Toad for Oracle?

Description : Where can I learn quickly the differences between using SQL Server 2008 and Toad for Oracle?

Last Answer : answer:The SQL code IS different. Oracle and SQL Server syntax can differ from the ANSI version of SQL. For example, when you write a JOIN in SQL, you MUST use the OUTER JOIN ON syntax, where ... can also use the Query Builder to write queries for you by dragging and dropping - just like Access.

How to solve this problem I have with a restore (backup) file I made in SQL Server 2008?

Description : How to solve this problem I have with a restore (backup) file I made in SQL Server 2008?

Last Answer : try to see if you have volume optimization enabled, it prevents certain changes from happening and really gives the user a hell of alot more trouble than it is worth.

Why can I not install MS SQL Server Express 2008 R2?

Description : Why can I not install MS SQL Server Express 2008 R2?

Last Answer : Please provide details on what and how it fails the precheck.

Where is a procedure return in an external pl/sql library executed at the client or at the server?

Description : Where is a procedure return in an external pl/sql library executed at the client or at the server?

Last Answer : At the client.

I understand what the PL/SQL code below is supposed to do, but when I run the code, it won't compile. Can anybody help with why this is so?

Description : I understand what the PL/SQL code below is supposed to do, but when I run the code, it won't compile. Can anybody help with why this is so?

Last Answer : answer:PL\SQL really isn’t my thing, but I believe you need something between the first IF statement and the ELSIF. What do you want it to do with the number if it is 50 or 90?

Does anyone here have experience working with PL/SQL? I need some help getting started...

Description : Does anyone here have experience working with PL/SQL? I need some help getting started...

Last Answer : answer:PL/SQL is Oracle's take on SQL. It's mostly vanilla SQL, but with some Oracle-specific twists. You need Oracle SQL Developer or something similar. I doubt other relational ... more closely resembling a true object-oriented language, so make sure you get something Oracle-specific!.

What is better: One big SQL query or several?

Description : What is better: One big SQL query or several?

Last Answer : It’s difficult without examples. But what you describe seems like a simple join.

Where is the best, most reliable place to purchase Visual Studio 2008?

Description : Where is the best, most reliable place to purchase Visual Studio 2008?

Last Answer : http://www.amazon.com/Microsoft-Visual-Studio-2008-Standard/dp/B000WM1Z46/ref=sr_1_2?ie=UTF8&s=software&qid=1248965173&sr=1-2

Will using .NET 3.5 server side for a web site place any notable restrictions on what web browers can use the site?

Description : Will using .NET 3.5 server side for a web site place any notable restrictions on what web browers can use the site?

Last Answer : .NET 3.5 VSTS feature won’t restrict you on any navigation features.VSTS is solely browser independent.You could publish your site on any browser, but you need to do some customization while using firefox.Some addin features are needed to make your Server side setup function properly.

Is there an advantage to putting the database on a separate database server?

Description : Is there an advantage to putting the database on a separate database server?

Last Answer : answer:It depends on how much traffic you have and how data-intensive it is. Also, read-only requests are a lot lighter on resources than read-write. At the extremes, say you are running eBay ... a second server. If you make the web application modular, changing the data source later is pretty easy.

Can I force my Fedora Server to send an email when booted?

Description : Can I force my Fedora Server to send an email when booted?

Last Answer : Yes. It’s fairly straightforward, too. But what you might want to do is register with a dynamic DNS service like dyndns.org and use something like ddclient to update that automatically.

Free PHP Web Server for Dreamweaver?

Description : Free PHP Web Server for Dreamweaver?

Last Answer : answer:This is probably your best bet for getting PHP, Apache, and MySQL running easily. http://www.apachefriends.org/en/xampp.html It works well on most operating systems. I can't help with Dreamweaver ... add that xampp runs on your computer. No need for a external server. It is great for testing.

What is a web server ?

Description : What is a web server ?

Last Answer : A web server is a special kind of hardware and software that can be used to understand any data stored on that server that can be accessed via the Internet.

Describe re-entrant procedure with the help of schematic diagram.

Description : Describe re-entrant procedure with the help of schematic diagram.

Last Answer : Re-entrant Procedures: A procedure is said to be re-entrant, if it can be interrupted, used and re-entered without losing or writing over anything. To be a re-entrant, Procedure ... program execution flow reenters in the procedure1. These types of procedures are called reentrant procedures.

In SQL, which commandis used to remove a stored function from the database? . REMOVE FUNCTION B. DELETE FUNCTION C. DROP FUNCTION D. ERASE FUNCTION E. None of the above

Description : In SQL, which commandis used to remove a stored function from the database? . REMOVE FUNCTION B. DELETE FUNCTION C. DROP FUNCTION D. ERASE FUNCTION E. None of the above

Last Answer : DROP FUNCTION

. In SQL, which command(s) is(are) usedto recompilea storedfunction? A. SET FUNCTION B. SET STORED FUNCTION C. ALTER FUNCTION D. All of theabove E. None of the above

Description : . In SQL, which command(s) is(are) usedto recompilea storedfunction? A. SET FUNCTION B. SET STORED FUNCTION C. ALTER FUNCTION D. All of theabove E. None of the above

Last Answer : ALTER FUNCTION

How does one use ORADEBUG from Server Manager/ SQL*Plus? (for DBA

Description : How does one use ORADEBUG from Server Manager/ SQL*Plus? (for DBA

Last Answer : Execute the "ORADEBUG HELP" command from svrmgrl or sqlplus to obtain a list of valid ORADEBUG commands. Look at these examples: SQLPLUS> REM Trace SQL statements with bind variables SQLPLUS> oradebug ... oradebug lkdebug -a convres SQLPLUS> oradebug lkdebug -r (i.e 0x8066d338 from convres dump)

Learning SQL Server 05

Description : Learning SQL Server 05

Last Answer : http://www.sqlcourse.com/

Points to resolve corruption of SQL server database?

Description : Points to resolve corruption of SQL server database?

Last Answer : Often the corruption for the SQL server database can't be resolved. And the best thing one can do is just roll over the past backup. And by that there is going to be certain amount of the data loss. But you have to make use of that instead of losing everything.

what are the features and data management strategies of SQL Server?

Description : what are the features and data management strategies of SQL Server?

Last Answer : SQL is one of the most demanding skill in the current world. Every day a huge amount of data is collected and one have to deal with these databases to make an ... : High Performance High Availability Scalability and Flexibility Robust Transactional Support High Security Management Ease Open Source

Between Windows Authentication and SQL Server Authentication, which one is trusted and which one is untrusted?

Description : Between Windows Authentication and SQL Server Authentication, which one is trusted and which one is untrusted?

Last Answer : Windows Authentication is trusted because the username and password are checked with the Active Directory, the SQL Server authentication is untrusted, since SQL Server is the only verifier participating in the transaction.

What connections does Microsoft SQL Server support?

Description : What connections does Microsoft SQL Server support? 

Last Answer : Windows Authentication (via Active Directory) and SQL Server authentication (via Microsoft SQL Server username and password). 

Between Windows Authentication and SQL Server Authentication, which one is trusted and which one is untrusted?

Description : Between Windows Authentication and SQL Server Authentication, which one is trusted and which one is untrusted?

Last Answer : Windows Authentication is trusted because the username and password are checked with the Active Directory, the SQL Server authentication is untrusted, since SQL Server is the only verifier participating in the transaction.

What connections does Microsoft SQL Server support?

Description : What connections does Microsoft SQL Server support?

Last Answer : Windows Authentication (via Active Directory) and SQL Server authentication (via Microsoft SQL Server username and password).

The most open source DBMS. A) Microsoft SQL Server B) Microsoft Access C) MySQL D) Oracle

Description : The most open source DBMS. A) Microsoft SQL Server B) Microsoft Access C) MySQL D) Oracle

Last Answer : MySQL

The most popular commercial DBMS. A) Microsoft SQL Server B) Microsoft Access C) MySQL D) Oracle

Description : The most popular commercial DBMS. A) Microsoft SQL Server B) Microsoft Access C) MySQL D) Oracle

Last Answer : Oracle

Point out the wrong statement. a) Wolf Frameworks uses a C# engine and supports both Microsoft SQL Server and MySQL database b) Applications built in Wolf are 50-percent browser-based and support mashable and multisource overlaid content c) Google applications are cloud-based applications d) None of the mentioned

Description : Point out the wrong statement. a) Wolf Frameworks uses a C# engine and supports both Microsoft SQL Server and MySQL database b) Applications built in Wolf are 50-percent browser-based ... and multisource overlaid content c) Google applications are cloud-based applications d) None of the mentioned

Last Answer : Applications built in Wolf are 50-percent browser-based and support mashable and multisource overlaid content

Point out the wrong statement. a) Wolf Frameworks uses a C# engine and supports both Microsoft SQL Server and MySQL database b) Applications built in Wolf are 50-percent browser-based and support mashable and multisource overlaid content c) Google applications are cloud-based applications d) None of the mentioned

Description : Point out the wrong statement. a) Wolf Frameworks uses a C# engine and supports both Microsoft SQL Server and MySQL database b) Applications built in Wolf are 50-percent browser-based ... and multisource overlaid content c) Google applications are cloud-based applications d) None of the mentioned

Last Answer : Applications built in Wolf are 50-percent browser-based and support mashable and multisource overlaid content

n which SQL Server version report builder introduced?

Description : n which SQL Server version report builder introduced?

Last Answer : Report builder introduced in SQL Server 2005. While creating or deploying report model project on report server you can get error or it might not get created. For this you need to

............... joins are SQL server default A) Outer B) Inner C) Equi D) None of the above

Description : ............... joins are SQL server default A) Outer B) Inner C) Equi D) None of the above

Last Answer : B) Inner

SQL server stores index information in the ………… system table A) systindexes B) systemindexes C) sysind D) sysindexes

Description : SQL server stores index information in the ………… system table A) systindexes B) systemindexes C) sysind D) sysindexes

Last Answer : D) sysindexes

………….. is a utility to capture a continuous record of server activity and provide auditing capability. A) SQL server Profile B) SQL server service manager C) SQL server setup D) SQL server wizard.

Description : ………….. is a utility to capture a continuous record of server activity and provide auditing capability. A) SQL server Profile B) SQL server service manager C) SQL server setup D) SQL server wizard.

Last Answer : B) SQL server service manager

………………… is a full form of SQL. A) Standard query language B) Sequential query language C) Structured query language D) Server side query language

Description : ………………… is a full form of SQL. A) Standard query language B) Sequential query language C) Structured query language D) Server side query language

Last Answer : A) Standard query language

What package procedure used for invoke sql *plus from sql *forms ?

Description : What package procedure used for invoke sql *plus from sql *forms ?

Last Answer : Host (E.g. Host (sqlplus))

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

Description : Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

Last Answer : No, a cursor variable points a row which cannot be stored in a two- dimensional PL/SQL table.

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Description : What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Last Answer : Procedures and Functions,Packages and Database Triggers.

Function or application allowing me to connect or disconnect wifi?

Description : Function or application allowing me to connect or disconnect wifi?

Last Answer : Some routers - Belkins and older Ciscos, had an app that would allow you to remotely-control your router from your phone. You didn't say what kind of router you have, so it's hard to guess. You can ... . Bottom line - you can do this easily if you have a wifi-based power switch and an app. example

How do you do an optimal binary search on a two variable function?

Description : How do you do an optimal binary search on a two variable function?

Last Answer : You need to clarify your terminology a little bit. Symmetric about the diagonal? Strictly increasing with respect to which ordering of the pairs?

How can I reset the clock in this (C++) timer function?

Description : How can I reset the clock in this (C++) timer function?

Last Answer : I don’t know C++ very well but “bool reset = false;” sounds like it shouldn’t be included

Math algorithm/function to convert this number to 40?

Description : Math algorithm/function to convert this number to 40?

Last Answer : answer:Sure the equation is y = 147.5x – 151.75 Where x is the number that goes from 1.3 to 1.7 And Y is the one that goes from 40 to 90. If you want it the other way let me know. Here it is: y = 0.0068x + 1.0288 Enjoy

How, in javascript/jquery, can I change what "this" refers to in an event handling function?

Description : How, in javascript/jquery, can I change what "this" refers to in an event handling function?

Last Answer : By using the call and apply prototype methods of Functions. For example: function example () { console.log(this); } example.call(window); this will be the window variable. example.call( a string'); this will ... 2'); Hope this helps. If you need any more help with this, feel free to just ask.

What is the main function of web design ?

Description : What is the main function of web design ?

Last Answer : The main function of web design is to create templates.

What is meant by recursive function ?

Description : What is meant by recursive function ?

Last Answer : Answer : When a function in C program automatically calls itself, that function is called recursive function and this process is called recursive. It is very difficult to understand recursive ... be easily solved by recursive functions. Each recursive function has to have a terminating condition.

What are the functions of Printf () and Getch () function ?

Description : What are the functions of Printf () and Getch () function ?

Last Answer : The most commonly used function as an output statement in C language is printf (), which can be used to display various types of data (such as int, Char, float, etc.), including strings or strings ... programming . That is, both print () and getch () act as essential functions for C programming .

What is the function of assembler ?

Description : What is the function of assembler ?

Last Answer : : Assembler's job (1) is to convert the nominal code into machine language. (2) The Assembly converts the address into an address written in machine language. (3) Verify that each instruction ... all the mistakes. (6) To make every instruction in assembly language an instruction in machine language.

Free antivirus program for Windows Server 2008?

Description : Free antivirus program for Windows Server 2008?

Last Answer : Do you have microsoft security essentials?

Is there a way to make a default roaming profile using Server 2008 on a 2003 domain?

Description : Is there a way to make a default roaming profile using Server 2008 on a 2003 domain?

Last Answer : Not too familiar with how roaming profiles look, but I would suggest asking this question on Super User. If you don’t want to go through making an account, I’ll ask it for you and provide you with the answers.