Hello everybody,
I have a file with several asp functions where some depend on others.
Some of the functions I will need to transform a string value.
How can I include these functions in a stored procedure? (in Sql
Server 2000)
Do I have to add all the functions as userdefined functions?
Or is possible to reference the external file like include files in
asp?
Thank you for your help!
Regards,
Michael
3  1318 
Michael Freiermuth (fr********@net elite.ch) writes: I have a file with several asp functions where some depend on others.
Some of the functions I will need to transform a string value.
How can I include these functions in a stored procedure? (in Sql
Server 2000)
Do I have to add all the functions as userdefined functions?
Or is possible to reference the external file like include files in
asp?
I would probably be possible to do, if you put those function in a COM
object and then invoke this COM object with sp_OAmethod and friends.
But there are all sorts of issues with this path, including performance.
You probably better off rewriting the functions in T-SQL, unless the
string transformations are immensly complex.
In the next version of SQL Server, SQL 2005, currently in beta, it's a
different matter. There you can put code written in .Net languages
inside SQL Server. (Not ASP classic, though.)
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
Really? Is there an FAQ about this anywhere....?
"Erland Sommarskog" <es****@sommars kog.se> wrote in message
news:Xn******** **************@ 127.0.0.1... Michael Freiermuth (fr********@net elite.ch) writes: I have a file with several asp functions where some depend on others.
Some of the functions I will need to transform a string value.
How can I include these functions in a stored procedure? (in Sql
Server 2000)
Do I have to add all the functions as userdefined functions?
Or is possible to reference the external file like include files in
asp?
I would probably be possible to do, if you put those function in a COM
object and then invoke this COM object with sp_OAmethod and friends.
But there are all sorts of issues with this path, including performance.
You probably better off rewriting the functions in T-SQL, unless the
string transformations are immensly complex.
In the next version of SQL Server, SQL 2005, currently in beta, it's a
different matter. There you can put code written in .Net languages
inside SQL Server. (Not ASP classic, though.)
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp http://www.microsoft.com/sql/2005/pr...30features.asp
Under the developer heading. There is a lot more information on the site. http://msdn.microsoft.com/sql/defaul...lrguidance.asp
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mi**@epprecht.n et
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Robin Tucker" <id************ *************@r eallyidont.com> wrote in
message news:cq******** ***********@new s.demon.co.uk.. . Really? Is there an FAQ about this anywhere....?
"Erland Sommarskog" <es****@sommars kog.se> wrote in message
news:Xn******** **************@ 127.0.0.1... Michael Freiermuth (fr********@net elite.ch) writes: I have a file with several asp functions where some depend on others.
Some of the functions I will need to transform a string value.
How can I include these functions in a stored procedure? (in Sql
Server 2000)
Do I have to add all the functions as userdefined functions?
Or is possible to reference the external file like include files in
asp?
I would probably be possible to do, if you put those function in a COM
object and then invoke this COM object with sp_OAmethod and friends.
But there are all sorts of issues with this path, including performance.
You probably better off rewriting the functions in T-SQL, unless the
string transformations are immensly complex.
In the next version of SQL Server, SQL 2005, currently in beta, it's a
different matter. There you can put code written in .Net languages
inside SQL Server. (Not ASP classic, though.)
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Bob Murdoch |
last post by:
I have an ASP application that calls a COM function to create a custom
report as an Excel file. This works in a synchronous fashion, as long as
the report does not take too long to create. If that happens, the session
times out and we run into other kinds of problems.
I have, in other cases, executed a stored procedure asynchronously (thanks
to a tip from this group) thru ADO.
I'm wondering if ASP provides some way of executing a...
|
by: Mark Oueis |
last post by:
Is there any way I can retrieve the result set of a Stored Procedure
in a function.
ALTER FUNCTION dbo.fn_GroupDeviceLink
(
@groupID numeric
)
RETURNS @groupDeviceLink TABLE (GroupID numeric, DeviceID numeric)
AS
BEGIN
|
by: Lauren Quantrell |
last post by:
Is there a way to create a text file (such as a Windows Notepad file)
by using a trigger on a table? What I want to do is to send a row of
information to a table where the table: tblFileData has only one
column: txtOutput
I want to use the DB front end (MS Access) to send the text string to
the SQL backend, then have the SQL Server create a file to a path,
such as F:/myfiledate.txt that holds the text in txtOutput, then the
trigger...
|
by: Mariusz |
last post by:
I want to write function to call another function which name is
parameter to first function. Other parameters should be passed to
called function.
If I call it function('f1',10) it should call f1(10). If I call it
function('f2',5) it should call f2(5).
So far i tried something like
CREATE FUNCTION . (@f varchar(50),@m money)
RETURNS varchar(50) AS
|
by: dharmadam |
last post by:
Is it possible to pass a column name or the order of the column name
in the DB2 table table function. For example, I want to update the
address of a person by passing one of the address column name like ZIP
CODE or ADDRESS LINE. I will call the function with three
parameter--UpdateAddress(5,zip_code,person_id) where 5 indicates
ZIP_CODE is the fifth column in the table. If 4 is passed, it
indicates the address line is to be updated.
...
| | |
by: Steve Blinkhorn |
last post by:
Does anyone know of a way of accessing and modifying variables declared
static within a function from outside that function? Please no
homilies on why it's bad practice: the context is very particular and
involves automatically generated code. I know several other ways of
attacking my problem, but this would be the cleanest if it could be made
to work.
A little more context. I use C as the output of a code generating
system which...
|
by: satish mullapudi |
last post by:
Hi,
I am using DB2 v8.2 & jdk 1.4.
1. I have a java program which returns an array which contains 1 to 5
numbers.
The code:
public class ArrayTest
{
public static final int ARRAY_SIZE = 5;
public static int array()
{
|
by: SethM |
last post by:
I have a stored procedure that returns a record set. I want to
functionalize this so I can have multiple presentations of the same
record set. However, I can not get rs_event.open StoreProc to pass
through the function, so I can use rs_event("Title"), etc, etc. Is
this possible to do? If so how? Thanks.
Regards,
Seth
|
by: IuliaS |
last post by:
Hello everyone!
I want to create a stored procedure, so I can more easily, and transparent retrieve data from db2. Long story short: when a user wants to put some data in the DB, he also creates the tables and their links. When getting the data from the DB... well suffice to say it's ugly. I want to use one stored procedure that will return a result set as (name, value) pairs so I can display it nice and easy in the UI. So far I've managed to...
|
by: jamesclose |
last post by:
My problem is this (apologies if this is a little long ... hang in there):
I can define a function in VB.NET with optional parameters that wraps a SQL procedure:
Sub Test(Optional ByVal Arg1 As Integer = 0, _
Optional ByVal Arg2 As Integer = 0, _
Optional ByVal Arg3 As Integer = 0)
' Call my SQL proc with the same signature
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
