Use this tag for questions specific to the 2014 version of Microsoft's SQL Server database engine.
I am trying to run an SSIS package through a stored procedure, but I am getting an Access is denied …
sql-server stored-procedures ssis impersonation sql-server-2014I upgraded our Windows Server from 2008 to 2012 and the SQL Server from 2008 to 2014. I have a process that uses the …
sql-server sql-server-2014 windows-server-2012 bcpI have a CTE and query this one ;With CTE_Table as (SELECT ...) Select * from CTE_Table Now I try …
sql tsql common-table-expression sql-server-2014 table-variableSQL SERVER 2014 SSIS has been released,we have already got lot of facilities in SQL SERVER 2012 SSIS.Can anybody compare …
ssis informatica-powercenter sql-server-2012-datatools sql-server-2014This might be a very basic question but I just came over it while writing a query. Why can't SQL …
sql-server tsql sql-server-2014I am using MVC 4 and entity framework 5.0, i have a database and this database contains 6 tables named as following. tblUser_…
c# asp.net-mvc-4 entity-framework-5 sql-server-2014 sql-server-2014-expressCan any one please tell me where to use CTE, temp table and table variable? I read about their differences …
common-table-expression sql-server-2014 temp-tables table-variableI have a stored proc that creates a temp table. It is only needed for the scope of this stored …
sql-server temp-tables sql-server-2014I am creating a temporary table on-the-fly using Select * Into #temp from SomeChangingSource in a stored procedure. I need to …
sql sql-server tsql sql-server-2014I have updated SQL Server Management Studio to the latest version at time of writing - 12.0.4432.0 - this is SP1 …
sql-server azure azure-sql-database sql-server-2014 ssms-2014