Re: MS-SQL Related

A uniqueidentifier is equivelent to a GUID, if you've ever used it in
any other programming language. As for SQL Server not allowing you to
use other data types than int, you must be misinterpreting the errror
message. What error message do you see?


Dot Net Daddy wrote:
Hello,

What is uniqueidentifier as a data type?

Also what is the data type for setting unique STRINGS ((nchar,
nvarchar), for example to be used for emails and user names in a user
registration system).

SQL Server does not allow me set primary keys for columns where data
types are not INT.

Thanks in advance.

.

Relevant Pages

  • Re: Data Types
    ... > moved to SQL Server and I don't know the best newsgroups yet. ... > Does a Unique Identifier data type take up less storage space than a 32 ... A uniqueidentifier uses 16 bytes. ... but I'm looking at the data types and think that the TimeStamp ...
    (microsoft.public.sqlserver.programming)
  • Re: Data Types
    ... >> Steve, ... >> Tibor Karaszi, SQL Server MVP ... >>> character varchar data type? ... A uniqueidentifier uses 16 bytes. ...
    (microsoft.public.sqlserver.programming)
  • Re: Error 2570 in SQL Server
    ... out of range for data type "%.*ls". ... Update column to a legal value. ... The exact meaning of the error message is this: ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.programming)
  • Re: Need help grouping members into families
    ... Thank you so much Brendan. ... Using the integer data type and the identify property worked! ... >> FamilyID, etc.) are the SQL Server data type uniqueidentifier, what should ...
    (microsoft.public.access.queries)
  • Problem updating Sql Server database from asp page
    ... I am building an asp application with sql server as backend. ... me an error message. ... Disallowed implicit conversion from data type varchar to data type money, ...
    (microsoft.public.inetserver.asp.db)