SQL 2005 has a new feature called Common Table Expression (CTE). You don’t need to use table variable any more. It is more powerful. You can use it for recursive query, aggregation query etc. Ex.
_WITH tmpa (col1, col2, col3)
AS
(
SELECT col1, col2, col3 FROM a WHERE a.flag = 1
)
_SELECT * FROM tmp_a
WHERE tmpa.col1 like ‘aa%’
缺失模块。
1、请确保node版本大于6.2
2、在博客根目录（注意不是yilia根目录）执行以下命令：
npm i hexo-generator-json-content --save
3、在根目录_config.yml里添加配置：
jsonContent:
meta: false
pages: false
posts:
title: true
date: true
path: true
text: false
raw: false
content: false
slug: false
updated: false
comments: false
link: false
permalink: false
excerpt: false
categories: false
tags: true