Actually, that table is already created for you by the nice (shoosh you there! :-)) guys from MS:

declare @maxordinal int

select @maxordinal = column_id - 1

from sys.columns

WHERE OBJECT_ID = OBJECT_ID('mytable')

AND name...

CELKO (9/13/2016)

---

(start_date, end_date) pairs the idiom has been that a null in the end_date means "eternity"in that context

My experience has been that it means one of two possible outcomes:

1) Eternity...

Gregory Hart (9/13/2016)

---

My experience has been that it means one of two possible outcomes:

1)...

The Dixie Flatline (9/10/2016)

---

I'll admit the loop is going to run a long time, but you don't have to worry about missing a constraint, nonclustered index, foreign key, etc. ...

sql-lover (9/8/2016)

---

Is there any trace flag or way to avoid successful backups being logged into msdb system databases? Please keep in mind I am talking about msdb, not SQL error...

FORMAT or CONVERT or STR - they all return varchar data type.

On an attempt to save their outcome into int column it will be converted back to int and all...

For a start.

You do not need to run the same query twice:

SELECT @Count=count(*) from dbo.PropertyAssets pa

inner join Scenarios sce on sce.id = pa.scenarioId

inner join Portfolios por on por.id...

It must be "For lousy developers of...

mister.magoo (9/8/2016)

---

But, if you have to add division by zero handling to overcome this problem, why not have a standardised, optional, internal way of returning some kind of value from...

mister.magoo (9/8/2016)

---

Sergiy (9/7/2016)

---

mister.magoo (9/7/2016)

---

If I need to handle things differently when the value is zero (I don't want to return NULL), I end up with a CASE statement such as...

mister.magoo (9/7/2016)

---

If I need to handle things differently when the value is zero (I don't want to return NULL), I end up with a CASE statement such as

CASE cost...

Same use as for any other type of errors...

tshad (9/7/2016)

---

I have these columns on all my tables. It also helps in debugging. I can quickly find out when the record was last touched without having to...

Gregory Hart (9/7/2016)

---

I guess my point with this matter is that in 22+ years of database development, I personally have never had a need for returning an error message instead...

I wish...