I got wrong answer. I assume that all these can be converted int only but newid will throw error if we convert into integer.

Nice question. Confused with first two answers.

yes. Is not working. If any body knows samples . please let me know.

Indexed view

Very Interesting question

Excellent Question

Easy one

Carlo Romagnano (6/19/2013)

---

Richard Warr (6/19/2013)

---

I ran the code and got:

Msg 242, Level 16, State 3, Line 7

The conversion of a varchar data type to a datetime data type resulted in...

Easy question and more over its fun. I also had done this in many times.

Easy one for the day

Multiple Active Result Sets (MARS) set to true

http://reddy25.blogspot.in/2013/05/how-to-send-database-mail-using-sql.html

You try like this

declare @variable varchar(max)='water call came at 10.00 PM to pay the bill'

select substring(@variable,PATINDEX('%[0-9]%',@variable),8)

GO

declare @variable varchar(max)='water 4.45 PM at to pay the bill'

select substring(@variable,PATINDEX('%[0-9]%',@variable),8)

go

declare @variable varchar(max)='water call 24/12/35...

Easy one

Nice one .