Sql Server 问题大哥大姐进来看看啊! SP_HELPINDEX 表名,主键就默认索引了吧 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 以前做过的,你看看可以得到主见public DataTable GetTableColumns(string strConnString, string strTableName){ DataAccess datAccess = new DataAccess(strConnString); string strSQL = "select a.name, b.name as type, isnull(c.indid, 0) pkey, columnproperty(a.id, a.name, 'IsIdentity') autoIncrease" + " from syscolumns a" + " left outer join systypes b on a.xtype=b.xtype and lower(b.name)<>'sysname'" + " left outer join sysindexes c on a.id=c.id and (c.status & 0x800)=0x800" + " and " + " (" + " A.name = index_col('{0}', c.indid, 1)" + " or A.name = index_col('{0}', c.indid, 2)" + " or A.name = index_col('{0}', c.indid, 3)" + " or A.name = index_col('{0}', c.indid, 4)" + " or A.name = index_col('{0}', c.indid, 5)" + " or A.name = index_col('{0}', c.indid, 6)" + " or A.name = index_col('{0}', c.indid, 7)" + " or A.name = index_col('{0}', c.indid, 8)" + " or A.name = index_col('{0}', c.indid, 9)" + " or A.name = index_col('{0}', c.indid, 10)" + " or A.name = index_col('{0}', c.indid, 11)" + " or A.name = index_col('{0}', c.indid, 12)" + " or A.name = index_col('{0}', c.indid, 13)" + " or A.name = index_col('{0}', c.indid, 14)" + " or A.name = index_col('{0}', c.indid, 15)" + " or A.name = index_col('{0}', c.indid, 16)" + " )" + " where a.id=object_id('{0}')"; strSQL = string.Format(strSQL, strTableName); return datAccess.GetDataTable(strSQL);} 学习.net一个星期多两天请高手指点 怎么在mvc3Razor页面中找到head标签 急急急 gridview与excel互导 一个有关匹配<head>...</head>之间的正则表达式 在页面跳转的时候自动弹出对话框 清高手帮忙怎么做 2.0中Atlas验证的问题. 初学者使用WebServices的疑问,自动生成的代理类,把WebServices地址固定死了?? 请高手指点迷津 客户端打印问题(急需) 为什么每页显示相同的图片 谁能帮帮我 写个简单的多用户商城
{
DataAccess datAccess = new DataAccess(strConnString); string strSQL
= "select a.name, b.name as type, isnull(c.indid, 0) pkey, columnproperty(a.id, a.name, 'IsIdentity') autoIncrease"
+ " from syscolumns a"
+ " left outer join systypes b on a.xtype=b.xtype and lower(b.name)<>'sysname'"
+ " left outer join sysindexes c on a.id=c.id and (c.status & 0x800)=0x800"
+ " and "
+ " ("
+ " A.name = index_col('{0}', c.indid, 1)"
+ " or A.name = index_col('{0}', c.indid, 2)"
+ " or A.name = index_col('{0}', c.indid, 3)"
+ " or A.name = index_col('{0}', c.indid, 4)"
+ " or A.name = index_col('{0}', c.indid, 5)"
+ " or A.name = index_col('{0}', c.indid, 6)"
+ " or A.name = index_col('{0}', c.indid, 7)"
+ " or A.name = index_col('{0}', c.indid, 8)"
+ " or A.name = index_col('{0}', c.indid, 9)"
+ " or A.name = index_col('{0}', c.indid, 10)"
+ " or A.name = index_col('{0}', c.indid, 11)"
+ " or A.name = index_col('{0}', c.indid, 12)"
+ " or A.name = index_col('{0}', c.indid, 13)"
+ " or A.name = index_col('{0}', c.indid, 14)"
+ " or A.name = index_col('{0}', c.indid, 15)"
+ " or A.name = index_col('{0}', c.indid, 16)"
+ " )"
+ " where a.id=object_id('{0}')"; strSQL = string.Format(strSQL, strTableName); return datAccess.GetDataTable(strSQL);
}