plevantis

Avoid Divide by Zero Errors

A simple User Function which will guarantee always to return a value from a division without any errorsExample : GPDivNErr(@Val1 float, @Val2 float)

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-06-10 (first published: 2005-05-29)

469 reads

Every organization I talk to has the same problem dressed up in different clothes....

I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...

Ten years (and a couple jobs) ago, I wrote about naming default constraints to...

Comments posted to this topic are about the item The day-to-day pressures of a...

Comments posted to this topic are about the item The Problem Isn't Always Your...

Comments posted to this topic are about the item Identity Defaults

What happens when I run this code?

CREATE TABLE dbo.IdentityTest
(
     id int IDENTITY(10) PRIMARY KEY,
     somevalue VARCHAR(20)
)
GO