c 串口数据存mysql_用c#怎么讲从串口读出来的数据存入SQL SERVER数据库

SELECT

Sysobjects.name AS [表],

syscolumns.name AS [列名],

systypes.name AS [数据类型],

syscolumns.length AS [字段长度],

sys.extended_properties.[value] AS [字段描述],

syscomments.text AS [默认值],

CASE syscolumns.isnullable WHEN '1' THEN 'Y' ELSE 'N' END AS [是否允许空值],

ISNULL(COLUMNPROPERTY(syscolumns.id, syscolumns.name, 'Scale'), 0) AS [小数位数],

COLUMNPROPERTY(syscolumns.id, syscolumns.name, 'IsIdentity') AS [自增标识] ,

CASE WHEN EXISTS (SELECT 1 FROM sysobjects WHERE xtype = 'PK' AND name IN

(SELECT name

FROM sysindexes

WHERE indid IN

(SELECT indid

FROM sysindexkeys

WHERE id = syscolumns.id AND colid = syscolumns.colid)))

THEN '√' ELSE '' END AS [主键]

FROM syscolumns

INNER JOIN systypes

ON syscolumns.xtype = systypes.