Use this tag for questions specific to the 2012 version of Microsoft's SQL Server.
I have following queries First one using inner join SELECT item_ID,item_Code,item_Name FROM [Pharmacy].[tblitemHdr] I …
sql performance query-optimization sql-server-2012In SQL Server 2012, Ctrl+R not working. Any other shortcuts for that. Any setting changes available or is there any …
sql-server-2012 ssmsBelow is my code that I'd like some help with. I am having to run it over 1,300,000 rows meaning it …
python sql-server sql-server-2012 bulkinsert pyodbcError: There are no Primary or Candidate Keys in the referenced table 'dbo.Customers' that match the referencing column list …
sql sql-server-2012I have the following DDL that I am using with SQL Server 2012: CREATE TABLE Subject ( [SubjectId] INT IDENTITY (1, 1) NOT NULL, […
sql sql-server sql-server-2012A database that was originally from SQL Server 2008, was restored into SQL Server 2012. A backup from SQL Server 2012 was made …
sql-server-2008-express sql-server-2012First off, I already know that Windows Firewall is blocking my connection -- I just don't know what to do …
sql sql-server windows sql-server-2012 windows-firewallI've written two stored procedure one with sp_executesql and other doesn't have sp_executesql both are executing properly same …
sql sql-server sql-server-2008 stored-procedures sql-server-2012Using SQLServer 2012 Enterprise, I don't see "Package Configuration Wizard" in SSIS when I do a right click in Control Flow …
ssis sql-server-2012We have an SSIS package which reads text files from a shared network directory. When I execute this package in …
sql-server ssis sql-server-2012