variable passing

[murzina]

What is the syntax in SQL Express for passing a variable,
for instance,

Declare @@number decimal
begin
print '@@number'
end

What is wrong with this coding?

 

[gmmastros]

Usually, variables have a single @ symbol, but there's nothing wrong with having 2 of them.

If you want to print the value of @@number, remove the single quotes. In this case, you don't initialize @@number with any value, so it is null. Since you cannot print NULL, you see nothing in the output. While you are at it, I encourage you to use a precision and scale value when using a decimal data type.

Declare @@number decimal(20,10)
Set @@number = 3.1415926536

begin
print @@number
end

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[bborissov]

using @@. Only one @ sign is used for variables:
Also you didn't set any value to this variable. So try this:

DECLARE @number decimal(10,2)
SET @number = 10.25
print @number

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[gmmastros]

Boris,

Just for fun, what do you think the output of the code would be?

Declare @ VarChar(30)
Declare @@ Varchar(30)

Set @ = 0x52616365636172
Set @@ = Reverse(@)

Print @
Print @@

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[bborissov]

Hmmm, varchar and binary,
I don't know what char stay for ASCII code 0x52, 0x61 etc. So I assume that some word will appear and after that you will get the same word reversed
but I don't like the code ))))))
just @ and @@ w/o names, GRRRR!

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[gmmastros]

you will get the same word reversed

Are you sure?


-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[bborissov]

Yeah,
The same word reversed (the Capitial letter is at the end
(I tested it already and I new what stays for 0x52)

Racecar
racecaR

If you used:
Set @ = 0x72616365636172
Then both words would be the same
(but I got this after testing the code )

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.