Requesting querry to view structure

Hi,
Can anybody please help me in writing the syntax to view the structure
of the table in sqlserver 2005.
For example in oracle if we want to see the table structure we will use
the command
desc table name.In similar way is there any command to view the table
structure we have created in sqlserver2005.
ThanksEXEC sp_help 'tablename';
"ganu" <girijak@.hotmail.com> wrote in message
news:1140547519.059657.128250@.g47g2000cwa.googlegroups.com...
> Hi,
> Can anybody please help me in writing the syntax to view the structure
> of the table in sqlserver 2005.
> For example in oracle if we want to see the table structure we will use
> the command
> desc table name.In similar way is there any command to view the table
> structure we have created in sqlserver2005.
>
> Thanks
>

requesting querry to insert date and time

Hi,
Can anybody telll me how to give date and time to be printed in
sqlserver programmin.For example if u want to add data to a table using
insert command how can we enter date and time in that.
please reply me soon.
thanks for helping.Did you have a look on the getdate() function ?
INSERt INTO SomeTable
( colList ... )
VALUES
(
...
GETDATE(),
...
)
HTH, Jens Suessmeyer.|||Do you mean something like GETDATE() . This returns the system time and date
Jack Vamvas
________________________________________
__________________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
New article by Jack Vamvas - Improper Use of indexes on MS SQL: Server
2000 - www.ciquery.com/articles/useofindexes.asp
"gija" <girijak@.hotmail.com> wrote in message
news:1140035764.737565.125890@.g44g2000cwa.googlegroups.com...
> Hi,
> Can anybody telll me how to give date and time to be printed in
> sqlserver programmin.For example if u want to add data to a table using
> insert command how can we enter date and time in that.
> please reply me soon.
> thanks for helping.
>|||INSERT table(column) SELECT '2006-02-15T05:43:21';
INSERT table(column) VALUES('2006-02-15T05:43:21');
"gija" <girijak@.hotmail.com> wrote in message
news:1140035764.737565.125890@.g44g2000cwa.googlegroups.com...
> Hi,
> Can anybody telll me how to give date and time to be printed in
> sqlserver programmin.For example if u want to add data to a table using
> insert command how can we enter date and time in that.
> please reply me soon.
> thanks for helping.
>