Posted on: 3/27/2015 5:32:17 PM | Views : 577

how can i create a stored procedure that   accept Cities.NameEN as @ Ciities.Name
select Provinces.ProvinceEn + ', '+Cities.NameEN List FROM         Cities INNER JOIN                       Provinces ON Cities.ProvinceId = Provinces.IdProvince                      order by Provinces.ProvinceEn                                   

please help to create a parametrized column in select from 2 tables

Go to the complete details ...