Viewing 15 posts - 16,381 through 16,395 (of 18,926 total)
RAISERROR ( { msg_id | msg_str } { , severity , state }
June 22, 2005 at 7:44 am
Exactly why I used big red fonts on "THE ONLY WAY"
.
June 22, 2005 at 7:38 am
Yup... got bit by that one a few times before I realized how the optimizer works...
June 22, 2005 at 7:37 am
Simple one :
Declare @Rank as int
set @Rank = 81
Select O1.Name, count(*) as Rank from dbo.SysObjects O1 inner join dbo.SysObjects O2 ON O1.Name > O2.Name group by O1.Name having count(*)...
June 22, 2005 at 7:36 am
Give it a few months... got 2 weeks holidays coming soon (next month). Don't expect to see much of me here while I'm out
June 22, 2005 at 7:32 am
1 - I'm online 24/7 as I'm on broadband, and so are you as far as I can tell
2 - Ya maybe ![]()
3...
June 22, 2005 at 7:28 am
The short version is : the only way to garantee an order in a select is to use the order by clause, otherwise the data will be sent...
June 22, 2005 at 7:26 am
Or do you mean that you want different columns showed for different costumers, for the same select?
June 22, 2005 at 7:23 am
Doesn't mean it's the right thing to do... What if the trigger fails and needs to rollback everything (by design or by big problem). Just for the sake of...
June 22, 2005 at 7:21 am
Now that would be a first... a non technical superior guy that thinks he knows how things should work. Never seen that happen before
June 22, 2005 at 7:17 am
Don't forget to post the final script with test cases.
Looks like none of us could have done this in a year (except Noeld maybe).
June 22, 2005 at 7:12 am
I still can't make this thing work.. what's wrong with it?
if object_id ('FUNCTION_NAME') > 0
drop function FUNCTION_NAME
go
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MyTable]') and OBJECTPROPERTY(id, N'IsUserTable') =...
June 22, 2005 at 7:08 am
Viewing 15 posts - 16,381 through 16,395 (of 18,926 total)