EXEC sp_trace_setfilter @TraceID, 11, 0, 0, @UserName;

@TraceID - Your trace number

11 - Column 11 is Login

0 - Comparison uses =

0 - Logical AND

@UserName - Your search string

CREATE TABLE #t (Valores MONEY);

GO

INSERT INTO #t SELECT 1.1;

GO 6

SELECT

SUM(ROUND(Valores, 0)) AS SumRound,

ROUND(SUM(Valores), 0) AS RoundSum

FROM

#t;

DROP TABLE #t;

You cannot specify a default setting but you can specify the encoding when you generate the results.

When you run your query the Save Results window has the option. It is...

Your question is version specific. From SQL Server 2012 the file will be created.

Toreador (7/23/2014)

---

Yes very good.

Now, how about some actual documentation (from Microsoft), rather than some forum and blog posts that don't actually address the question but just assume...

Toreador (7/23/2014)

---

That's why I don't like the question. It came down to a test of...

Simply to test ones knowledge of string comparison in a fun question, nothing more.

stephen.long.1 (7/23/2014)

---

Excellent question, Sean, thanks! I had to do some digging on the differences in the collation styles and the names of the first four databases (although I should have...

File Version 2011.110.5058.0

Product Version 11.0.5058.0

Size 438 KB

Well I...

Did you restart SQL Server?

SELECT ID, Code, Value1

FROM Table1 T1

WHERE ISNULL(T1.[Code], 'NULL') IN (@Param)

I did some investigation and found the problem, XPStar.dll contains a bug.

File Version 2014.120.2000.8

Product Version 12.0.2000.8

Size 409 KB

As a workaround, and the method I used to prove my findings, was...

What about restoring to a temporary database. Then once the restore is complete you can do a drop and rename.

USE [master];

GO

DECLARE

@DataFile NVARCHAR(255) = N'C:\MSSQL\MSSQL11.MSSQLSERVER\MSSQL\DATA\MyRestoreDemo.mdf',

@LogFile NVARCHAR(255) = N'C:\MSSQL\MSSQL11.MSSQLSERVER\MSSQL\DATA\MyRestoreDemo_log.ldf';

IF EXISTS(SELECT * FROM...

The question states that the script was run against a 2012 instance. Section 6...