Chad Crawford (10/19/2012)

---

Stefan Krzywicki (10/19/2012)

---

WayneS (10/19/2012)

---

Brandie Tarvin (10/18/2012)

---

Stuart Davies (10/18/2012)

---

Stefan Krzywicki (10/17/2012)

---

Brandie Tarvin (10/17/2012)

---

It's a disgrace, a disgrace I say. Why do you want to know what I know...

Sean Lange (10/19/2012)

---

Is it just me or is the entire SSC site slow today? For me I can barely navigate anywhere. Each click is taking a couple minutes. No other...

Are you sure next_run_schedule is correct even if another schedule matures when the job is already running having been started by a different schedule? The job won't start when...

Dave62 (10/19/2012)

---

It's not possible to pick 6 true statements for all...

patrickmcginnis59 (10/19/2012)

---

For instance, while I'm sure knowing the table variable stuff would be good to know, if SQL rejected a construct I offered, I'd pretty much hit books on line...

Hugo Kornelis (10/19/2012)

---

Very good question overall.

Only (minor) issue - picking 6 out of 17 answer options is a task that appears daunting at first sight. The answer options were luckily...

ako58 (10/19/2012)

---

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT...

Hugo Kornelis (10/18/2012)

---

(It's a good thing I remember to copy my reply to the clipboard before posting it - I ran once more in the issue [probably timeout related, I...

mbova407 (10/18/2012)

---

The example was taken directly from Books Online (August 2008)

When the expression exceeds the specified length, the string returns ** for the specified length.

Copy Code

SELECT STR(123.45,...

@Cassie (10/18/2012)

---

L' Eomot Inversé (10/18/2012)

---

Good question

But the explanation is very poor, inaccurate. For example the length of the expression "123.45" is 6, but str(123.45,4,2) is not '**' as suggested...

Good question

But the explanation is very poor, inaccurate. For example the length of the expression "123.45" is 6, but str(123.45,4,2) is not '**' as suggested by the explanation but...

I did overlook the quotes on the quoted 'NULL', so I got it wrong.

Nice question.

Probably the worst explanation I've ever seen...

All these methods using [A-Za-z0-9] recognise 139 characters (with the Latin1_General_ci_as collation).

Now personally I think that's right (although it's a rather complicated pattern to use for the job), but...

Eugene Elutin (10/16/2012)

---

vivekkumar341 (10/16/2012)

---

Hi,

i had gone through your example its look wrong.

please find the detail.

declare @int1 varchar(100) = '100000000',

@int2 varchar(100) = '984541',

@int3 varchar(100)

your suggestion was mentioned below:

set @int3...

Are you trying to add two columns to one table and one table to another table?

If so you wnat code like

ALTER Table1 add ColA type1 columnConstraints1, ColB type2 columnConstraints2;

ALTER...