With ZEROS:

SELECT FORMAT(12354,'000-00-0000') AS 'SSN'

Returns "000-01-2354"

The fact that Microsoft uses cursors in many sp and functions is only because that codes have been written in earlier version of SQL, starting from 4.2 in '90.

So, except...

Easy, I used a lot in the past, sql 4.2 to sql2000. But there isn't a real need of cursors.

😀

Easy, but batches are too long.

Query 3 and 4 differs only for the constant value.

That's true! Stack overflow!

It depends if one has enough time to read correctly the question of th day.

Good brain training!

Thanks!

😀

If in the query there are many complex expressions, I prefer to name aliases in parenthesis.

edwardwill (4/22/2015)

---

I copied and pasted the code into SQL Server 2014 and got this:

Msg 156, Level 15, State 1, Line 21

Incorrect syntax near the keyword 'OR'.

Msg 156, Level 15, State...

Good question!

I do not like "Filtered indexes", they are too much limited. I prefer indexed view.

karthik babu (4/20/2015)

---

Nice Question.. Index remains same irrespective of altering the table by adding a constraint and then by adding an unique clustered index.. I believe the index should have...

Hugo Kornelis (4/15/2015)

---

But note that supplying an offset only produces the expected results if you can be sure that there is exactly one row per month in the sales table....

Try to answer this one:

Table Array[/url]

A GLOBAL temporary table has 128 characters as the limit.

+1

Ahi, ahi, ahi, ahi, ahi, ahi!!!!!!!!!!

:w00t: