Charin Giriş Id Sini DEhiştirme...

Bunu Query Analyzer Ekleyin


CREATE Procedure AccChange
@OldAcc varchar(50),
@NewAcc varchar(50)
as
update tb_user set straccountid = @NewAcc where straccountid = @OldAcc
update account_char set straccountid = @NewAcc where straccountid = @OldAcc
print 'Degistirilen Hesap : ' + @OldAcc
print 'Yeni Hesabiniz : ' + @NewAcc
print 'Baþarýyla deðiþtirildi'
GO


Kullaným:

exec AccChange 'hesap adi' , 'yeni hesap adi'