使用该查询，得出iFavoriteID,iFavUserType ,cUser,iArticleID,dFavoriteTime五个字段的值:

SELECT iFavoriteID,
CASE WHEN iFavUserType = 0 THEN '新闻管理员'
WHEN iFavUserType = 1 THEN '商家'
WHEN iFavUserType = 2 THEN '会员'
WHEN iFavUserType = 3 THEN '未注册'
WHEN iFavUserType = 4 then '匿名'
END
AS iFavUserType, cUser, iArticleID,
CONVERT(nvarchar(100), dFavoriteTime, 111) AS dFavoriteTime FROM dig_favorite

SQL语法如下：

INSERT INTO[目标表名](field1, field2) SELECT field1, field2 FROM[原表名] WHERE 条件

示例：

INSERT INTO dig_favorite(cUser,iArticleID)
SELECT cUser, iArticleID FROM dig_article
where cUser='tongxing'