sql 2000 字段查詢修正
標簽:
SQL Server
internal static string GetTableColumns2000() { sqlText.Remove(0, sqlText.Length); sqlText.Append("select s1.name as ColumnName,case s2.name when 'nvarchar' then s1.[prec] else s1.[length] end as [MaxSize],"); sqlText.Append("isnullable as [IsNullable],colstat as [ReadOnly],s2.name as [SqlType] ,isnull(s3.[value],'no description') as description "); sqlText.Append("from syscolumns s1 right join systypes s2 on s2.xusertype =s1.xusertype ");//修正有变化 sqlText.Append("left join sysproperties s3 on (s3.id=s1.id and s3.smallid = s1.colid)");//修正有变化 sqlText.Append("where s1.id=object_id(@TableName) and s2.name<>'sysname' order by ReadOnly desc ");//修正有变化 //sqlText.Append("select substring(@@Version, 25,1) "); return sqlText.ToString(); }
记录了:
9:OutPutData 数据库2000输出屏蔽系统自带的[表/视图/存储过程]
string sql2000 = "select name from sysobjects where status>0 and xtype='" + tableType.ToString() + "'";
點擊查看更多內容
為 TA 點贊
評論
評論
共同學習,寫下你的評論
評論加載中...
作者其他優質文章
正在加載中
感謝您的支持,我會繼續努力的~
掃碼打賞,你說多少就多少
贊賞金額會直接到老師賬戶
支付方式
打開微信掃一掃,即可進行掃碼打賞哦