Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vijaySqlserver
Starting Member
1 Post |
 Posted - 2003-03-03 : 00:29:31
|
| --------------------------------------------------------------Master table is 'exception_description'sp_help 'exception_description' typed at SQLQueryAnalyzerError_Code int no 4Error_Description varchar no 200Inserted_By varchar no 50Inserted_Date datetime no 8Updated_By varchar no 50Updated_Date datetime no 8User_Error_Description varchar no 250No identity column defined.No rowguidcol column defined.index_name index_description index_keysPK_Exception_Description clustered, unique, primary key located on PRIMARY Error_Codeconstraint type constraint_name constraint keysPRIMARY KEY (clustered) PK_Exception_Description Error_code---------------------------------------------------------------sp_help 'exception' typed at SQLQueryAnalyzermy table has these columnsError_Code int no 4Error_Description varchar no 150Exception_DateTime datetime no 8No identity column defined. NULL NULLNo rowguidcol column defined.no PRIMARYkeyconstraint type constraint_name constraint keysFOREIGN KEY FK_Exception_Exception_Description Error_codeHow can set ROWNUMBER for 'exception' table?why i am asking is,it does not contain prmarykey.pls send script for this table.what are steps to be followed while implementing ROWNUMBER column because alreadyit 'exception' has more 1000 rows?.pls help me about thisthanks for reading this. |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-03-03 : 01:05:59
|
| ALTER TABLE exception add ROWNUMBER NUMERIC IDENTITY (1,1)Sekar |
 |
|
|
|
|
|
RowNumber