interesting request, here's how i would handle it:

it's probably safe to assume that if it was installed from an MSDN media, all the version would have used the same installation...

i like to convert the first two octets to a decimal for comparison, ie 9.0/10.0/10.5/11.0/12.0/13.0 etc

SELECT SERVERPROPERTY('ProductVersion'),

CONVERT(decimal(5,2), Parsename(CONVERT(VARCHAR(30), Serverproperty('productversion')), 4)

...

if you are restoring from another server, any changes you made will be lost, so you would need to either:

1. grant that read access in the original server/database before backup...

don't change data types.

if you are using dates, use DATEADD and DATEDIFF functions. don't convert them to strings, or any other data type.

something like this returns the minutes in difference(if...

what is someone is updating the value from blank/null to a desired value, instead of just changing it? is it ok to update from blank to good value? or prevent...

creating a user does not give then any access to the objects within the database; they are added to thePUBLIC role in the database, which typically doesn't give them anything.

if...

if you save the xml to a file, with no other changes, save it to the extension *.xdl, ie Deadlocks.xdl.

when you double click that, that extension will open up the...

I'm going to agree with Orlando's lat post that this is the expected behavior.

{somedata} + {row delimiter}, which in this case is CrLf, puts the cursor on the...

Jeff Moden (3/13/2016)

---

davros30 (3/13/2016)

---

SQLC is another good tool that will meet your needs. RedGate is also a very good tool but it is expensive.

SQLC is very affordable. You...

mw112009 (3/11/2016)

---

Nice syntax...

I was just playing with the SQl and ran the following

exec sp_MSforeachdb 'SELECT top 1 ''?'' As DatabaseName FROM [?].sys.tables '

However it only listed about...

this will work:

if the database name shows up, it has a table with that name:

exec sp_MSforeachdb 'SELECT ''?'' As DatabaseName FROM [?].sys.tables WHERE name = ''ClmRejRept'' '

Previous place i worked at had a code base like that, created by an offshore team.

There was only a project manager, and no onsite developer reviewing the code produced, so...

I never had to do this, but i found this interesting!

i found a good article on SQLTips called "Transferring data from SAS to SQL Server and back":

https://www.mssqltips.com/sqlservertip/2659/transferring-data-from-sas-to-sql-server-and-back/

so if you don't...

a calculated column cannot have an if statement; you canuse a CASE though

something like this is what i think you wnat:

SET QUOTED_IDENTIFIER ON

ALTER TABLE Schedule ADD

[SubmitDate] AS

CASE

WHEN REVIEWDueStatus=10 AND...

I think it's a going to take a good rewrite and step back from trying to modify the existing, and just join these three tables together, and trim off any...