Unfamiliar Code

• pgmr1998

  Valued Member

  Points: 65

  More actions

  March 15, 2012 at 8:33 am

  #258675

  I have some code in a stored proc, but I am not sure of what the '@' char means. Please explain...

  Here is the code I am having trouble understanding:

  CREATE PROCEDURE [dbo].[RPT_Company_LIST]

  (

  @StartDate datetime = NULL,

  @EndDate datetime = NULL,

  @PrjName varchar(50) = '%',

  @TaskName varchar(50) = '%',

  @CoName varchar(50) = '%'

  )

  AS

• Ant-Green

  SSC Guru

  Points: 113509

  More actions

  March 15, 2012 at 8:37 am

  #1459898

  the @ means its a parameter/variable which is used to run the query block

  eg

  delcare @name = 'Anthony'

  select * from users where name = @name

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  March 15, 2012 at 8:38 am

  #1459900

  Have you even bothered to look this up in Books Online? The @ is the first character of a local variable or parameter.