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 |
|
ag_ss
Starting Member
48 Posts |
 Posted - 2006-04-03 : 06:43:46
|
| can i add null to identity type column |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2006-04-03 : 07:00:11
|
| No. What are you trying to do? |
 |
|
|
ag_ss
Starting Member
48 Posts |
Posted - 2006-04-03 : 07:09:01
|
| i have a sp on oracle and trying to port it on MSSQLin that i was having rowid type column and was inserting null into that and one place using updateboth of these thigs doesnt work with identity type column |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-04-03 : 07:41:51
|
| If you want it to have NULL. then dont use identity propertyMadhivananFailing to plan is Planning to fail |
|
|
|
ag_ss
Starting Member
48 Posts |
Posted - 2006-04-03 : 07:44:53
|
| then how to create row ideither i should have one identity column or one unique cloumn |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-04-03 : 09:03:59
|
| Create the identity column.. and dont try to insert value explicitly into it..then it should work as rowid..If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
|
|
|
|
|
|
identity column