A little bit late!

Set NoCount On

Create Table Tmp1(Col1 Varchar(15),Col2 Varchar(15))

Go

Insert Tmp1

Select 'sex = ''M''','age > 50'

Insert Tmp1

Select 'age > 55','sex =...

quote:

---

BOL 2000:

Examples

A. Rule with a range

This example creates a rule that restricts the range of integers inserted into the column(s) to which...

To add to the previous posts, maybe try a top 1, then top 1000, etc. and see if there is a linear increase at a time of low activity on...

Haven't done it, but I am pretty sure it can. Just a matter of how.

Barcoder, I agrees on the battle being won, its beneficial to the whole company but still needs to win the war by keep the agrees/discipline/etc. in place and adhere to...

If practical, run an update statistics with fullscan. Maybe the stats is not accurate enough.

What is the number of rows in the table and value for the column rowmodctr in...

Example:

Create Procedure Fact(@Val as Int,@Answ as Int Output) as

If @Val<2 

    Begin

    Set @Answ=1

    End

Else

  ...

Version II, may need a bit more work!

Create Function Keys(@TableId Int,@IndexId Int) Returns Varchar(1000) as

    Begin

    ...

I agree. I still wish one can get a SQL printed manual like with 6.5, I think it was the 'Programmers Reference manual', which you can take home and study...

Create Function StripRightZero(@Val Decimal(18,4)) Returns VarChar(18)

Begin

Declare @Answ Varchar(18)

Select @Answ=Cast(Cast(@Val as Decimal(18,4)) as Varchar(18))

While Right(@Answ,1)='0'

Set @Answ=Left(@Answ,DataLength(@Answ)-1)

Return @Answ

End

Go

Set NoCount On

Declare @Val Decimal(18,4)

Set @Val=12.1

Select dbo.StripRightZero(@Val)

Set @Val=12.01

Select dbo.StripRightZero(@Val)

Set @Val=12

Select dbo.StripRightZero(@Val)

Drop...

Slightly of the mark but never the less.

http://manuals.sybase.com/onlinebooks/group-as/asg1200e/aserefmn/@Generic__BookTextView/172152

Search for 99.