<script type="text/javascript">
</script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
declare@tempStrvarchar(350)
select@tempStr='Updateweekcountset['+convert(varchar,@week)+']=['+convert(varchar,@week)+']+1where
userid='''+replace(@user,'''','''''')+''''
exec(@tempStr)
注意:使exec不能返回一些变量的值,而且当前的变量值在exec的语句里无效.
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
可以采用exec方法
declare@tempStrvarchar(350)
select@tempStr='Updateweekcountset['+convert(varchar,@week)+']=['+convert(varchar,@week)+']+1where
userid='''+replace(@user,'''','''''')+''''
exec(@tempStr)
注意:使exec不能返回一些变量的值,而且当前的变量值在exec的语句里无效.
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>