数据库|mysql教程
获取,SQL,Server,信息,http,python.d
数据库-mysql教程
社交网源码,vscode选浏览器,ubuntu命令mv,哪些应用基于tomcat,红色长爬虫,php 求数组最大值,seo sem要做些什么营销,特产网站源码带支付,discuz3.0模板下载lzw
/articles/wxpython-how-use-clipboard SQL Server 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 maste
web菜单源码 免费下载,Ubuntu开机终端模式,tomcat8默认堆大小,爬虫app有哪些,php教程从零开始学技术,寿光seo优化lzw
二手域名交易源码,ubuntu开发的好处,漏洞分析和爬虫,php 匿名聊天,做seo辛苦lzw
/articles/wxpython-how-use-clipboard
SQL Server
.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;}
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 (NP, NPC))DROP PROCEDURE [dbo].[sp_GTC]GO-- =============================================-- Author:David Elliott-- Create date: 05/01/-- Description: Return table information---- INPUT-- @tableNameName of the table to get information about-- @display 0 = Tabular, 1 = CSV-- @orderByName 0 = No,1 = Yes-- =============================================CREATE PROCEDURE sp_GTC@tableNameVARCHAR(255) ,@display TINYINT = 0 ,@orderByName BIT= 0AS SET NOCOUNT ON DECLARE @tableColumns TABLE ( column_idINT ,column_name VARCHAR(200) ,dataType VARCHAR(200) ,max_lengthINT ,precisionTINYINT ,scaleINT ,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), ) 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), ) ELSE column_name END FOR XML PATH(\) ), 2, 200000) AS CSV ENDGOEXEC sys.sp_MS_marksystemobject sp_GTCGO
如果觉得《获取 SQL Server 的表信息》对你有帮助，请点赞、收藏，并留下你的观点哦！
