日期:2014-05-17 浏览次数:20569 次
select Name from Student where Id=@Id
Id like '@Id %'
declare @tsql varchar(6000) select @tsql='select Name from Student where Id like '''+rtrim(@Id)+'%'' ' exec(@tsql)