2009年8月28日
罗列没有主键的表
摘要： This is very simple but effective script. It list all the table without primary keys. USE DatabaseName; GO SELECT SCHEMA_NAME(schema_id) AS SchemaName,name AS TableName FROM sys.tables WHERE OBJECTPRO... 阅读全文
posted @ 2009-08-28 02:19 卜海清 阅读(182) 评论(0) 推荐(0)
(转)SQL Server Data Types and Their .NET Framework Equivalents
摘要： SQL Server data type          CLR data type (SQL Server)    CLR data type (.NET Framework)  varbinary     ... 阅读全文
posted @ 2009-08-28 00:06 卜海清 阅读(234) 评论(0) 推荐(0)