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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-02 : 07:54:36
|
| Stephen writes "Dear Friend,I have some queries about UNIQUIIDENTIFIER.If ANSI_NULL_DEFAULT option for a database is ON. It has a colmn defined asPat_ID uniqueidentifier DEFAULT (NEWID())Is it possible that this coulmn can contain 1. NULL Values2. Duplicate Values3. Is this coulmn updatable" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-10-02 : 07:55:12
|
| 1. Yes2. Yes3. Yes |
 |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2006-10-02 : 10:38:31
|
i KNEW rob was a steenking "yes" man!! [Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-10-02 : 23:18:57
|
 Actually I found the question very arousing.  |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-03 : 04:05:55
|
| Oh, this isn't the script for "When Harry met Sally: Café Scene" then?Peter LarssonHelsingborg, Sweden |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-03 : 05:38:56
|
| No, its the Sequel to that .... </sorry!> |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-10-03 : 06:08:00
|
| I'll have what Rob's having.CODO ERGO SUM |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2006-10-03 : 09:49:59
|
| Kristen ALMOST got it!Its the SQL to that movie!SO CLOSE [Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-03 : 10:51:31
|
| I did wonder if it was the Second Coming ... |
|
|
|
|
|
|
About Unique Identfier