jeevan
3/27/2007 3:15:00 PM
"Looch" <lucianoj2005@yahoo.com> wrote in message
news:1175006511.657843.102510@l77g2000hsb.googlegroups.com...
> Got a question with a stored procedure...
>
> Create Procedure GetCCInfo
> (
> @TickNumAuto nvarchar(255),
> @ExpDate datetime Output,
> @CardNumber bigint output,
> @CardType nchar(10) output,
> @NameOnCard nvarchar (50) output,
> )
>
> as
>
> select cc.CustomerID, cc.CardType, cc.CardNumber, cc.ExpDate,
> cc.NameOnCard from dbo.CreditCards cc inner join dbo.call_log cl on
> cc.CustomerID = cl.CustomerID where cl.TicketNumberAuto = @TickNumauto
>
> from here i want to return @CardType = cc.CardType, @CardNumber =
> cc.CardNumber, etc, but not sure how to go about it (msdn is down!!)
>
> Any help in the right direction would be much appreciated!
Create Procedure GetCCInfo
(
@TickNumAuto nvarchar(255),
@ExpDate datetime Output,
@CardNumber bigint output,
@CardType nchar(10) output,
@NameOnCard nvarchar (50) output,
)
as
select @CardType = cc.CardType,
@CardNumber = cc.CardNumber,
@ExpDate = cc.ExpDate,
@NameOnCard = cc.NameOnCard
from dbo.CreditCards cc
inner join dbo.call_log cl
on cc.CustomerID = cl.CustomerID
where cl.TicketNumberAuto = @TickNumauto
GO
I hope you're not planning to store unencrypted credit card info in your
database, as your query suggests.