Hi all,
I want to know, Is it possible to write a Stored-Procedure in SQl Server that can be apply on one .DBF table on my computer.?
In the other hand suppose we have a stored procedure for inserting one record to Sql's tables,now i want to use this stored procedure for inserting one record to a FoxPro(.DBF) table that is in "d:\MyFoxTable" directory.Note that Sql tables and Foxpro table are the same ( field type , number of fields & etc..). Is it possible such operation.? for example my Insert stored procedure is :
/////////////////////////////////////////////////////////////////////////////////////
CREATE procedure sp_InsertStd
@StdNo char(9),
@StdName varchar(20),
@StdFamil varchar(30)
As
insert into Student(StdNo,StdName,StdFamil) values(@StdNo,@StdName,@StdFamil)
GO
/////////////////////////////////////////////////////////////////////////////////////
IF i can do this ,how should i change the above stored procedure to achieve this effect.?
Thanks.