Question : I need to UNION data from tables with the same name in multiple databases. All databases have the […]
Tag: t-sql
T-SQL Naming Standard
Question : Is there a recommended (official or not) style from Microsoft regarding naming and casing in T-SQL? If there […]
Microsoft SQL Joins and Where Clause
Question : I am sure a very simple question for people out there but my brain has shutdown. I have […]
Database Mirror – Host can not be reached or does not exist
Question : I tried mirroring database with GUI and T-SQL, but I had problems in both cases. Here is some […]
Has dacpac/sqlpackage feature awareness
Question : We are deploying our database model (vs db project) to several customers via a setup routine. Internally a […]
String manipulation tools to populate a variable for two “functions”
Question : Versions: SQL Server 2008 R2 – 2014 I’m using a server audit to find changes to logins on […]
Split two delimited strings in same order without function
Question : I am trying to split two columns with delimited strings into rows. The positions of the values in […]
Out Param With OpenQuery
Question : I am trying to output a parameter from openquery, but my syntax produces this error Msg 137, Level […]
Deny DDL_ADMIN permissions to a role on [dbo] schema
Question : I have several database schemas like, [ext],[stag],etc and of course the built in [dbo] schema, and also have […]
SQL Query :Is it possible to count / group based on date with a sum over the group
Question : I have the following question: To determine the progress of a production process the following records are stored: […]