SELECT语句使用

USE tempdb
GO

SELECT *
FROM syscolumns
GO

SELECT TOP 10 *
FROM syscolumns
GO

SELECT TOP 10 PERCENT *
FROM syscolumns
GO

SELECT name,id
FROM syscolumns
GO

SELECT TOP 10 name,id
FROM syscolumns
GO

SELECT TOP 10 PERCENT name,id,xtype,length
FROM syscolumns
GO

转载于:https://blog.51cto.com/django/434545