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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Insert

Author  Topic 

Fu
Starting Member

23 Posts

Posted - 2005-09-28 : 10:01:48
What's the format of date i should use when i want to insert a date value into a tabel? and how can i format datetime type to accept only year or dd-mm-yyyy?
and how can i insert images into sql, having picture identified as image datatype
insert into tabel(datecolumn)
values(???)

insert into tabel(images)
values ('???')

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-09-28 : 10:06:44
Use Proper DateTime Datatype to store the Date
In your Front End application format it to yyyymmdd format and send it to table

For storing images refer this
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part3/c1161.mspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -