What does this symbol mean ?

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

VB Code:

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)

It is a variable

e.g.

DECLARE @my_thing CHAR(3)

SELECT @my_thing = 'HI'

SELECT @my_thing

prints "HI"...

Hmm , isn't here a string ?

VB Code:

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

isn't it the same as this ??

VB Code:

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

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

Quote:

---

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 .

VB Code:

dim @a as String

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

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

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..

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