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 - 2002-04-08 : 09:52:59
|
| writes "I need to retrieve uniqueidentifier datatypes from SQL 2000 using Java. I know that uniqueidentifiers are 16-byte binary values but don't know hoe to get them. Any suggestions would be greatly appreciated.Thanks" |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-04-08 : 10:19:54
|
| I don't think they are binary. They are just like varchar as far as "reading" them. Try reading them like you do a varchar.Micahel |
 |
|
|
vladguzun
Starting Member
1 Post |
Posted - 2002-04-09 : 03:19:58
|
| Hi,You always can do CAST(newid() as varchar(40)) and you'll be sure that you'll receive a stringregards |
|
|
|
|
|
|
Retrieve uniqueidentifier datatypes