if not exists (select * from RaporSql where TipNo=94 and DataSetName='STOKKARTI') begin insert into RaporSql (TipNo,SqlTanim,Durum,DataSetName) values (94,'SELECT StokNo, Kodu, StokAdi, AnaBirim, GrupAdi, UreticiFirmaKodu, OzelKod1, OzelKod2, F1Fiyat, F2Fiyat, F3Fiyat, F4Fiyat, F1DovizKodu, F2DovizKodu, F3DovizKodu, F4DovizKodu FROM STOKKARTI where Kodu=@StokKodu ','True','STOKKARTI') end else begin update RaporSql set Durum='True', SqlTanim='SELECT StokNo, Kodu, StokAdi, AnaBirim, GrupAdi, UreticiFirmaKodu, OzelKod1, OzelKod2, F1Fiyat, F2Fiyat, F3Fiyat, F4Fiyat, F1DovizKodu, F2DovizKodu, F3DovizKodu, F4DovizKodu FROM STOKKARTI where Kodu=@StokKodu ' where TipNo=94 and DataSetName='STOKKARTI' end if not exists (select * from RaporSqlParam where TipNo=94 and DataSetName='STOKKARTI' and ParamName='@StokKodu' ) begin insert into RaporSqlParam(TipNo,DataSetName,ParamName,DataFieldName,Durum,DataFieldType,ParamInDataSet) values ( 94,'STOKKARTI','@StokKodu','Kodu','True','string','True' ) end else begin update RaporSqlParam set DataFieldName='Kodu',Durum='True',DataFieldType='string',ParamInDataSet='True' where TipNo=94 and DataSetName='STOKKARTI' and ParamName='@StokKodu' end