输入参数和变量应在TSQL中以@开头

  @ project_name  

Hello All,

Am writing simple query to fetch the data from the table in my application.For
Practice i just used SQL server management studio 2008.
My query is as follows:

SELECT "csmt"."bdgt_adjustment",
         "csmt"."bdgt_orig_amnt",
         "csmt"."bdgt_percent",
         "csmt"."bdgt_projected",
         "csmt"."bdgt_revised",
         "csmt"."title",
         "csmt"."project_name",
         "csmt"."actuals_issued",
         "csmt"."actuals_received",
         "csmt"."approved_var",
         "csmt"."cmmt_orig_amnt",
         "csmt"."cmmt_pend_rev",
         "csmt"."cmmt_apprvd_rev",
         "csmt"."pending_var",
         "csmt"."projected_var",
         "csmt"."original_var",
         "proj"."company_name",
         "proj"."job_number",
         "proj"."project_number",
         "proj"."project_title",
         "csmt"."cmmt_projected",
         "csmt"."cmmt_revised",
         "pref_table"."divisor",
         "csmt"."bdgt_apprvd_rev",
         "csmt"."bdgt_pend_rev",
         "csmt"."bdgt_est_rev",
         "csmt"."order_code",
         "csmt"."cost_code",
         "csmt"."order_code_sequence",
         "csmt"."cmmt_adjustment",
"pref_table"."divisor",
"pref_table"."project_currency"
    FROM "csmt",
         "proj",
         "vnmt",
         "pref_table"
   WHERE ( "csmt"."project_name" = "proj"."project_name" ) and
         ( "proj"."company_abbrev" = "vnmt"."vendor_abbrev" ) and
         ( "proj"."project_name" = "pref_table"."project_name" ) and
         ( ( csmt.project_name = :project_name ) AND
         ( vnmt.project_name =:vendor_type ) )

But it gives me error in last line at

( ( csmt.project_name = :project_name ) AND
( vnmt.project_name =:vendor_type ) )

The error is
Msg 102, Level 15, State 1, Line 40
Incorrect syntax near '':''.

How can I resolved that problem
can anybody help me because i am new in SQL

Thanks & Regards
Yogesh

the input parameters and variables should start with @ in TSQL

@project_name

Transact-SQL Variables