Hello,
I'm working on a project in which in the past there was a Backend SQL Server db and a Sharepoint Site.
I have been asked get rid of the SQL server and create lists for the SQL tables (DONE). The new backend will now be Sharepoint.
I'm now working on a web service which will access the sharepoint site. I'm having a difficulty getting started on this. I have created the Web Service in VS but I'm not sure how to go about accessing the lists. In the previous project there were lots of Store Procs that access the SQL db. Simple example below:
CREATE PROCEDURE sp_example
(@number int,
@userId varchar (50) OUTPUT)
AS
SELECT @number = number
FROM tb_table1
WHERE number = @number
RETURN 0
Could someone provide me some guidance as accessing the lists and doing the above store proc? I believe I have all of the reference (also web references) necesarry.
Thank you in advance for any assistance provided!
I'm working on a project in which in the past there was a Backend SQL Server db and a Sharepoint Site.
I have been asked get rid of the SQL server and create lists for the SQL tables (DONE). The new backend will now be Sharepoint.
I'm now working on a web service which will access the sharepoint site. I'm having a difficulty getting started on this. I have created the Web Service in VS but I'm not sure how to go about accessing the lists. In the previous project there were lots of Store Procs that access the SQL db. Simple example below:
CREATE PROCEDURE sp_example
(@number int,
@userId varchar (50) OUTPUT)
AS
SELECT @number = number
FROM tb_table1
WHERE number = @number
RETURN 0
Could someone provide me some guidance as accessing the lists and doing the above store proc? I believe I have all of the reference (also web references) necesarry.
Thank you in advance for any assistance provided!