Here is how it works: 1. Get XML element string with FOR XML Adding FOR XML PATH to the end of a query allows you to output the results of the query as XML elements, with the element name contained in the PATH argument. For example, if we were to run the following statement: By … Read more
Single quotes are escaped by doubling them up, just as you’ve shown us in your example. The following SQL illustrates this functionality. I tested it on SQL Server 2008: Results
The CASE statement is the closest to IF in SQL and is supported on all versions of SQL Server. You only need to use the CAST operator if you want the result as a Boolean value. If you are happy with an int, this works: CASE statements can be embedded in other CASE statements and even included in aggregates. SQL Server Denali (SQL … Read more
From SQL Server 2016 you can just use On previous versions you can use You could also consider truncating the table instead rather than dropping and recreating.
To rename a table in SQL Server, use the sp_rename command:
I was struggling with that until i found this… http://blog.sqlauthority.com/2009/10/01/sql-server-sql-server-management-studio-and-client-statistics/ Also, if you open the Properties window you may find some magical “Connection elapsed time” that may give you some execution time… Hope it helps…
The GROUP BY clause forms rows for each unique combinaton of the columns you nominate in that clause. If you want to show a sum for each month, then only include s.month in the group by clause: e.g If you include reseller details in the select clause also include them in the group by clause … Read more
It is a batch terminator, you can however change it to whatever you want
May be this will help you.
If you want to do it this way then this is the syntax you’re after; You don’t strictly need the BEGIN..END statements but it’s probably best to get into that habit from the beginning.