Oh sorry, Something like this should work On Error Resume Next .... your db statement Select Case Err.Number Case..... Response.Redirect somewhere else End Select I bet there are lots of examples on ASP sites. Might be worth a try. Frank http://www.insidesql.de http://www.familienzirkus.de
2003-12-17
Still curious if seperating the settings statements in a seperate batch but on the same connection works. You could also try setting the default connection properties on the SQL server, but that will affect all connections that don't explicitly set those values.
2003-11-20
1 reads
The query optimizer makes its decision based on probability. And can therefore sometime make wrong decisions. To see if and how the hint can improve performance run your queries with STATISTICS IO STATISTICS TIME SHOWPLAN and compare the results. Don't get used to use query hint, because what might seem to be appropriate now, might […]
2003-11-19
2003-08-26
Thanks Frank and Dave. Sorry for the delay, I got pulled into something else. I was able to get to where I needed to go from your input. Here's what I came up with. CREATE procedure FTW @jobid int as declare @max int declare @maxouter int declare @ct int declare @gl int declare @sql nvarchar(4000) […]
2003-07-30
David, What function is the 'SELECT NULL' performing at the beginning of your statement? Thanks, Andrew
2003-07-29
1 reads
Just for interest sake from BOL 2000 : DECIMAL AND NUMERIC Precision Storage bytes 1 - 9 5 10-19 9 20-28 13 29-38 17 FLOAT AND REAL n is Precision Storage size 1-24 7 digits 4 bytes 25-53 15 digits 8 bytes
2003-07-28
1 reads
You get FLOAT as a result because of SQL Data Type Precedence (Look up "Data Type Precedence" in BOL). 29.99 is a valid decimal, and is a valid value that can be assigned to a FLOAT. But, because a FLOAT can store huge values, the trade-off is a loss of precision. Therefore you can assign […]
2003-07-28
1 reads
SQLBill, The convert function will truncate the time part and give the output in the format 'mm/dd/yy' (for 101). Then why wouldn't the query SELECT * FROM tblprojects WHERE insertedDate >= CONVERT(smalldatetime, '01/01/2003', 101) AND insertedDate <= CONVERT(smalldatetime, '04/30/2003',101) include '04/30/03'?? Cindy
2003-07-28
1 reads
Hard to say what is common. 2000 seems like a lot, but you should build what you need. Are you granting permissions to the user, or do you have them in a role? Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-07-25
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers