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