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

Triggers on tables execute only if at least ONE row is affected. So, explanation is wrong.

WOW64, I learned something new!

😀

From BOL:

MERGE

[ TOP ( expression ) [ PERCENT ] ]

[ INTO ] <target_table> [ WITH ( <merge_hint> ) ] [...

That's true!

😀

+1

What do you mean with "we can use print and exec commands in single query"?

Nice question!

Thanks!

😀

I don't like qotd too long.

But, BOL states that with SERIALIZABLE isolation level:

Other transactions cannot insert new rows with key values that would fall in the range of keys read...

sp_rename leave unaltered the definition, (see sys.syscomments)

create procedure My_proc

as

select 1 as a

go

SELECT * FROM sys.syscomments

WHERE object_name(id) = 'My_proc'

go

exec sp_rename My_proc,Myproc

SELECT * FROM sys.syscomments

WHERE object_name(id) = 'Myproc'

After the rename the definition...

+1

Wonderfull!!!

It, also, works with subquery:

SELECT * FROM (

SELECT MAX(object_id) AS ID,MAX(name) AS NAME FROM sys.objects

) AS o

But in this case it states a wrong type for column NAME(int,null)

I noticed it for columns, tables and functions, but I happily surprised for star!

Good!

😀