A different option to check if the code compiles:

declare @myint tinyint= 5;

SELECT 1;

SELECT s1.c1, s2.c1

FROM (values (s2.c1+2)) s1(c1)

CROSS APPLY

(values (@myint),(@myint+1),(@myint+2)) s2(c1);

A run-time error would show the result from SELECT...

Eirikur Eiriksson (1/13/2016)

---

cycle90210 (1/13/2016)

---

This is definitely possible and the table I do load it in to is a "staging" table of sorts (with interface status columns, date loaded, filename loaded,...

Eric M Russell (1/13/2016)

---

There is the Microsoft certification exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server. It covers not just SSIS but also: dimensional data modeling, ETL, Data...

decreale (1/12/2016)

---

You mentioned change the connection properties? This stored procedure is being used in SSRS. I wanted to create one report and have the user pass the database parameter to...

Are you going to compare indexes and constraints as well? Do you care about differences in names for system named objects?

What about implementing some monitoring using DDL triggers?

Not really, especially when you have some sort of intellisense activated.

Comparing identical functionality:

--121 characters

SELECT ROUTINE_SCHEMA, ROUTINE_NAME, ROUTINE_DEFINITION

FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_TYPE = 'PROCEDURE'

--128...

It's funny how you're trying to call a stored procedure using dynamic sql. You're basically being redundant making nested calls. I'm assuming this is to call the same procedure in...

Gray

You've received an explanation on why your code isn't behaving as you expected.

Maybe now you could explain what you're trying to do and get the way to do it correctly.

Unless...

It seems that Aaron Ramsey...

I would actually change the variable definition.

DECLARE

@max-2 AS NVARCHAR(MAX) = ''

, @var AS NVARCHAR(MAX) = 'ABCabc123';

SELECT

@max-2 = REPLICATE(@Var, 445);

SELECT

CASE...

Phil Parkin (1/8/2016)

---

Luis Cazares (1/8/2016)

---

You mean like...

You mean like Phil Parkin, Jeff Moden...

Create a step for each command or create a batch file to run both.

If you send both in a single command, it will ignore the second and all the others.

Wild...

Do you get an error?

Do you run them one by one? Are they in a batch file?