I'm not new to ASP or MSSQL but fairly new to using Stored Procedures. I've
got a T-SQL book on order from Amazon but it's still not here.
I have a SP which updates a record. As far as I can tell, the SP is fine.
It checks OK for syntax and when I recreate the update statement in Query
Analyzer, it seems to do fine. However, when I debug the SP in QA and enter
in all the params, it returns "@RETURN_VALUE = 0". I assume this means 0
rows updated? If so, why? I can't seem to find anything wrong with my SP.
Below is my code from MSSQL and my .NET page. Any pointers? Advice? Thanks
guys!!!
MY SP from QA:
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
ALTER PROCEDURE spOLGA3_UpdatePerfData
(@intID Int,
@strSystemName Nvarchar(100),
@strFYEnding Nvarchar(15),
@intPopulation Int,
@mnyTotOpExp Money,
@mnyTotOpRev Money,
@intDriversPT Int,
@intDriversFT Int,
@intMaintPT Int,
@intMaintFT Int,
@intAdminPT Int,
@intAdminFT Int,
@intOtherPT Int,
@intOtherFT Int)
AS
UPDATE OLGA3_PerformanceData SET
TransitSystemName = @strSystemName,
FiscalYearEnding = @strFYEnding,
Population = @intPopulation,
TotalExpense = @mnyTotOpExp,
TotalRevenue = @mnyTotOpRev,
DriversPT = @intDriversPT,
DriversFT = @intDriversFT,
MaintPT = @intMaintPT,
MaintFT = @intMaintFT,
AdminPT = @intAdminPT,
AdminFT = @intAdminFT,
OthersPT = @intOtherPT,
OthersFT = @intOtherFT
WHERE ID = @intID
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
My .asp.net page:
cmdInsert = New SqlCommand("spOLGA3_InsertPerfModeData", objConnection)
cmdInsert.CommandType = CommandType.StoredProcedure
cmdInsert.Parameters.AddWithValue("@intPerfDataID" , intHeaderID)
cmdInsert.Parameters.AddWithValue("@intTransitMode ", intModeID)
cmdInsert.Parameters.AddWithValue("@strOtherDesc", strOtherDescription)
cmdInsert.Parameters.AddWithValue("@mnyExpense", decExpense)
cmdInsert.Parameters.AddWithValue("@mnyRevenue", decRevenue)
cmdInsert.Parameters.AddWithValue("@intRevMiles", intRevMiles)
cmdInsert.Parameters.AddWithValue("@intRevHours", intRevHours)
cmdInsert.Parameters.AddWithValue("@intPassTrips", intPassTrips)
cmdInsert.Parameters.AddWithValue("@intPassMiles", intPassMiles)
cmdInsert.Parameters.AddWithValue("@intVehicles", intVehicles)
cmdInsert.Parameters.AddWithValue("@intAccidents", intAccidents)
cmdInsert.Parameters.AddWithValue("@intInjuries", intInjuries)
cmdInsert.Parameters.AddWithValue("@intFatalities" , intFatalities)
cmdInsert.Parameters.AddWithValue("@mnyAdultFare", decAdultFare)
cmdInsert.Parameters.AddWithValue("@mnyAdultFareNP ", decAdultFareNP)
cmdInsert.Parameters.AddWithValue("@mnySeniorFare" , decSeniorFare)
cmdInsert.Parameters.AddWithValue("@mnySeniorFareN P", decSeniorFareNP)
cmdInsert.Parameters.AddWithValue("@mnyStudentFare ", decStudentFare)
cmdInsert.Parameters.AddWithValue("@mnyStudentFare NP", decStudentFareNP)
cmdInsert.Parameters.AddWithValue("@mnySpecialFare ", decSpecialFare)
cmdInsert.Parameters.AddWithValue("@mnySpecialFare NP", decSpecialFareNP)
Try
objConnection.Open()
strResponse = cmdInsert.ExecuteNonQuery()
strResponse = "OK"
.....etc.......
9  1081 
My apologies. I posted the wrong code from my asp page. Here is the actual
call to the SP:
cmdUpdate = New SqlCommand("spOLGA3_UpdatePerfData", objConnection)
cmdUpdate.CommandType = CommandType.StoredProcedure
cmdUpdate.Parameters.AddWithValue("@intID", intHeaderID)
cmdUpdate.Parameters.AddWithValue("@strSystemName" , strSystemName)
cmdUpdate.Parameters.AddWithValue("@strFYEnding", strFYEnding)
cmdUpdate.Parameters.AddWithValue("@intPopulation" , intPopulation)
cmdUpdate.Parameters.AddWithValue("@mnyTotOpExp", decTotalOpExp)
cmdUpdate.Parameters.AddWithValue("@mnyTotOpRev", decTotalOpRev)
cmdUpdate.Parameters.AddWithValue("@intDriversPT", intDriversPT)
cmdUpdate.Parameters.AddWithValue("@intDriversFT", intDriversFT)
cmdUpdate.Parameters.AddWithValue("@intMaintPT", intMaintPT)
cmdUpdate.Parameters.AddWithValue("@intMaintFT", intMaintFT)
cmdUpdate.Parameters.AddWithValue("@intAdminPT", intAdminPT)
cmdUpdate.Parameters.AddWithValue("@intAdminFT", intAdminFT)
cmdUpdate.Parameters.AddWithValue("@intOtherPT", intOtherFT)
cmdUpdate.Parameters.AddWithValue("@intOtherFT", intOtherFT)
Try
objConnection.Open()
cmdUpdate.ExecuteNonQuery()
strResponse = "OK"
"D. Shane Fowlkes" <sh**********@h-o-t-m-a-i-l.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl... I'm not new to ASP or MSSQL but fairly new to using Stored Procedures.
I've got a T-SQL book on order from Amazon but it's still not here.
I have a SP which updates a record. As far as I can tell, the SP is fine.
It checks OK for syntax and when I recreate the update statement in Query
Analyzer, it seems to do fine. However, when I debug the SP in QA and
enter in all the params, it returns "@RETURN_VALUE = 0". I assume this
means 0 rows updated? If so, why? I can't seem to find anything wrong
with my SP.
Below is my code from MSSQL and my .NET page. Any pointers? Advice?
Thanks guys!!!
MY SP from QA:
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
ALTER PROCEDURE spOLGA3_UpdatePerfData
(@intID Int,
@strSystemName Nvarchar(100),
@strFYEnding Nvarchar(15),
@intPopulation Int,
@mnyTotOpExp Money,
@mnyTotOpRev Money,
@intDriversPT Int,
@intDriversFT Int,
@intMaintPT Int,
@intMaintFT Int,
@intAdminPT Int,
@intAdminFT Int,
@intOtherPT Int,
@intOtherFT Int)
AS
UPDATE OLGA3_PerformanceData SET
TransitSystemName = @strSystemName,
FiscalYearEnding = @strFYEnding,
Population = @intPopulation,
TotalExpense = @mnyTotOpExp,
TotalRevenue = @mnyTotOpRev,
DriversPT = @intDriversPT,
DriversFT = @intDriversFT,
MaintPT = @intMaintPT,
MaintFT = @intMaintFT,
AdminPT = @intAdminPT,
AdminFT = @intAdminFT,
OthersPT = @intOtherPT,
OthersFT = @intOtherFT
WHERE ID = @intID
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
My .asp.net page:
cmdInsert = New SqlCommand("spOLGA3_InsertPerfModeData", objConnection)
cmdInsert.CommandType = CommandType.StoredProcedure
cmdInsert.Parameters.AddWithValue("@intPerfDataID" , intHeaderID)
cmdInsert.Parameters.AddWithValue("@intTransitMode ", intModeID)
cmdInsert.Parameters.AddWithValue("@strOtherDesc", strOtherDescription)
cmdInsert.Parameters.AddWithValue("@mnyExpense", decExpense)
cmdInsert.Parameters.AddWithValue("@mnyRevenue", decRevenue)
cmdInsert.Parameters.AddWithValue("@intRevMiles", intRevMiles)
cmdInsert.Parameters.AddWithValue("@intRevHours", intRevHours)
cmdInsert.Parameters.AddWithValue("@intPassTrips", intPassTrips)
cmdInsert.Parameters.AddWithValue("@intPassMiles", intPassMiles)
cmdInsert.Parameters.AddWithValue("@intVehicles", intVehicles)
cmdInsert.Parameters.AddWithValue("@intAccidents", intAccidents)
cmdInsert.Parameters.AddWithValue("@intInjuries", intInjuries)
cmdInsert.Parameters.AddWithValue("@intFatalities" , intFatalities)
cmdInsert.Parameters.AddWithValue("@mnyAdultFare", decAdultFare)
cmdInsert.Parameters.AddWithValue("@mnyAdultFareNP ", decAdultFareNP)
cmdInsert.Parameters.AddWithValue("@mnySeniorFare" , decSeniorFare)
cmdInsert.Parameters.AddWithValue("@mnySeniorFareN P", decSeniorFareNP)
cmdInsert.Parameters.AddWithValue("@mnyStudentFare ", decStudentFare)
cmdInsert.Parameters.AddWithValue("@mnyStudentFare NP", decStudentFareNP)
cmdInsert.Parameters.AddWithValue("@mnySpecialFare ", decSpecialFare)
cmdInsert.Parameters.AddWithValue("@mnySpecialFare NP", decSpecialFareNP)
Try
objConnection.Open()
strResponse = cmdInsert.ExecuteNonQuery()
strResponse = "OK"
....etc.......
"D. Shane Fowlkes" <sh**********@h-o-t-m-a-i-l.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl... My apologies. I posted the wrong code from my asp page. Here is the
actual call to the SP:
A couple of things:
1) Forget about the return value for a minute - does the data actually get
updated...?
2) ExecuteNonQuery() returns an integer, but it looks like you're expecting
it to return a string...
No error returned
"D. Shane Fowlkes" <sh**********@h-o-t-m-a-i-l.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl... I'm not new to ASP or MSSQL but fairly new to using Stored Procedures.
I've got a T-SQL book on order from Amazon but it's still not here.
I have a SP which updates a record. As far as I can tell, the SP is fine.
It checks OK for syntax and when I recreate the update statement in Query
Analyzer, it seems to do fine. However, when I debug the SP in QA and
enter in all the params, it returns "@RETURN_VALUE = 0". I assume this means 0
rows updated? If so, why? I can't seem to find anything wrong with my
SP.
Below is my code from MSSQL and my .NET page. Any pointers? Advice?
Thanks guys!!!
MY SP from QA:
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
ALTER PROCEDURE spOLGA3_UpdatePerfData
(@intID Int,
@strSystemName Nvarchar(100),
@strFYEnding Nvarchar(15),
@intPopulation Int,
@mnyTotOpExp Money,
@mnyTotOpRev Money,
@intDriversPT Int,
@intDriversFT Int,
@intMaintPT Int,
@intMaintFT Int,
@intAdminPT Int,
@intAdminFT Int,
@intOtherPT Int,
@intOtherFT Int)
AS
UPDATE OLGA3_PerformanceData SET
TransitSystemName = @strSystemName,
FiscalYearEnding = @strFYEnding,
Population = @intPopulation,
TotalExpense = @mnyTotOpExp,
TotalRevenue = @mnyTotOpRev,
DriversPT = @intDriversPT,
DriversFT = @intDriversFT,
MaintPT = @intMaintPT,
MaintFT = @intMaintFT,
AdminPT = @intAdminPT,
AdminFT = @intAdminFT,
OthersPT = @intOtherPT,
OthersFT = @intOtherFT
WHERE ID = @intID
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
My .asp.net page:
cmdInsert = New SqlCommand("spOLGA3_InsertPerfModeData", objConnection)
cmdInsert.CommandType = CommandType.StoredProcedure
cmdInsert.Parameters.AddWithValue("@intPerfDataID" , intHeaderID)
cmdInsert.Parameters.AddWithValue("@intTransitMode ", intModeID)
cmdInsert.Parameters.AddWithValue("@strOtherDesc", strOtherDescription)
cmdInsert.Parameters.AddWithValue("@mnyExpense", decExpense)
cmdInsert.Parameters.AddWithValue("@mnyRevenue", decRevenue)
cmdInsert.Parameters.AddWithValue("@intRevMiles", intRevMiles)
cmdInsert.Parameters.AddWithValue("@intRevHours", intRevHours)
cmdInsert.Parameters.AddWithValue("@intPassTrips", intPassTrips)
cmdInsert.Parameters.AddWithValue("@intPassMiles", intPassMiles)
cmdInsert.Parameters.AddWithValue("@intVehicles", intVehicles)
cmdInsert.Parameters.AddWithValue("@intAccidents", intAccidents)
cmdInsert.Parameters.AddWithValue("@intInjuries", intInjuries)
cmdInsert.Parameters.AddWithValue("@intFatalities" , intFatalities)
cmdInsert.Parameters.AddWithValue("@mnyAdultFare", decAdultFare)
cmdInsert.Parameters.AddWithValue("@mnyAdultFareNP ", decAdultFareNP)
cmdInsert.Parameters.AddWithValue("@mnySeniorFare" , decSeniorFare)
cmdInsert.Parameters.AddWithValue("@mnySeniorFareN P", decSeniorFareNP)
cmdInsert.Parameters.AddWithValue("@mnyStudentFare ", decStudentFare)
cmdInsert.Parameters.AddWithValue("@mnyStudentFare NP", decStudentFareNP)
cmdInsert.Parameters.AddWithValue("@mnySpecialFare ", decSpecialFare)
cmdInsert.Parameters.AddWithValue("@mnySpecialFare NP", decSpecialFareNP)
Try
objConnection.Open()
strResponse = cmdInsert.ExecuteNonQuery()
strResponse = "OK"
....etc.......
all sqlserver stored procs are integer functions. take the following proc
create procedure myProc @a int
as
select @a as "foo"
return 1
and can be executed the following way
declare @return_value int
exec @return_value = myproc
@return_value will be one, and the value of @a will be returned in the
result set. note, the name @return_value is arbitrary. to get from ado.net,
declare a parameter of Diection ReturnValue. also note, that the return
value is not avaiable until all result sets have been processed
(ExecuteNonQuery will do this.)
-- bruce (sqlwork.com)
"D. Shane Fowlkes" <sh**********@h-o-t-m-a-i-l.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl... I'm not new to ASP or MSSQL but fairly new to using Stored Procedures.
I've got a T-SQL book on order from Amazon but it's still not here.
I have a SP which updates a record. As far as I can tell, the SP is fine.
It checks OK for syntax and when I recreate the update statement in Query
Analyzer, it seems to do fine. However, when I debug the SP in QA and
enter in all the params, it returns "@RETURN_VALUE = 0". I assume this
means 0 rows updated? If so, why? I can't seem to find anything wrong
with my SP.
Below is my code from MSSQL and my .NET page. Any pointers? Advice?
Thanks guys!!!
MY SP from QA:
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
ALTER PROCEDURE spOLGA3_UpdatePerfData
(@intID Int,
@strSystemName Nvarchar(100),
@strFYEnding Nvarchar(15),
@intPopulation Int,
@mnyTotOpExp Money,
@mnyTotOpRev Money,
@intDriversPT Int,
@intDriversFT Int,
@intMaintPT Int,
@intMaintFT Int,
@intAdminPT Int,
@intAdminFT Int,
@intOtherPT Int,
@intOtherFT Int)
AS
UPDATE OLGA3_PerformanceData SET
TransitSystemName = @strSystemName,
FiscalYearEnding = @strFYEnding,
Population = @intPopulation,
TotalExpense = @mnyTotOpExp,
TotalRevenue = @mnyTotOpRev,
DriversPT = @intDriversPT,
DriversFT = @intDriversFT,
MaintPT = @intMaintPT,
MaintFT = @intMaintFT,
AdminPT = @intAdminPT,
AdminFT = @intAdminFT,
OthersPT = @intOtherPT,
OthersFT = @intOtherFT
WHERE ID = @intID
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
My .asp.net page:
cmdInsert = New SqlCommand("spOLGA3_InsertPerfModeData", objConnection)
cmdInsert.CommandType = CommandType.StoredProcedure
cmdInsert.Parameters.AddWithValue("@intPerfDataID" , intHeaderID)
cmdInsert.Parameters.AddWithValue("@intTransitMode ", intModeID)
cmdInsert.Parameters.AddWithValue("@strOtherDesc", strOtherDescription)
cmdInsert.Parameters.AddWithValue("@mnyExpense", decExpense)
cmdInsert.Parameters.AddWithValue("@mnyRevenue", decRevenue)
cmdInsert.Parameters.AddWithValue("@intRevMiles", intRevMiles)
cmdInsert.Parameters.AddWithValue("@intRevHours", intRevHours)
cmdInsert.Parameters.AddWithValue("@intPassTrips", intPassTrips)
cmdInsert.Parameters.AddWithValue("@intPassMiles", intPassMiles)
cmdInsert.Parameters.AddWithValue("@intVehicles", intVehicles)
cmdInsert.Parameters.AddWithValue("@intAccidents", intAccidents)
cmdInsert.Parameters.AddWithValue("@intInjuries", intInjuries)
cmdInsert.Parameters.AddWithValue("@intFatalities" , intFatalities)
cmdInsert.Parameters.AddWithValue("@mnyAdultFare", decAdultFare)
cmdInsert.Parameters.AddWithValue("@mnyAdultFareNP ", decAdultFareNP)
cmdInsert.Parameters.AddWithValue("@mnySeniorFare" , decSeniorFare)
cmdInsert.Parameters.AddWithValue("@mnySeniorFareN P", decSeniorFareNP)
cmdInsert.Parameters.AddWithValue("@mnyStudentFare ", decStudentFare)
cmdInsert.Parameters.AddWithValue("@mnyStudentFare NP", decStudentFareNP)
cmdInsert.Parameters.AddWithValue("@mnySpecialFare ", decSpecialFare)
cmdInsert.Parameters.AddWithValue("@mnySpecialFare NP", decSpecialFareNP)
Try
objConnection.Open()
strResponse = cmdInsert.ExecuteNonQuery()
strResponse = "OK"
....etc.......
Nope. Nothing gets updated.
The function itself which calls the SP returns a string to another sub. The
function called "strResponse" returns either "OK" or the actual error. It's
just how I do it....
"Mark Rae" <ma**@markN-O-S-P-A-M.co.uk> wrote in message
news:eb*************@TK2MSFTNGP10.phx.gbl... "D. Shane Fowlkes" <sh**********@h-o-t-m-a-i-l.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
My apologies. I posted the wrong code from my asp page. Here is the
actual call to the SP:
A couple of things:
1) Forget about the return value for a minute - does the data actually get
updated...?
2) ExecuteNonQuery() returns an integer, but it looks like you're
expecting it to return a string...
I just double checked. Nothing is getting updated yet I'm positive the PK
is correct. When I recreate the same UPDATE statement in QA, it works fine.
Is there something wrong with this SP?
CREATE PROCEDURE spOLGA3_UpdatePerfData
(@intID Int,
@strSystemName Nvarchar(100),
@strFYEnding Nvarchar(15),
@intPopulation Int,
@mnyTotOpExp Money,
@mnyTotOpRev Money,
@intDriversPT Int,
@intDriversFT Int,
@intMaintPT Int,
@intMaintFT Int,
@intAdminPT Int,
@intAdminFT Int,
@intOtherPT Int,
@intOtherFT Int)
AS
UPDATE OLGA3_PerformanceData SET
TransitSystemName = @strSystemName,
FiscalYearEnding = @strFYEnding,
Population = @intPopulation,
TotalExpense = @mnyTotOpExp,
TotalRevenue = @mnyTotOpRev,
DriversPT = @intDriversPT,
DriversFT = @intDriversFT,
MaintPT = @intMaintPT,
MaintFT = @intMaintFT,
AdminPT = @intAdminPT,
AdminFT = @intAdminFT,
OthersPT = @intOtherPT,
OthersFT = @intOtherFT
WHERE ID = @intID
GO
"D. Shane Fowlkes" <sh**********@h-o-t-m-a-i-l.com> wrote in message
news:ez****************@TK2MSFTNGP12.phx.gbl... Nope. Nothing gets updated.
The function itself which calls the SP returns a string to another sub.
The function called "strResponse" returns either "OK" or the actual error.
It's just how I do it....
"Mark Rae" <ma**@markN-O-S-P-A-M.co.uk> wrote in message
news:eb*************@TK2MSFTNGP10.phx.gbl... "D. Shane Fowlkes" <sh**********@h-o-t-m-a-i-l.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
My apologies. I posted the wrong code from my asp page. Here is the
actual call to the SP:
A couple of things:
1) Forget about the return value for a minute - does the data actually
get updated...?
2) ExecuteNonQuery() returns an integer, but it looks like you're
expecting it to return a string...
"D. Shane Fowlkes" <sh**********@h-o-t-m-a-i-l.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl... I just double checked. Nothing is getting updated yet I'm positive the PK
is correct. When I recreate the same UPDATE statement in QA, it works
fine. Is there something wrong with this SP?
Not as far as I can see. However, and please don't think I'm being
patronising here, is there the slightest possibility that your connection
string might not be pointing at the right server / database ...? I've seen
that so many times, it's almost always the first thing I check...
Yep. That's all OK. However, I think I've got some conflicting issues going
on with Page_Load and the buttons On_Click subs. I think one is canceling
the other out. Still researching.....
Thanks!
"Mark Rae" <ma**@markN-O-S-P-A-M.co.uk> wrote in message
news:uA**************@tk2msftngp13.phx.gbl... "D. Shane Fowlkes" <sh**********@h-o-t-m-a-i-l.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
I just double checked. Nothing is getting updated yet I'm positive the PK
is correct. When I recreate the same UPDATE statement in QA, it works
fine. Is there something wrong with this SP?
Not as far as I can see. However, and please don't think I'm being
patronising here, is there the slightest possibility that your connection
string might not be pointing at the right server / database ...? I've seen
that so many times, it's almost always the first thing I check...
look over the statement and execute in Query analyser and check...
actually in SP ... update will never return (1/0)
try adding your logic like this
create sp samp()
update table set col = 2 where colo2 = x
if (select a from table where colo2 = x and col = 2 )
i = 1
then
i = 0
end if
return i
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Brad Tilley |
last post by:
Is there an easier way to do this:
def print_whats_returned(function):
print function
print type(function)
|
by: Terri |
last post by:
Hi,
I am experiencing the following error from a particular XP workstation. The
application has been in production for some time and the error only appears
on one XP workstation. I have run...
|
by: Bill Davidson |
last post by:
Hello there,
I need help on understanding part of the macro below:
#define MY_MACRO( OP, RESULT ) \
( (RESULT = (OP)) != 0 ? (errno = RESULT, -1) : 0 )
What I do not understand is how is...
|
by: pkilambi |
last post by:
I wrote this function which does the following:
after readling lines from file.It splits and finds the word occurences
through a hash table...for some reason this is quite slow..can some one...
|
by: Martin Raychev |
last post by:
Hi all,
I have the following problem:
I have a private method that returns a SqlDataReader. For this to work I
have not to close the DB connection in the above method. I do this only to
|
by: DC Gringo |
last post by:
I am trying to pass an input parater to SQL Server. The parameter is a URL
querystring variable. I can't seem to get it to pass a variable, only a
literal value...
Help!
In the following...
|
by: arielCo |
last post by:
Hello,
I'm attempting to use proc_open to launch, control and log CLI
applications from my scripts, but my first tests are disheartening:
<pre>
<?php
$descriptorspec = array(
0 =>...
|
by: david |
last post by:
I have trouble with it.
I have created a sproc in SQL Server, called SearchClass, which returns a
searched key from a table. I have tested this procedure in Analyzer and it
works fine. However,...
|
by: dwhall |
last post by:
I'm developing PyMite and would like to know a little detail about
Python 2.5's design. Is it true that when the RETURN_VALUE executes
and pops its argument, that at that point the stack should...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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,...
|
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...
|
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,...
|
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...
| |
