应用实例
将查询结果插入临时表，临时数据不显示。
墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网
我也要 关注 + 加入社区各位帮忙看一下这个语句，我将查询结果取出插入临时 表，但查询临时表后却没有任何数据，不知什么原因。以下是代码
CREATE TABLE #bookcount
(
cataloguetype varchar(10),
bookclasscount int,
bookbl float,
moneycount numeric
)
declare @sql nvarchar(100)
set @sql=N'SELECT CatalogueType,COUNT(CatalogueType) as BookClassCount,
CAST(CONVERT(float, COUNT(CatalogueType) * 100) / CONVERT(float,
(SELECT COUNT(*) AS Expr1
FROM ' + @LibName+'.dbo.vBookTypeCatalogue
WHERE (BookType = 0))) AS decimal(18, 2)) as BookBL,SUM(Price) as MoneyCount into #bookcount FROM '+ @LibName+
'.dbo.vBookTypeCatalogue WHERE (BookType = 0) GROUP BY CatalogueType ORDER BY CatalogueType'
exec(@sql)
select * from #bookcount order by cataloguetype
CREATE TABLE #bookcount
(
cataloguetype varchar(10),
bookclasscount int,
bookbl float,
moneycount numeric
)
declare @sql nvarchar(100)
set @sql=N'SELECT CatalogueType,COUNT(CatalogueType) as BookClassCount,
CAST(CONVERT(float, COUNT(CatalogueType) * 100) / CONVERT(float,
(SELECT COUNT(*) AS Expr1
FROM ' + @LibName+'.dbo.vBookTypeCatalogue
WHERE (BookType = 0))) AS decimal(18, 2)) as BookBL,SUM(Price) as MoneyCount into #bookcount FROM '+ @LibName+
'.dbo.vBookTypeCatalogue WHERE (BookType = 0) GROUP BY CatalogueType ORDER BY CatalogueType'
exec(@sql)
select * from #bookcount order by cataloguetype
...全文
