sql 语句中where子句后面like的条件如果有变量怎么写表达式?举例:申明游标等……declare @id varchar(50)fetch next from my_cursor into @idupdate tablename01 set 总数=sum(数量) from tablename02 ……where 数量 like @id
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/06 19:00:38
![sql 语句中where子句后面like的条件如果有变量怎么写表达式?举例:申明游标等……declare @id varchar(50)fetch next from my_cursor into @idupdate tablename01 set 总数=sum(数量) from tablename02 ……where 数量 like @id](/uploads/image/z/11785810-58-0.jpg?t=sql+%E8%AF%AD%E5%8F%A5%E4%B8%ADwhere%E5%AD%90%E5%8F%A5%E5%90%8E%E9%9D%A2like%E7%9A%84%E6%9D%A1%E4%BB%B6%E5%A6%82%E6%9E%9C%E6%9C%89%E5%8F%98%E9%87%8F%E6%80%8E%E4%B9%88%E5%86%99%E8%A1%A8%E8%BE%BE%E5%BC%8F%3F%E4%B8%BE%E4%BE%8B%EF%BC%9A%E7%94%B3%E6%98%8E%E6%B8%B8%E6%A0%87%E7%AD%89%E2%80%A6%E2%80%A6declare+%40id+varchar%2850%29fetch+next+from+my_cursor+into+%40idupdate+tablename01+set+%E6%80%BB%E6%95%B0%3Dsum%28%E6%95%B0%E9%87%8F%29+from+tablename02+%E2%80%A6%E2%80%A6where+%E6%95%B0%E9%87%8F+like+%40id)
sql 语句中where子句后面like的条件如果有变量怎么写表达式?举例:申明游标等……declare @id varchar(50)fetch next from my_cursor into @idupdate tablename01 set 总数=sum(数量) from tablename02 ……where 数量 like @id
sql 语句中where子句后面like的条件如果有变量怎么写表达式?
举例:
申明游标等……
declare @id varchar(50)
fetch next from my_cursor into @id
update tablename01 set 总数=sum(数量) from tablename02
……
where 数量 like @id+'%'
可是like后面的都要在单引号之中才行啊,应该怎么写啊?
sql 语句中where子句后面like的条件如果有变量怎么写表达式?举例:申明游标等……declare @id varchar(50)fetch next from my_cursor into @idupdate tablename01 set 总数=sum(数量) from tablename02 ……where 数量 like @id
declare @sql varchar(1000)
set @sql = 'update tablename01 set 总数=sum(数量) from tablename02
……
where 数量 like ''' + cast(@id as varchar(10) + '%'''
EXEC(@sql)