关于SQL Server Mangment Studio [英] Regarding SQL server Mangment Studio

问题描述

大家好，

正在编写简单查询以从我的应用程序中的表中获取数据.对于
实践中，我刚刚使用过SQL Server Management Studio2008.
我的查询如下:

  SELECT  " ." ，
         " ."  bdgt_orig_amnt"，
         " ."  bdgt_percent"，
         " ."  bdgt_projected"，
         " ."  bdgt_revised"，
         " ." 标题"，
         " ." 项目名称"，
         " ." 已发行的事实"，
         " ." 已收到的事实"，
         " ."  approved_var"，
         " ."  cmmt_orig_amnt"，
         " ."  cmmt_pend_rev"，
         " ."  cmmt_apprvd_rev"，
         " ."  pending_var"，
         " ."  projected_var"，
         " ." 原始变量"，
         " ." 公司名称"，
         " ." 职位编号"，
         " ."  project_number"，
         " ."  project_title"，
         " ."  cmmt_projected"，
         " ."  cmmt_revised"，
         " ." 除数"，
         " ."  bdgt_apprvd_rev"，
         " ."  bdgt_pend_rev"，
         " ."  bdgt_est_rev"，
         " ." 订单代码"，
         " ."  cost_code"，
         " ."  order_code_sequence"，
         " ."  cmmt_adjustment"，
" ." 除数"，
" ."  project_currency"
    FROM " ，
         " ，
         " ，
         " 
   在哪里(" ."  project_name" =   proj"." ) and 
         (" ."  company_abbrev" =   vnmt"." ) and 
         (" ." 项目名称" =   pref_table"." ) and 
         (((csmt.project_name =:project_name) AND 
         (vnmt.project_name =:vendor_type))

但这在最后一行的
给了我错误
((csmt.project_name =:project_name)AND
(vnmt.project_name =:vendor_type))

错误是
Msg 102，第15级，状态1，第40行
'':''附近的语法不正确.

我该如何解决这个问题
谁能帮我，因为我是SQL新手?
谢谢&问候
Yogesh

解决方案

输入参数和变量应在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

这篇关于关于SQL Server Mangment Studio的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！