declare @value varchar(100)
declare @strSql varchar(200)set @value = '1000,"abc"'set @strSql = 'insert into table1(' + @value ')'execute(@strSql)表table1中第二个字段要传入字符串,其中set @value = '???' 该怎么写?拜托各位啊
declare @strSql varchar(200)set @value = '1000,"abc"'set @strSql = 'insert into table1(' + @value ')'execute(@strSql)表table1中第二个字段要传入字符串,其中set @value = '???' 该怎么写?拜托各位啊
declare @strSql varchar(200) set @value = '1000,"abc"' set @strSql = 'insert into table1 values(' + @value ')' execute(@strSql)
declare @value varchar(100) set @value='abc'execute ('insert into tb1 values( 1000,''' + @value +''')')
execute('insert into tb1 values( 1000,''abc'')')
declare @strSql varchar(200) set @value = '1000,''abc'''
set @strSql = 'insert into tb1 values(' + @value +')' execute(@strSql)
set @value = 'abb'
set @strSql = 'insert into table1(' + quotename(@value,'''')+ ')'
declare @strSql varchar(200) set @value = '1000,''abc''' set @strSql = 'insert into table1 values(' + @value+ ')' print @strsql
execute(@strSql)