- ALTER PROCEDURE [dbo].[sp_update_farmer_registration_web]
- @originname varchar(100),
- @farmerctscode varchar(100),
- @farmerseason varchar(100),
- @dateofjoinseco varchar(100),
- @governmentcode varchar(100),
- @firstname varchar(100),
- @lastname varchar(100),
- @surname varchar(100),
- @gender varchar(100),
- @dateofbirth varchar(100),
- @birthlocation varchar(100),
- @fathername varchar(100),
- @mothername varchar(100),
- @village varchar(100),
- @currentyearcooperative varchar(100),
- @phonenumber varchar(100),
- @observation varchar(100),
- @nooffarms varchar(100),
- @productionestimation varchar(100),
- @otherdetails varchar(max),
- @previouscropsdetails varchar(max),
- @firstlevelapprovalstatus varchar(100),
- @firstlevelapprovedby varchar(100),
- @secondlevelapprovalstatus varchar(100),
- @secondlevelapprovedby varchar(100),
- @firstlevelcomments varchar(max),
- @secondlevelcomments varchar(max),
- @updatedby varchar(100),
- @mastertype varchar(100)
- AS
- BEGIN
- SET NOCOUNT ON;
- DECLARE @sqlQuery VARCHAR(MAX)
- IF @mastertype = ''
- BEGIN
- SET @sqlQuery = 'UPDATE dbo.tbl_farmerregistration_' + @originname + ' SET farmerseason = ''' + @farmerseason + ''',
- dateofjoinseco = ''' + @dateofjoinseco + ''', governmentcode =''' + @governmentcode + ''', firstname = ''' + @firstname + ''',
- lastname = ''' + @lastname + ''', surname = ''' + @surname + ''', gender = ''' + @gender + ''', dateofbirth = ''' + @dateofbirth + ''',
- birthlocation = ''' + @birthlocation + ''', fathername = ''' + @fathername + ''', mothername = ''' + @mothername + ''',
- village = ''' + @village + ''', currentyearcooperative = ''' + @currentyearcooperative + ''',
- phonenumber = ''' + @phonenumber + ''', observation = ''' + @observation +''', nooffarms = ''' + @nooffarms + ''', produtionestimation = ''' + @productionestimation + ''',
- otherdetails = ''' + @otherdetails + ''',previouscropsdetails = ''' + @previouscropsdetails + ''',
- updatedby = ''' + @updatedby + ''', updateddate = GETDATE()
- WHERE farmerctscode = ''' + @farmerctscode + ''''
- END
This is the above SP
When i execute the below query as follows
- UPDATE dbo.tbl_farmerregistration_ivorycoast SET farmerseason = '2019',
- dateofjoinseco = '2012', governmentcode ='402787J', firstname = 'KITCHINDJOUHOU',lastname = 'OUATTARA', surname = 'A', gender = 'MALE', dateofbirth = '17/5/1981',birthlocation = 'FERKESSEDOUGOU', fathername = 'OUATTARA MEYERIGUE', mothername = 'OSSIELETIAN OUATTARA',
- WHERE farmerctscode = '1050669'
i get output in sql 2 rows affected in a table tbl_farmerregistration_ivorycoast two rows inserted for that farmerctscode = '1050669'
farmerseason dateofjoinseco governmentcode firstname lastname surname gender dateofbirth birthlocation fathername mothername
2019 2012 402787J KITCHINDJOUHOU OUATTARA A MALE 17/5/1981 Ferek Ras Osel
2019 2012 402787J KITCHINDJOUHOU OUATTARA A MALE 17/5/1981 Ferek Ras Osel
how to fix this issue.
please let me know.