Viewing 15 posts - 751 through 765 (of 1,086 total)
This is one possible solution; I'm sure there is probably a better select statement.
I have assumed you have already pumped your Excel spreadsheet into SQL Server and called the...
June 23, 2005 at 11:26 am
EricP37 says:
Now this one works great and generates the following correct messages....because the denominator = zero.
Server: Msg 8134, Level 16, State 1, Line 1
Divide by zero error...
June 22, 2005 at 4:42 pm
How many choices are there?
June 22, 2005 at 2:55 pm
Have you tried running it? What error do you get?
It does not look very efficient, but it should run.
June 22, 2005 at 10:35 am
So many of us seemed to have been fascinated by this, I thought it might be good to repost the entire code. I have yet to play with this, but...
June 21, 2005 at 2:47 pm
BOL - WAITFOR { DELAY 'time' | TIME 'time' }
Not sure if that will work with a Trigger... (Remi has a very good point, you may want to look...
June 21, 2005 at 2:43 pm
Agreed! (And Remi you are nothing like that...). It is too bad, especially for new members who encounter that...
June 20, 2005 at 3:40 pm
You're not at all that rude - I was just needling you...
June 20, 2005 at 1:18 pm
I agree with Celco... er, I mean Remi.
You may want to consider making this history table in a seperate database depending upon...
June 20, 2005 at 10:39 am
If I am reading BOL correctly, then I would want to use the following:
SELECT o.name
FROM sysobjects o
WHERE o.type = 'P'
AND permissions(o.id) & 32 <>...
June 20, 2005 at 8:05 am
Thank you, Remi! Must admit, it took me a bit of time to recognize how to use with and without 'Domain Users'. It is very good for specifying my own Roles...
June 17, 2005 at 1:12 pm
I stated that very poorly. I meant, does anyone know how to find the privileges for Stored Procedures.... sorry.
June 17, 2005 at 9:32 am
Beautiful! I was messing with this and going a wholely different route.
June 16, 2005 at 11:48 am
Viewing 15 posts - 751 through 765 (of 1,086 total)