This happens when you try to edit the top 200 rows of a SQL Server 2012 database using the 2008 R2 SQL Server Management Studio.
Upgrade SQL Server Management Studio to 2012 or edit the rows using a SQL query.


**C++11**
&gt; 14.8.2 - **Template Argument Deduction** - `[temp.deduct]`&lt;br /&gt;
&gt; &gt; &lt;sup&gt;7&lt;/sup&gt; The substitution occurs in all types and expressions that are used in the function type and in template parameter declarations. The expressions include not only constant expressions such as those that appear in array bounds or as nontype template arguments but also general expressions (ie. non-constant expressions) inside `sizeof`, `decltype`, and other contexts that allow non-constant expressions.

------

**C++14**
&gt; 14.8.2 - **Template Argument Deduction** - `[temp.deduct]`&lt;br /&gt;
&gt; &gt; &lt;sup&gt;7&lt;/sup&gt; The substitution occurs in all types and expressions that are used in the function type and in template parameter declarations. The expressions include not only constant expressions such as those that appear in array bounds or as nontype template arguments but also general expressions (ie. non-constant expressions) inside `sizeof`, `decltype`, and other contexts that allow non-constant expressions. **The substitution proceeds in lexical order and stops when a condition that causes deduction to fail is encountered**.

------

------

The added sentence explicitly states the order of substitution when dealing with template parameters in C++14.

The order of substitution is something that most often isn&#39;t given a lot of attention. I have yet to find a single paper on why this matters. Maybe this is because C++1y hasn&#39;t been fully standardized yet, but I&#39;m assuming such a change must have been introduced for a reason. 

**The question:**

 * Why, and when, does the order of template argument substitution matter?


Why does the order of template argument substitution matter?

when I use this syntax it creates a series rather than adding a column to my new dataframe `sum`.


My code: 

    sum = data[&#39;variance&#39;] = data.budget + data.actual

My dataframe `data` currently has everything except the `budget - actual` column. How do I create a `variance` column?

		cluster  date                  budget  actual budget - actual
	0 	a 	     2014-01-01  00:00:00  11000   10000       1000
	1 	a 	     2014-02-01  00:00:00  1200    1000
	2 	a 	     2014-03-01  00:00:00  200 	   100
	3 	b 	     2014-04-01  00:00:00  200 	   300
	4 	b 	     2014-05-01  00:00:00  400 	   450
	5 	c 	     2014-06-01  00:00:00  700 	   1000
	6 	c 	     2014-07-01  00:00:00  1200    1000
	7 	c 	     2014-08-01  00:00:00  200 	   100
	8 	c 	     2014-09-01  00:00:00  200 	   300

summing two columns in a pandas dataframe

When I try to edit table data in SQL Server Management Studio 2008 R2 (right click in table object, Edit Top 200 rows) I receive this error: &quot;Invalid prefix or suffix characters. (MS Visual Database Tools)&quot;. 

Error Invalid prefix or suffix characters in SQL Server Management Studio

<p>When I try to edit table data in SQL Server Management Studio 2008 R2 (right click in table object, Edit Top 200 rows) I receive this error: "Invalid prefix or suffix characters. (MS Visual Database Tools)".</p>


With EF6 you have a new transaction which can be used like:

    using (var context = new PostEntityContainer())
            {
                using (var dbcxtransaction = context.Database.BeginTransaction())
                {
                    try
                    {
                        PostInformation NewPost = new PostInformation()
                        {
                            PostId = 101,
                            Content = &quot;This is my first Post related to Entity Model&quot;,
                            Title = &quot;Transaction in EF 6 beta&quot;
                        };
                        context.Post_Details.Add(NewPost);
                        context.SaveChanges();
                        PostAdditionalInformation PostInformation = new PostAdditionalInformation()
                        {
                            PostId = (101),
                            PostName = &quot;Working With Transaction in Entity Model 6 Beta Version&quot;
                        };

                        context.PostAddtional_Details.Add(PostInformation);
                        context.SaveChanges();

                        dbcxtransaction.Commit();
                    }
                    catch
                    {
                        dbcxtransaction.Rollback();
                    }
                }
            }

Is rollback actually needed when things go sideways? I&#39;m curious because the Commit description says: &quot;Commits the underlying store transaction.&quot;

Whereas the Rollback description says: &quot;Rolls back the underlying store transaction.&quot;

This makes me curious, because it looks to me that if Commit isn&#39;t called, the previously executed commands will not be stored (which seems logical to me). But if that is the case, what would the reason be to call the Rollback function? In EF5 I used TransactionScope which didn&#39;t have a Rollback function (only a Complete) which seemed logical to me. Due to MS DTC reasons I cannot use the TransactionScope anymore, but I also cannot use a try catch like the example above (i.e., I only need the Commit).



Entity Framework 6 transaction rollback

I have a table TEST with a `DATETIME` field, like this:

```lang-none
ID NAME DATE
1 TESTING 2014-03-19 20:05:20.000
```

What I need a query returning this row and every row with date 03/19/2014, no matter what the time is. I tried using

```lang-sql
select * from test where date = &#39;03/19/2014&#39;;
```

But it returns no rows. The only way to make it work that I found is to also provide the time portion of the date:

```lang-sql
select * from test where date = &#39;03/19/2014 20:03:02.000&#39;;
```

How to query DATETIME field using only date in Microsoft SQL Server?

I am trying to simulate a deadlock on SQL Server.

    _|worker_id|salary|
    1|1        |100   |
    2|2        |300   |

Transaction 1 completed in 5 seconds.

    /* TRANSACTION 1*/
    Use dbmcw;

    DECLARE @sal1 INT, @sal2 int;

    BEGIN TRAN;

    SELECT @sal1 = salary
    FROM dbo.deadlock_demonstration WITH(UPDLOCK) 
    WHERE worker_id = 1;

    WAITFOR DELAY &#39;00:00:05.000&#39;;

    SELECT @sal2 = salary
    FROM dbo.deadlock_demonstration WITH(UPDLOCK)
    WHERE worker_id = 2;

    COMMIT TRAN;

Transaction 2 finished in 3 seconds.

    /* TRANSACTION 2*/
    Use dbmcw;

    DECLARE @sal1 INT, @sal2 int;

    BEGIN TRAN;

    SELECT @sal2 = salary
    FROM dbo.deadlock_demonstration WITH(UPDLOCK)
    WHERE worker_id = 2;

    SELECT @sal1 = salary
    FROM dbo.deadlock_demonstration WITH(UPDLOCK)
    WHERE worker_id = 1;

    COMMIT TRAN;

SQL Server is not giving any error. Deadlock did not occur. What should I change in order to simulate a deadlock?

How to simulate DEADLOCK on SQL Server?

I recently came to know about the availability of `IIF` function in SQL Server 2012. I always use nested `CASE` in my queries. I want to know the exact purpose of the `IIF` statement and when should we prefer using `IIF` over `CASE` Statement in the query.
I mostly use nested `CASE` in my queries.

Thanks for all the inputs.

SQL Server IIF vs CASE

I&#39;m wondering if it&#39;s possible to setup SQL Server to have multiple rows of tabs for files / queries. 

I have a lot of queries I want to switch between, and could move them to different horizontal groups, but I think two rows would be much easier to navigate than that pin on the left that drops down the big list of open queries.

Visual Studio kind of supports this if you pin enough code windows to fill up the top bar. 

Is there something similar in SQL Server?

Edit:

I&#39;m trying to achieve something like this (screenshot from Visual Studio)

![Multiple Tabs][1]

While SQL Server is more like this

![Management Studio][2]

  [1]: http://i.stack.imgur.com/Lcsh4.png
  [2]: http://i.stack.imgur.com/dLZeQ.png

Can I have multiple rows of tabs in SQL Server Management Studio

I have a very large SQL Server 2008 R2 database (1.5TB) and will be copying some data from column to column within the same table. I&#39;ve been told that the schema has a large number of indexes and was wondering if there is a default query or script that will rebuild all the indexes. Have also been advised to update the statistics at the same time?

Each of the 30 tables has one clustered index and 13x non-clustered indexes 

Thanks.

Rebuild all indexes in a Database

I am having error while connecting to SQL Server:

[![enter image description here][1]][1]


Details in Stack Trace are:

    ===================================
    
    Cannot connect to ServerName.
    
    ===================================
    
    A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (.Net SqlClient Data Provider)
    
    ------------------------------
    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;EvtSrc=MSSQLServer&amp;EvtID=233&amp;LinkId=20476
    
    ------------------------------
    Server Name: ServerName
    Error Number: 233
    Severity: 20
    State: 0
    
    
    ------------------------------
    Program Location:
    
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
       at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
       at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
       at System.Data.SqlClient.TdsParserStateObject.ReadByte()
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
       at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject, Boolean withFailover)
       at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
       at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
       at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection(UIConnectionInfo ci, IServerType server)
       at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

  [1]: http://i.stack.imgur.com/FOQTX.png


