I googled "Msg 2714" and answered correctly.

Another solution is adding a xml column to the PlayList table and add the execution order there. So, it's just ONE update on ONE column.

natalie.ignatieva (12/21/2014)

---

This is a great solution, linked list idea adds complexity though. You can easily change the way you rank your songs and make Position column as float. Then you...

I disagree! JOINS are different than IN or EXISTS in the WHERE clause.

JOINS multiply the number of...

Extremely easy!

The answer is in the title!

😀

Bello!

Extremely easy!

Thanks!

ROWCOUNT_BIG() differs from @@rowcount only from the type.

So, ROWCOUNT_BIG() is the correct answer. All other functions may be followed by the OVER clause.

One solution may be this one:

use tempdb

execute (

'

use AnotherDB

declare @a as a

insert @a values(1),(2),(3)

exec z @a

')

or using sp_executesql.

Sql2005 never installed!

Koen Verbeeck (10/29/2014)

---

Louis Hillebrand (10/29/2014)

---

With DATALENGTH you can also use a space as the separator,...

+1

Very interesting!

Thx!

happycat59 (10/14/2014)

---

I get error

Msg 156, Level 15, State 1, Procedure my_sp, Line 2

Incorrect syntax near the keyword 'FROM'.

because "Column" is a reserved keyword and needs to be delimited if you...

rabih_karam (9/30/2014)

---

I run the query and I got the below result :

DATABASE Name : Master

-----------------------------

0.713591993212924

0.713591993212924

0.713591993212924

0.713647892126698

0.713647892126698

0.713647892126698

0.713647892126698

0.713722424011731

0.713722424011731

0.713722424011731

0.713722424011731

0.713722424011731

0.713722424011731

0.713722424011731

0.713852854810538

0.713871487781797

0.713871487781797

0.713908753724313

0.713908753724313

0.713908753724313

and if i run it on other DB I ll get the below result

0.713591993212924

0.713591993212924

0.713591993212924

0.713591993212924

0.713591993212924

0.713591993212924

0.713591993212924

0.713591993212924

0.713591993212924

0.713591993212924

0.713591993212924

0.713591993212924

0.713591993212924

0.713591993212924

0.713852854810538

0.713852854810538

0.713852854810538

0.713852854810538

0.713852854810538

0.713852854810538

so in...