IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'YadAvari' AND  COLUMN_NAME = 'Title')
begin
	print 'Ok';
end
else
begin
	alter table YadAvari 
	add Title	nvarchar(200)
end
go


IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Yadavari' AND  COLUMN_NAME = 'TedadRooz')
begin

	alter table Yadavari
	Drop Column	TedadRooz
end
else
begin
	print 'Ok'
end

go


-- select * from YadAvari
update YadAvari
set TarikhSarResid = Tarikh
where TarikhSarResid = 0