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 |
|
Rajat16
Starting Member
2 Posts |
 Posted - 2010-07-30 : 07:32:53
|
| table name with smsfirst field will be SMS_id (auto increment, not null, integer)second field will be sms_number ( not null, varchar(13))third field will be sms_text (not null, varchar (200))fourth field will be creation_date (not null, system date)fifth field will be status( varchar)guys i need it urgently, I stuck in some other workthanks |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2010-07-30 : 07:36:36
|
| You should look up the CREATE TABLE command. This will take you about 2 minutes tops.CREATE TABLE tableName( field1..., field2 etc) |
 |
|
|
Rajat16
Starting Member
2 Posts |
Posted - 2010-07-30 : 07:41:58
|
| cris I am getting stucked for fourth columnkindly help |
|
|
|
kashyap_sql
Posting Yak Master
174 Posts |
Posted - 2010-07-30 : 08:07:07
|
do you want just date or time to if both then just go for this creation_date datetime default getdate() may be preferableWith RegardsKashyap M |
|
|
|
|
|
|
I need the script for creating table below