what is this mean

[angels777]

Hi may i know what is the 0000000 mean? CREATE PROCEDURE [users_retrieve] @UserId bigint = 00000000,

[Christian Graus]

zero. zip. Nada. It's a default value. 0 would be fine. In future, we have a SQL forum.

Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

[Vikram A Punathambekar]

Maybe we need so many zeros to tell the compiler it's a bigint? :-D

Cheers, Vikram.

---

The hands that help are holier than the lips that pray.

[Ashfield]

This is really a sql questrion by the look of it, but the zeros are the default value for the parameter if you do not pass it in.

Bob Ashfield Consultants Ltd