**NOTE** **I have tried** 

 - closing, reopening Sql server Management Studio.

 - closing , reopen VS &amp; rebuild Solution

 - killed worker process accessing database.

 - login credentials are correct.
 
 - able to ping server to make sure its not down.



A connection was successfully established with the server, but then an error occurred during the login process. (Error Number: 233)

Does the Poor Mans T-SQL formatting add-in for Management Studio 2012 work in Management Studio 2014?

In SSMS 2012, if I go to tools, it showed up in the list. In SSMS 2014, it doesn&#39;t.

I tried to run the installer again, and it gave me options to repair or uninstall. I had the formatter installed prior to installing 2014.

EDIT: [The tool is available here.][1]


  [1]: http://architectshack.com/PoorMansTSqlFormatter.ashx

Does the Poor Mans T-SQL formatting add-in for Management Studio 2012 work in Management Studio 2014?

I&#39;m trying to add a table to my newly created database through SQL Server Management Studio.
However I get the error:

&gt; *the backend version is not supported to design database diagrams or tables*

To see my currently installed versions I clicked about in SSMS and this is what came up:

![enter image description here][1]


What&#39;s wrong here?


  [1]: http://i.stack.imgur.com/2rj6M.png

The backend version is not supported to design database diagrams or tables

I am getting an error, While I am trying to connect (LocalDB)\MSSQLLocalDB through SQL Server management studio. I also tried to login with default database as master the error is same.

[![enter image description here][1]][1]
Here is the Server details.
[![enter image description here][2]][2]


  [1]: http://i.stack.imgur.com/Q3Gyb.png
  [2]: http://i.stack.imgur.com/dE9Aw.png

Cannot connect to (LocalDB)\MSSQLLocalDB -&gt; Login failed for user &#39;User-PC\User&#39;

I have downloaded the SQL Server Management Studio (SSMS) 2016 to recover a huge .bak file which is an old backup of a database. But first of all I need to connect to a DB Server.

After install, I execute SSMS and it asks me to connect to a DB Server. I don&#39;t have any and I saw that it is possible to create a &quot;local&quot; db by typing only a dot &#39;.&#39; for Server Name and use Windows authentication. 

It is not working; how to do it?

Content Type	Original Author	Original Content on Stackoverflow
Question	Renzo Ciot	View Question on Stackoverflow
Solution 1 - Sql Server	Renzo Ciot	View Answer on Stackoverflow

Error Invalid prefix or suffix characters in SQL Server Management Studio

Sql Server Problem Overview

Sql Server Solutions

Solution 1 - Sql Server

summing two columns in a pandas dataframe

Why does the order of template argument substitution matter?

Attributions