简单查询MSSQL [英] Simple query for MSSQL
问题描述
大家好,
我必须在MSSQL 2000上运行一个简单的查询。
我是数据库使用的新手。
我需要创建一个包含下表列的视图
LIST_PRICE十进制;
MAP varchar(6 );
STREET_NO varchar(10);
STREET_NAME varchar(30);
SQUARE_FEET十进制;
PARKING_FEATURE varchar(9)
这是SQLGrinder(我是Mac用户)为我生成的查询:
创建视图测试
(
LIST_PRICE十进制,
MAP varchar(6),
STREET_NO varchar(10),
STREET_NAME varchar(30),
SQUARE_FEET十进制,
PARKING_FEATURE varchar(9)
)
当我运行此查询时,SQLGrinder返回错误:
第1行:十进制附近的语法不正确
你能否告诉我它有什么问题(抱歉这么愚蠢的询问)以及如何正确运行这个查询。
非常感谢!
rogik
Hi guys,
I have to run a simple query on a MSSQL 2000.
I''m new to database usage.
I need to create a view with the following table columns
LIST_PRICE decimal;
MAP varchar(6);
STREET_NO varchar(10);
STREET_NAME varchar(30);
SQUARE_FEET decimal;
PARKING_FEATURE varchar(9)
Here is a query that SQLGrinder (I''m a Mac user) has generated for me:
CREATE VIEW TEST
(
LIST_PRICE decimal,
MAP varchar(6),
STREET_NO varchar(10),
STREET_NAME varchar(30),
SQUARE_FEET decimal,
PARKING_FEATURE varchar(9)
)
When I run this query, SQLGrinder returns an error:
Line 1: incorrect syntax near "decimal"
Could you please tell me what''s wrong with it (and sorry for such a stupid inquiry) and how to run this query properly.
Thanks a lot!
rogik
推荐答案
1。要创建视图,请使用以下命令:
[PHP]创建视图测试
AS
LIST_PRICE,
地图,
STREET_NO,
STREET_NAME,
SQUARE_FEET,
PARKING_FEATURE >
- 在这里你需要一个From close含义从哪个表中选择
FROM table_name [/ PHP]
2.获得结果在步骤1中成功创建视图后执行以下操作:
[PHP]从TEST中选择* [/ PHP]
1. To create a view use following:
[PHP]CREATE VIEW TEST
AS
LIST_PRICE,
MAP,
STREET_NO ,
STREET_NAME,
SQUARE_FEET,
PARKING_FEATURE
-- here you need a From close meaning from which table to select
FROM table_name[/PHP]
2. To get result do following after successfully creating a view in step 1:
[PHP]Select * from TEST[/PHP]
1.要创建视图,请使用以下内容:
[PHP]创建视图测试
AS
LIST_PRICE,
地图,
STREET_NO,
STREET_NAME,
SQUARE_FEET,>
PARKING_FEATURE
- 在这里你需要一个从近似的意义来从哪个表中选择
FROM table_name [/ PHP]
2.要在步骤1中成功创建视图后获取结果,请执行以下操作:
>
[PHP]从TEST中选择* [/ PHP]
1. To create a view use following:
[PHP]CREATE VIEW TEST
AS
LIST_PRICE,
MAP,
STREET_NO ,
STREET_NAME,
SQUARE_FEET,
PARKING_FEATURE
-- here you need a From close meaning from which table to select
FROM table_name[/PHP]
2. To get result do following after successfully creating a view in step 1:
[PHP]Select * from TEST[/PHP]
当我使用第1部分中的文本然后尝试执行它时(使用执行" SQLGrinder的命令,它仍然给我以下错误:
[Microsoft] [用于JDBC的SQLServer 2000驱动程序] [SQLServer]第1行:LIST_PRICE附近的语法不正确。 br />
你知道它会是什么吗?
非常感谢!
Oleg
When I use the text in part 1 and then try to execute it (using "Execute" command of SQLGrinder, it still gives me the following error:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 1: Incorrect syntax near ''LIST_PRICE''.
Do you know what could it be?
Thanks a lot!
Oleg
你应该在服务器端运行它,从前端使用第二个语句。
You should run it on a server side and second statement use from a front end.
这篇关于简单查询MSSQL的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!