-- =============================================  
-- Author:  <Author,,Name>  
-- Create date: <Create Date,,>  
-- Description: <Description,,>  
-- =============================================  
CREATE PROCEDURE [dbo].[sp_GridViewKullaniciAktar]  
  
 @KaynakKullaniciNo int,  
 @HedefKullaniciNo int,  
 @KaynakVeritani nvarchar(50)  
   
AS  
BEGIN  
 DECLARE @Sql nvarchar(max);  
 SET @Sql = '  
 BEGIN TRANSACTION  
 BEGIN TRY  
    
  EXEC dbo.sp_GridViewSil @HedefKullaniciNo;  
  
  INSERT INTO GridView  
  (KayitIsmi, KullaniciNo, Duzen, GirdAdi, YaziTipi, YaziTipiStili, YaziTipiBoyutu, YaziTipiRengi)  
  SELECT KayitIsmi, @HedefKullaniciNo, Duzen, GirdAdi, YaziTipi, YaziTipiStili, YaziTipiBoyutu, YaziTipiRengi  
  FROM @KaynakVeritani.dbo.GridView AS GridView_1   
  where KullaniciNo = @KaynakKullaniciNo  
  
 COMMIT  
 END TRY  
 BEGIN CATCH  
  ROLLBACK  
 END CATCH  
 ';  
 Set @Sql = REPLACE(@Sql,'@KaynakVeritani',@KaynakVeritani);  
 Set @Sql = REPLACE(@Sql,'@HedefKullaniciNo',@HedefKullaniciNo);  
 Set @Sql = REPLACE(@Sql,'@KaynakKullaniciNo',@KaynakKullaniciNo);  
 exec sp_executesql @Sql;  
END