SQL Server Data Types

Results 1 to 2 of 2

Thread: SQL Server Data Types

  1. #1
    Join Date
    Dec 1969

    Default SQL Server Data Types

    Hi All <BR>I was wondering what is the best datatypes for the following.<BR><BR>50 character text&number combination?<BR><BR>10,000 character text&number combination?<BR><BR>url?<BR><BR>What is ntext?<BR><BR>Does SQL Server have information on this, I couldnt find any with in the program? Where do I get further information on Data types?

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Server Data Types

    &#062;&#062; 50 character text&number combination?<BR>&#062;&#062; Url<BR><BR>If the length of the text is expected to be roughly the same use CHAR(50), if it varies a lot use VARCHAR(50)<BR><BR>&#062;&#062; 10,000 character text&number combination<BR><BR>text (or Ntext for unicode)<BR><BR>See &#039;Books Online&#039; it should be in your startmenu under the SQL Server map.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts