A small typo in code:

IF ((@len - @pos) < 0)

SET @offset = @len - @pos

ELSE

...

Index would help you with ordered search. Such bitmap search is random search of bit matrix. I'm not aware of any index type that would help you here. It always...

Partioning older data may be a good idea to prevent locking, if locking is indeed a possible issue. We looked into partioning tables a year or two back - but...

Could you explain the need for such bitmap and the way you search it?

It looks like like one of solutions for full text search I was evaluating many years...

It supports unicode by default, no updates needed.

If you have an existing database, you have to alter it to use nvarchar instead of varchar.

Ken's solution should work just fine, probably even better as it's unlikely to get an exception.

However, sometimes it's not desirable for a SP to handle transaction.

I'm interested in performance comparison...

It IMHO does.

First you try the insert and if you get a violation, you catch the exception and try update.

Simply revert the order, first insert and then update:

begin try

insert...

set @inserted=1;

end try;

begin catch

set @inserted=0;

end catch;

if @inserted=0

update...;

The topic does not say that it won't run with sqlserver 7, it's just too old to be listed.

Logic says it should run just fine with any 32bit version of...

Not a god requirement. How would the client distinguish them? Each part should have its serial number, so if the user does not enter (type, scan,...) each part, multiple lines...

First of all, there are at least two mistakes: both "fetch next..." are after the loop and I think you have to close and deallocate C1 in the outer loop.

Second,...

Does it really matter?

Yesterday I went to connect, logged in, browsed, but...

Matt Miller (12/18/2008)

---

Hmm...I'm not sure I understand the problem.

You CAN make certain T-SQL UDF functions show up as deterministic, assuming that they actually ARE deterministic and you make them schemabinding....

I tried at connect, but failed.

You're free do disagree. DOS was an OS at the time and command.com was its command shell. It abstracted access to some devices like printer, serial ports and disks. If...