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...
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.