1. 用sql语句创建表，如何以表的形式显示出来，语句写好了
自己打开企业管理器，随便找个表，导出一个创建表的脚本，就什么都有了。
要语法，SQL的联机帮助里就有：
CREATE
TABLE
[
database_name
.
[
schema_name
]
.
|
schema_name
.
]
table_name
(
{
<column_definition>
|
<computed_column_definition>
}
[
<table_constraint>
]
[
,...n
]
)
[
ON
{
partition_scheme_name
(
partition_column_name
)
|
filegroup
|
"default"
}
]
[
{
TEXTIMAGE_ON
{
filegroup
|
"default"
}
]
[
;
]
<column_definition>
::=
column_name
<data_type>
[
COLLATE
collation_name
]
[
NULL
|
NOT
NULL
]
[
[
CONSTRAINT
constraint_name
]
DEFAULT
constant_expression
]
|
[
IDENTITY
[
(
seed
,increment
)
]
[
NOT
FOR
REPLICATION
]
]
[
ROWGUIDCOL
]
[
<column_constraint>
[
...n
]
]
<data
type>
::=
[
type_schema_name
.
]
type_name
[
(
precision
[
,
scale
]
|
max
|
[
{
CONTENT
|
DOCUMENT
}
]
xml_schema_collection
)
]
<column_constraint>
::=
[
CONSTRAINT
constraint_name
]
{
{
PRIMARY
KEY
|
UNIQUE
}
[
CLUSTERED
|
NONCLUSTERED
]
[
WITH
FILLFACTOR
=
fillfactor
|
WITH
(
<
index_option
>
[
,
...n
]
)
]
[
ON
{
partition_scheme_name
(
partition_column_name
)
|
filegroup
|
"default"
}
]
|
[
FOREIGN
KEY
]
REFERENCES
[
schema_name
.
]
referenced_table_name
[
(
ref_column
)
]
[
ON
DELETE
{
NO
ACTION
|
CASCADE
|
SET
NULL
|
SET
DEFAULT
}
]
[
ON
UPDATE
{
NO
ACTION
|
CASCADE
|
SET
NULL
|
SET
DEFAULT
}
]
[
NOT
FOR
REPLICATION
]
|
CHECK
[
NOT
FOR
REPLICATION
]
(
logical_expression
)
}
<computed_column_definition>
::=
column_name
AS
computed_column_expression
[
PERSISTED
[
NOT
NULL
]
]
[
[
CONSTRAINT
constraint_name
]
{
PRIMARY
KEY
|
UNIQUE
}
[
CLUSTERED
|
NONCLUSTERED
]
[
WITH
FILLFACTOR
=
fillfactor
|
WITH
(
<index_option>
[
,
...n
]
)
]
|
[
FOREIGN
KEY
]
REFERENCES
referenced_table_name
[
(
ref_column
)
]
[
ON
DELETE
{
NO
ACTION
|
CASCADE
}
]
[
ON
UPDATE
{
NO
ACTION
}
]
[
NOT
FOR
REPLICATION
]
|
CHECK
[
NOT
FOR
REPLICATION
]
(
logical_expression
)
[
ON
{
partition_scheme_name
(
partition_column_name
)
|
filegroup
|
"default"
}
]
]
<
table_constraint
>
::=
[
CONSTRAINT
constraint_name
]
{
{
PRIMARY
KEY
|
UNIQUE
}
[
CLUSTERED
|
NONCLUSTERED
]
(column
[
ASC
|
DESC
]
[
,...n
]
)
[
WITH
FILLFACTOR
=
fillfactor
|WITH
(
<index_option>
[
,
...n
]
)
]
[
ON
{
partition_scheme_name
(partition_column_name)
|
filegroup
|
"default"
}
]
|
FOREIGN
KEY
(
column
[
,...n
]
)
REFERENCES
referenced_table_name
[
(
ref_column
[
,...n
]
)
]
[
ON
DELETE
{
NO
ACTION
|
CASCADE
|
SET
NULL
|
SET
DEFAULT
}
]
[
ON
UPDATE
{
NO
ACTION
|
CASCADE
|
SET
NULL
|
SET
DEFAULT
}
]
[
NOT
FOR
REPLICATION
]
|
CHECK
[
NOT
FOR
REPLICATION
]
(
logical_expression
)
}
<index_option>
::=
{
PAD_INDEX
=
{
ON
|
OFF
}
|
FILLFACTOR
=
fillfactor
|
IGNORE_DUP_KEY
=
{
ON
|
OFF
}
|
STATISTICS_NORECOMPUTE
=
{
ON
|
OFF
}
|
ALLOW_ROW_LOCKS
=
{
ON
|
OFF}
|
ALLOW_PAGE_LOCKS
={
ON
|
OFF}
}
2. 将SQL查询分析器查询的结果用SQL语句导出到Excel表格的语句怎么写
从SQL数据库中,导出数据到Excel(excel存在),
insertintoOPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel5.0;HDR=YES;DATABASE=c: est.xls',sheet1$)
select * from bi_t_item_info where item_subno like '%8952%'从SQL数据库中,导出数据到Excel(excel不存在),
---- 导出查询语句
EXECmaster..xp_cmdshell'bcp"select * from bi_t_item_info where item_subno like '%8952%'"queryout"c:
est.xls"/c-/S"服务器名"/U"用户名"-P"密码"'
这样行了吧，你自己稍稍改下服务器名、用户名、密码就行了。
3. 求sql查询结果用表格形式显示
select * form a into xls 表名
TO 后面加 你的表格的扩展名 就行 表名你自己随便起 只要你别忘记就行
默认的保存地方是 你SQL那个程序的保存地方
4. 用SQL语句查询，如何选择输出结果形式（报表、表之类）
在查询设计器中选择系统菜单中的“查询”下的“查询去向”菜单项，在弹出的“查询去向”对话框中单击相应的按钮就可以了（如，报表、表等）。
5. [sql]怎么把这些在查询结果中写成一张表格
这个是没办法的！
因为你的循环是select，所以每循环一次都多一个表格！
如果你想实现的你的目的：
你试试看
declare @position int , @string char(3)
set @position =1
set @string = 'abc'
while @position <= len(@string)
begin
select cast(ascii(substring(@string ,@position , 1)) as varchar) as ASCII值
union select char(ascii(substring(@string ,@position , 1))) as 对应字母
set @position = @position + 1
end
go
试试看！
最多也只能这个样子！
如果你想实现！
必须把值插入到临时表，然后读取！
6. sql的表怎么以“ 结果表 ”显示
sql中把一个查询结果当作另一个表来查询可以理解查询结果为一个临时表 使用select语句查询结果集即可。 参考代码： 1：将结果作为一个临时表，可以使用链接或者直接查询 select * from ( SELECT SUM(NUM_QNTY4) AS sumNum, NUM_LINKID FROM RW_STORE_QUNTY GROUP