MS SQL
-
编辑 删除
JOIN 解析（INNER/LEFT/RIGHT/FULL/CROSS)
多表查询常涉及到到表连接的问题，主要涉及到内连接：INNER JOIN，外连接：LEFT JOIN(or LEFT OUTER JOIN),RIGHT JOIN(or RIGHT OUTER JOIN),FULL JOIN和交叉连接：CROSS JOIN。INNER JOIN也叫等值链接。内连接具有...
-
编辑 删除
SQL中N $ # @的作用
SQL中N $ # @的作用declare @sql nvarchar(4000) set @sql= N'select @TotalRecords=count(*) from ' + N'(' + @sqlFullPopulate + N') a ' EXEC sp_executesql @sql,N'@TotalRecords int output', @Total...
