Click here to Skip to main content
15,889,034 members
Home / Discussions / Database
   

Database

 
GeneralRe: can an Access DB and a SQLce DB be used by multiple people simultaneously ? Pin
_Damian S_19-Oct-09 19:52
professional_Damian S_19-Oct-09 19:52 
Questionserver down Pin
baala.m19-Oct-09 3:07
baala.m19-Oct-09 3:07 
AnswerRepeat Pin
Not Active19-Oct-09 3:38
mentorNot Active19-Oct-09 3:38 
GeneralRe: Repeat Pin
scottgp19-Oct-09 5:34
professionalscottgp19-Oct-09 5:34 
GeneralRe: Repeat Pin
Mycroft Holmes19-Oct-09 14:25
professionalMycroft Holmes19-Oct-09 14:25 
Questionconverting nvarchar to smalldatetime Pin
Lalit singh19-Oct-09 1:08
Lalit singh19-Oct-09 1:08 
AnswerRe: converting nvarchar to smalldatetime Pin
Ashfield19-Oct-09 1:18
Ashfield19-Oct-09 1:18 
GeneralRe: converting nvarchar to smalldatetime Pin
Lalit singh19-Oct-09 1:52
Lalit singh19-Oct-09 1:52 
Hi Thanks For your reply ,

The thing is that i have one table in which date is stored in column(datataype nvarchar)
There are more than lacs of records in this table.

so i want to convert this field into following format

ORIGINAL FORMAT OF FIELD IN TABLE (DATATYPE:-NVARCHAR) => 30/11/2009

I WANT INTO FORMAT : 30112009
AND ANOTHE FORMAT : 30/11/2009(SMALL DATETIME)


Please help me out.

I tried the solution which you gave but its giving following error

"Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type smalldatetime.
"

Please help me out
GeneralRe: converting nvarchar to smalldatetime Pin
Ashfield19-Oct-09 8:45
Ashfield19-Oct-09 8:45 
GeneralRe: converting nvarchar to smalldatetime Pin
Lalit singh19-Oct-09 18:40
Lalit singh19-Oct-09 18:40 
GeneralRe: converting nvarchar to smalldatetime Pin
_Damian S_19-Oct-09 19:04
professional_Damian S_19-Oct-09 19:04 
GeneralRe: converting nvarchar to smalldatetime Pin
Ashfield19-Oct-09 20:56
Ashfield19-Oct-09 20:56 
GeneralRe: converting nvarchar to smalldatetime Pin
Lalit singh19-Oct-09 23:08
Lalit singh19-Oct-09 23:08 
GeneralRe: converting nvarchar to smalldatetime Pin
Ashfield20-Oct-09 1:54
Ashfield20-Oct-09 1:54 
GeneralRe: converting nvarchar to smalldatetime Pin
Lalit singh20-Oct-09 2:04
Lalit singh20-Oct-09 2:04 
AnswerRe: converting nvarchar to smalldatetime Pin
Luc Pattyn19-Oct-09 3:29
sitebuilderLuc Pattyn19-Oct-09 3:29 
GeneralRe: converting nvarchar to smalldatetime Pin
Richard MacCutchan19-Oct-09 4:47
mveRichard MacCutchan19-Oct-09 4:47 
AnswerRe: converting nvarchar to smalldatetime Pin
Mycroft Holmes19-Oct-09 14:31
professionalMycroft Holmes19-Oct-09 14:31 
Questionserver down Pin
baala.m18-Oct-09 17:24
baala.m18-Oct-09 17:24 
AnswerRe: server down Pin
Mycroft Holmes18-Oct-09 19:31
professionalMycroft Holmes18-Oct-09 19:31 
AnswerRe: server down Pin
scottgp19-Oct-09 3:06
professionalscottgp19-Oct-09 3:06 
QuestionOrder of evaluation for sub-queries Pin
Steve Holdorf18-Oct-09 9:52
Steve Holdorf18-Oct-09 9:52 
AnswerRe: Order of evaluation for sub-queries Pin
Not Active18-Oct-09 10:45
mentorNot Active18-Oct-09 10:45 
AnswerRe: Order of evaluation for sub-queries Pin
i.j.russell18-Oct-09 11:27
i.j.russell18-Oct-09 11:27 
GeneralRe: Order of evaluation for sub-queries Pin
Steve Holdorf18-Oct-09 13:03
Steve Holdorf18-Oct-09 13:03 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.