Yes, very good to know. Thanks Stefan.

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...