获取 SQL Server 的表信息

http://python.dzone.com/articles/wxpython-how-use-clipboard SQL Server exec sp_gtc ‘Employee’ Tabular/Unsortede本文来源gaodai$ma#com搞$$代**码)网@xec sp_gtc ‘Employee’ 0, 1 Tabular/Sortedexec sp_gtc ‘Employee’ 1, 0 CSV/Unsortedexec sp_gtc ‘Employee’ 1, 1 CSV/Sorted USE maste

http://python.dzone.com/articles/wxpython-how-use-clipboard
SQL Server <style> .CodeEntity .code_pieces ul.piece_anchor{width:25px;position:absolute;top:25px;left:-30px;z-index:1000;} .CodeEntity .code_pieces ul.piece_anchor li{width:25px;background: #efe;margin-bottom:2px;} .CodeEntity .code_pieces ul.piece_anchor li{border-left:3px #40AA63 solid;border-right:3px #efe solid;} .CodeEntity .code_pieces ul.piece_anchor li:hover{border-right:3px #40AA63 solid;border-left:3px #efe solid;} .CodeEntity .code_pieces ul.piece_anchor li a{color: #333;padding: 3px 10px;} .CodeEntity .code_pieces .jump_to_code{visibility:hidden;position:relative;} .CodeEntity .code_pieces .code_piece:hover .jump_to_code{visibility:visible;} .CodeEntity .code_pieces .code_piece:hover .jump_to_code a{text-decoration:none;} .CodeEntity .code_pieces h2 i{float:right;font-style:normal;font-weight:normal;} .CodeEntity .code_pieces h2 i a{font-size:9pt;background: #FFFFFF;color:#00A;padding: 2px 5px;text-decoration:none;} </style> <!—ecms

–> <!—ecms
• $velocityCount

–> <!—ecms

–>

exec sp_gtc 'Employee'         Tabular/Unsortedexec sp_gtc 'Employee' 0, 1    Tabular/Sortedexec sp_gtc 'Employee' 1, 0    CSV/Unsortedexec sp_gtc 'Employee' 1, 1    CSV/Sorted

USE masterGOIF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_GTC]') AND type in (N'P', N'PC'))DROP PROCEDURE [dbo].[sp_GTC]GO-- =============================================-- Author:      David Elliott-- Create date: 05/01/2012-- Description: Return table information---- INPUT--    @tableName      Name of the table to get information about--    @display        0 = Tabular, 1 = CSV--    @orderByName    0 = No,      1 = Yes-- =============================================CREATE PROCEDURE sp_GTC      @tableName      VARCHAR(255)    ,@display        TINYINT  = 0    ,@orderByName    BIT      = 0AS    SET NOCOUNT ON    DECLARE @tableColumns TABLE    (         column_id      INT        ,column_name    VARCHAR(200)        ,dataType       VARCHAR(200)        ,max_length     INT        ,precision      TINYINT        ,scale          INT        ,is_nullable    BIT        ,is_identity    BIT    )    INSERT INTO @tableColumns (c.column_id, column_name, dataType, max_length, precision, scale, is_nullable, is_identity)    SELECT c.column_id, c.name AS column_name, ct.name as dataType, c.max_length, c.precision, c.scale, c.is_nullable, c.is_identity    FROM sys.columns c        INNER JOIN sys.tables t ON c.object_id = t.object_id        INNER JOIN sys.types ct ON c.system_type_id = ct.system_type_id    WHERE t.name = @tableName    IF (@display = 0)    BEGIN        SELECT *         FROM @tableColumns         ORDER BY CASE WHEN @orderByName = 0             THEN REPLACE(STR(column_id, 4), SPACE(1), '0')             ELSE column_name             END    END    ELSE IF (@display = 1)    BEGIN        SELECT SUBSTRING(        (            SELECT ', ' + column_name            FROM @tableColumns            ORDER BY CASE WHEN @orderByName = 0                 THEN REPLACE(STR(column_id, 4), SPACE(1), '0')                 ELSE column_name                 END            FOR XML PATH('')        ), 2, 200000) AS CSV    ENDGOEXEC sys.sp_MS_marksystemobject sp_GTCGO

喜欢 (0)赏

[搞代码]

分享 (0)