C# source code, for those that prefer to compile for themselves:

using System;

using System.Collections;

using System.Collections.Generic;

using System.Data.SqlTypes;

using Microsoft.SqlServer.Server;

public partial class UserDefinedFunctions

{

[SqlFunction

...

A CLR aggregate wouldn't be the right choice because...

In the meantime, in case you are just looking for something simple to get you started:

DECLARE @temp INTEGER;

BEGIN TRANSACTION;

-- Find a new random number that does not already...

Where would be the fun in that? :laugh:

More seriously, it is a pet peeve of...

tasnim.siddiqi (7/14/2010)

---

Robust in the sense that it will be more reliable, I mean with just ascending ordered numbers the app_IDs will have a biased numbering form. I mean it is...

Can you explain that a little more? I...

You need to add a UNIQUE index or constraint to the RepairCategoryMaster table. The index or constraint should be on the CategoryID column only.

You should also read up on...

Tom.Thomson (7/13/2010)

---

Depending on the table and index structure, it's quite possible that most updates will hit only one or two of the indexes even if there are 20 or more...

Me too. My only rule of thumb is that there are no good rules of thumb.

And 'never' means 'try to avoid...'...

It was indeed - well remembered, Gianluca, and thanks!

I am pleased to...

An example (based on a test database of mine):

-- Just to make the point

USE master;

GO

IF EXISTS

(

...

Possibly the object id returned by OBJECT_ID happens to match a...

The ecstasy and the agony...

Thanks, Eugene. I'm glad someone else appreciates the subtleties.

Chris Morris-439714 (7/13/2010)

---

TWICE!...