I have the following stored procedure:
CREATE PROCEDURE spTest
AS
DECLARE @var1 as INT
Select @var1 = 12
SELECT UserID, Name from Users
GO
If I execute this stored procedure using “SQL Query Analyzer” everything seems to be OK (I’ll obtain the fields: UserdId, Name and var1), but if I try to...
Thanks Tirol for your idea,
But could you tell me please what I have to do if the databases are on different SQL servers (I mean one database is on a SQL server running in Canada and the other database is on a SQL server running in US).
Best regards,
Doru
Lets have the following databases:
1. One database containing a table named db1.“Accounts” with the following columns:
a.UserName
b.Symbol
c.NumberShares
Example:
UserName Symbol NumberShares
John Symb1 10
John Symb2 20
George Symb3 50
2. Another database...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.