B Bkhswrp Unregistered / Unconfirmed GUEST, unregistred user! 2002-07-15 #1 我在建表的时候,对某一个字段设置了缺省值,现在我想在程序中获得这个缺省值,应该怎么做呢?
T twos Unregistered / Unconfirmed GUEST, unregistred user! 2002-07-16 #5 什么数据库? 应该可以取表定义的呀,里面肯定有你设置的缺省值
A armyjiang Unregistered / Unconfirmed GUEST, unregistred user! 2002-07-16 #6 oracle: select column_name,data_default from user_tab_columns where table_name=tabname 注意:data_default的字段类型为long
oracle: select column_name,data_default from user_tab_columns where table_name=tabname 注意:data_default的字段类型为long
0 0738 Unregistered / Unconfirmed GUEST, unregistred user! 2002-07-16 #7 Sqlserver7 select text from syscomments where id=(select id from sysobjects where parent_obj = object_id('tablename') and xtype='D' and col_name(object_id('tablename'),Info)='fieldname')
Sqlserver7 select text from syscomments where id=(select id from sysobjects where parent_obj = object_id('tablename') and xtype='D' and col_name(object_id('tablename'),Info)='fieldname')