Calling stored procedure in Microsoft SQL server

Hi all ,
I am using VB6 SP 4 .
Need to call stored procedure from Microsoft SQL Server in VB 6 .
The stored procedure is show below :
update_carrier (user_id, carrier_no, card_lost)" where card_lost = N
Anyone have any sample code that i can take a look is much appreciated .
Thankshttp://msdn.microsoft.com/library/d...
cfn.asp
The fragment you posted is not a valid statement or stored procedure by
itself. It may be part of something else - although it does look a
little strange.
David Portas
SQL Server MVP
--|||Yes . I am new in SQL Stored Procedure .
BTW , how to create stored procedure Microsoft SQL Stored Procedure ?
Any tutorial links is much help to me .
Thanks
David Portas wrote:
> http://msdn.microsoft.com/library/d...r />
_9cfn.asp
> The fragment you posted is not a valid statement or stored procedure by
> itself. It may be part of something else - although it does look a
> little strange.
>|||Lookup CREATE PROCEDURE in Books Online.
The link I posted before is to the web version of Books Online - the
SQL Server documentation set. Books Online (BOL) should be your first
point of reference for SQL Server questions. It should be installed on
your machine as part of your SQL installation, or you can get it here:
http://www.microsoft.com/sql/techin...00/default.mspx
David Portas
SQL Server MVP
--