if(SELECT count(*)
FROM sysobjects
WHERE (name =
(SELECT name
FROM sysindexes
WHERE (id = OBJECT_ID('TrsNews')) AND (indid =
(SELECT indid
FROM sysindexkeys
WHERE (id = OBJECT_ID('TrsNews')) AND (colid =
(SELECT colid
FROM syscolumns
WHERE (id = OBJECT_ID('TrsNews')) AND (name = 'TN_id'))))))) AND
(xtype = 'PK'))>0
bgein
print '是主键'
end把TrsNews改成你的表名,共有三处,TN_id改成你的字段名就行了。
FROM sysobjects
WHERE (name =
(SELECT name
FROM sysindexes
WHERE (id = OBJECT_ID('TrsNews')) AND (indid =
(SELECT indid
FROM sysindexkeys
WHERE (id = OBJECT_ID('TrsNews')) AND (colid =
(SELECT colid
FROM syscolumns
WHERE (id = OBJECT_ID('TrsNews')) AND (name = 'TN_id'))))))) AND
(xtype = 'PK'))>0
bgein
print '是主键'
end把TrsNews改成你的表名,共有三处,TN_id改成你的字段名就行了。
解决方案 »
- 一个查询小句子的字符与日期转换问题求助。
- 什么是二进制字符串?
- 大乌龟 李冰 邹建在不在 等等知道的告诉我啊这个同样SQL 执行计划为何不一样
- 数据库损坏 用no_truncate备份日志 还原无效啊??求助。。
- ★★★如何将一个存储过程返回的记录连接起来变成一个表★★很难呀
- 在access中有format函数可以这样转换format('2003-1-1',"yyyy-mm')在SQL中怎么办?
- 如何仅仅通过SQL语句获得多个记录同一字段的连接值?该字段为Text(50)数据类型
- sql2000数据库修复问题
- sql server 如何缩小库大小
- 在执行procedure时,怎样得到详细的错误信息?
- 请教关于视图权限的问题
- 询问一条语句
select object_name(parent_obj),* from sysobjects where parent_obj=object_id('你的表名') and type='F'exec sp_pkeys table1----得到表的主键
exec sp_fkeys table1----得到表的外键