Kwisatz78 (3/7/2014)

---

Hi - yes I have found a property called Run64BitRunTime and set it to false however I still get the same error, which is was is leading me to...

pmadhavapeddi22 (3/7/2014)

---

Koen Verbeeck (3/7/2014)

---

Carlo Romagnano (3/7/2014)

---

Koen Verbeeck (3/7/2014)

---

Nice question, but I believe "not connected as sysadmin" is an equally correct answer though.

ps: no actual connections to a certain Grant who...

GilaMonster (3/7/2014)

---

Denny Cherry?

No performance comparisons there though.

I'd be interested to...

GilaMonster (3/7/2014)

---

Sushil Dwivedi (3/7/2014)

---

If you inserting value into table and your transaction got failed,identity assigned value to failed transaction as well

like

1,2,3,4...failed... than it will not start from 5.. it will...

Sushil Dwivedi (3/7/2014)

---

Are you testing me ...?

Limitation

1.Identity:- It's table dependent, you can apply identity on single table at a time. It is not a separate database object like Sequence.

Identity column...

Because of which reasons?

yuvipoy (3/6/2014)

---

Hi,

I have created a Int column with Identity

It has almost reached max size of Int.

i need to again start from the first

Few older records are deleted , the...

Carlo Romagnano (3/7/2014)

---

Koen Verbeeck (3/7/2014)

---

Nice question, but I believe "not connected as sysadmin" is an equally correct answer though.

ps: no actual connections to a certain Grant who is always ranting?...

This MSDN thread offers some solutions:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/3c2626d8-e835-4bba-b946-7d6796e9c617/sum-distinct?forum=sqlreportingservices

defiadores (2/28/2014)

---

Hi

I'm building a report on SSRS 2012 and I want to know if there is a way to repeat automatically a text box who is in the top of...

Nice question, but I believe "not connected as sysadmin" is an equally correct answer though.

ps: no actual connections to a certain Grant who is always ranting? 😎

COALESCE doesn't really do anything in this code, except converting NULL values to empty strings.

If COALESCE would be omitted from the code and there would be one NULL value for...

TomThomson (3/6/2014)

---

Koen Verbeeck (3/6/2014)

---

MysteryJimbo (3/6/2014)

---

Koen Verbeeck (3/5/2014)

Pfff, than you have never been in Belgium before 😀

If we wouldn't be having the most traffic jam congested cities in the world, you...

You're using SQL Server, right?

I'm pretty sure it exists:

LEN

Is that your exact query? Maybe there is a syntax error somewhere (such as a missing bracket).

Try the following:

SELECT LEN(meta_value) FROM heu_postmeta

I assume meta_value is a column and heu_postmeta is a table?