I use DBArtisan myself but it is rather expensive. I believe the less expensive version is RapidSQL but I think it is sold only for specific databases as opposed...

It's rather interesting that this topic has come up. I had adjusted an old proc the other day and put it through the release process here. The DBAs...

Your Update statement is fine. Don't bother with doing an IN as it will have no effect.

There has to be other code being executed for you to be getting...

Just thought I'd point out that if you truly have reason codes = '' you could reduce your WHERE clause as follows:

WHERE IsNull(REASON_CODE_5, '') = ''

I believe you could simply do something like

IF NOT UPDATE(col_one) RETURN

--if one of the rows was updated then use something like...

SELECT *

FROM inserted i, deleted d

WHERE i.id = d.id

AND IsNull(i.col_one,...

I do all my stored procedure calling right in the ASP page. Below would be an example of VBS portion of an ASP page doing such a call:

Set oConn...

Until recently I haven't had to deal with databases set with cascading triggers turned on. Several years ago we did look into turning this on and decided that the...

Did you look at BOL? There are a couple of items to check there.

1) Under "Managing DTS Package Programs" there is a section at the bottom titled "Saving...

Gee, I wanted to hear what people had to say about VARCHAR and CHAR.

As for SQL, when I use it with MS SQL Server I do say "sequel". If...

Ali,

If you are doing a GROUP BY you can drop the DISTINCT. This may speed it up a bit as well.

Jeff

I've used FileMakerPro on Mac & PC, Oracle on PC and Unix, Sybase, Access, SQL Server, 4th Dimension (more of an integrated gui/db). I've always wanted to look at...

Since you don't want to have to limit access via stored procs you could try this approach (my assumption is that you only have one owner for a record):

1) ...

Couple of comments with the assumption that you aren't worried by users with SysAdmin. If there is someone you can't trust with that level of access then your problems...

Don't know why I didn't think to shorten this up even more. Here ya go

SET NOCOUNT ON

DECLARE @i TINYINT, @Tmp VARCHAR(1000)

-- Fill in your own select

SELECT...

Here's another approach:

Set @i=1

While @i<=DataLength(@Tmp)

Begin

If Not (SubString(@Tmp,@i,1) LIKE '[A-Z]' Or

SubString(@Tmp,@i,1) LIKE '[a-z]' Or

SubString(@Tmp,@i,1) LIKE '[0-9]' Or

SubString(@Tmp,@i,1)=' ')

Select @i 'Position' , SubString(@Tmp,@i,1) 'char value',Ascii(SubString(@Tmp,@i,1)) 'Ascii value'

Set @i=@i+1

End