SQL----动态跳转

--sql动态跳转页面
select contentTable.Id as ID,mainTitle,titleTable.twoTitle ,contentTable.remark ,*,
link='otherproductinfo.aspx?productid='+rtrim(ltrim(convert(char(10),contentTable.Id)))
 from contenttable,titleTable 
where contentTable.connectionId=titleTable.Id 
 and imageTitle like '%技术总监黄老%'