http://python.dzone.com/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
http://python.dzone.com/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 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