What does this symbol mean ?

[Pirate]

I do understand this code but I'm asking about this special symbol , what does it mean for SQL ?@ lol

cmd.CommandText = "INSERT INTO myTable (Name, RegisteredDate, CancelDate) " & _
    "VALUES (@Name, @RegisteredDate, @CancelDate)"
cmd.Parameters.Add("@Name", "Doug Seven")
cmd.Parameters.Add("@RegisteredDate", DateTime.Today)
'Use System.DBNull.Value to leave the field uninitialized
cmd.Parameters.Add("@CancelDate", System.DBNull.Value)

[Merrion]

It is a variable

e.g.

DECLARE @my_thing CHAR(3)

SELECT @my_thing = 'HI'

SELECT @my_thing

prints "HI"...

[Pirate]

Hmm , isn't here a string ?

cmd.Parameters.Add("@Name", "Doug Seven")

isn't it the same as this ??

cmd.Parameters.Add("Name", "Doug Seven")

[powdir]

in this case they refer to named arguments in a SQLServer Procedure

[Pirate]

Originally posted by powdir
in this case they refer to named arguments in a SQLServer Procedure

I think so . I tried the code below and gives me error . It means , I can't use it with variables as Merrion said .

dim @a as String

[MasterBlaster]

Marion posted how they(variables) are declared inside the sproc.

[Pirate]

You mean this stored procedure language (though I have no idea about it) . It could be . .

[Arc]

Yah that is TransactSQL right? I've never fooled with stored procedures much.

In any case you can't use that in VB code only in Sql Server stored procedures, triggers etc..

[Pirate]

oh TransactSQL ! Still confusing between them ...lol . I noticed that symbol only in SQL Server database .