Monday, 27 May 2013

sql query with
tag

select c.CarID, c.SellerID, c.Car_Name,'Car For :'+ c.Car_For +'<br /> Condition :'+ c.Condition as cardetail, c.Price,'Currency Type :'+ c.Currency_Type +'<br /> Car Type :'+ c.[Type] +'<br /> Car Make :'+ c.Make  as car_type,
 'Registered Year :'+ c.RegistrationYear +'<br /> Milage :'+ c.Milage+'<br /> Terminal :'+ c.Terminal+'<br />Engine Capacity :'+ c.Engine_Capacity+'<br /> Colour :'+c.Colour as  CarData, c.ColourTye,  c.Description,
 c.datetime, c.Region, c.Sales_Type
 from dbo.Cars_Details_Master c where SellerID=@id

No comments:

Post a Comment