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 |
|
makpandian
Starting Member
2 Posts |
 Posted - 2009-02-28 : 06:55:09
|
| Hi to all i am newer this site.i want to create table with two columns.first for serial number and second for string that contain special char the maximum length of string is infinitive.any one give query for above table creationColumn1 = serial no in integerColumn2 = String of text with infinitive char (it may contain special char)Mak(Living @ Virtual World) |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-02-28 : 06:58:24
|
| create table mytable(column1 int, column2 varchar(max))The varchar(max) will allow you to store up to 2 GB of data. Will you need more than that?Mike"oh, that monkey is going to pay" |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-02 : 09:43:00
|
| if you're using sql 2000 or earlier, you've use text as varchar(max) is available only from 2005 onmwards |
|
|
|
|
|
|
create table syntax.