简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home> Database> Mysql Tutorial> body text

executesql 存储过程

WBOY
Release： 2016-06-07 17:59:39
Original
1258 people have browsed it

executesql 存储过程代码，需要的朋友可以参考下。

代码如下:
declare @tt varchar(20)
set @tt = 'monisubbouns'
declare @int int
declare @sql nvarchar(500)
set @sql = 'select @int=count(*) from ' + @tt
exec sp_executesql @sql,N'@int int output',@int output
print @int

Related labels：
stored procedure
source：php.cn
Previous article：Access 2007通过查询来计算累计余额 Next article：Access清空表后让编号复位
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
javascript - 如何给javascrpt读取本地sqlite的函数添加阻塞或设置为同步？ javascript读取sqlite时是异步的，可是现在我有几个操作不适合在.executeSql()里直接操作，比如要判断本地数据库里是否有相关记录，或是在用记录生成html内容...
From 2017-04-10 18:07:40
0
1
223
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！