|
Sql Server Job not running
11/12/2006 2:50:02 PM
(Total replies: 1)
|
| whenever I have put 'insert into tabl_name (f1,f2)(1,1)' query under asql job with every 1 minute schedule then it works fine with job but whenever I put following code instead of insert statement then it fails.
Please give me any idea.
declare @compcode as varchar(10)
declare @segcode as varchar(10)
declare @lubenonlube as varchar(10)
declare @query as varchar(8000)
select @compcode =comp_code,@segcode=segment_code,@lubenonlube=lubenonlube from sheduled_potCalc
if @@rowcount > ... |
|
|
|
|
|
|
Sql Server Registration failed
16/03/2006 12:36:33 PM
(Total replies: 1)
|
| I'm working on SQL Server 2k in Windows 2003. I have updated this with SP3 in first time itself.
Just after install I check that the TCP/IP protocol is enabled under the
server properties and then I try to Telnet into port 1433. On this one
particular box I get back the following:
C:\>telnet localhost 1433
Connecting to localhost...Could not open connection to the host, on port
1433: Connect failed.
For comparison I tested telnet on a couple other machines and I get back a
blank ... |
|
|
|
|
|
|
Adding results of called stored proc. which returns value as row
23/02/2006 8:36:06 PM
(Total replies: 1)
|
| I am calling one stored procedure from another
There are no output parameters in test2 procedure
1st proc
-------------------------------
create proc test1 as
declare @TotalSell float
exec @TotalSell= test2 '1,'2','3'
select @TotalSell=@TotalSell+100
print @TotalSell
------------------------------------------------
2nd Proc
-----------------------------------------
create proc test2 (
@p1 Int,
@p2 real,
@p3 Int
)
AS
SET @price = @p1+@p2+@p3
/* ... |
|
|
|
Re: Adding results of called stored proc. which returns value as row
24/02/2006 1:30:01 PM
(Total replies: 1)
|
| Hi Philip,
Your solution is correct but I don't want to use this solution as this will not give less response time for executing. I want to call this proc for more than 10000 times in one shot.
Can you please suggest me any other solution?
Thanks,
IP
|
|
|
|
|
|
|
|
|
|
|
|
|
Connection of SQL Server Database through VPN in VB 6.0
22/09/2005 11:53:53 AM
(Total replies: 1)
|
| Hi Friends,
I want to connect to SQL Server database though VPN connection.
Means Server A is at AUS on which VB application is placed.
Server B is at Japan on which Sql server DB presnt. Both servers are connected though VPN.
I am writing following code in VB main:
Global JpanconAs New ADODB.Connection
------
Jpancon.Open "Japan Sql Server Connection String"
DoEvents
I am writing following Code in the startup form's form Load event:
Dim Rs As New ADODB.Recordset
... |
|