Click here to Skip to main content
15,882,552 members
Home / Discussions / Database
   

Database

 
QuestionReports are not visible on client machine Pin
meetaqadir15-Jul-08 20:54
meetaqadir15-Jul-08 20:54 
QuestionOLEDB with Excel problem Pin
acroitoriu15-Jul-08 20:52
acroitoriu15-Jul-08 20:52 
AnswerRe: OLEDB with Excel problem Pin
acroitoriu15-Jul-08 21:23
acroitoriu15-Jul-08 21:23 
Questionfacing probs in nested cursor Pin
Member 387988115-Jul-08 19:56
Member 387988115-Jul-08 19:56 
AnswerRe: facing probs in nested cursor Pin
Alsvha15-Jul-08 23:28
Alsvha15-Jul-08 23:28 
Questionbytes retrieval Pin
vicki52815-Jul-08 18:19
vicki52815-Jul-08 18:19 
AnswerRe: bytes retrieval Pin
Alsvha15-Jul-08 23:28
Alsvha15-Jul-08 23:28 
QuestionHow do i convert a varchar field into the datetime data type Pin
Rameez Raja15-Jul-08 18:12
Rameez Raja15-Jul-08 18:12 
hi,
How do i convert a varchar field into the datetime data type? the reason i need this lies in the requirement that in the earlier data base the column that is holding the date value is having the data type as varchar. and in the new design the column data type is datetime. How i transfer old Data to new column without loss .from the older design to the newer and got stuck with this datetime convertion issue. do let me know the best possible solution.iam using sql server 2000

following are the sample date Format that is there in the older table for the date.


dd/mm/yyyy.


Regards
Rameez
AnswerRe: How do i convert a varchar field into the datetime data type Pin
Alsvha15-Jul-08 23:31
Alsvha15-Jul-08 23:31 
QuestionDATABASE CONNECTIVITY Pin
murphy7715-Jul-08 15:58
murphy7715-Jul-08 15:58 
AnswerRe: DATABASE CONNECTIVITY Pin
Ashfield15-Jul-08 21:45
Ashfield15-Jul-08 21:45 
QuestionConnecting to an ODBC DataSource Pin
ffowler15-Jul-08 14:17
ffowler15-Jul-08 14:17 
QuestionDatabase Publishing Wizard alternatives Pin
Todd Smith15-Jul-08 9:15
Todd Smith15-Jul-08 9:15 
AnswerRe: Database Publishing Wizard alternatives Pin
Alsvha15-Jul-08 23:34
Alsvha15-Jul-08 23:34 
Questionautomatica fire event Pin
Member 387988115-Jul-08 4:12
Member 387988115-Jul-08 4:12 
AnswerRe: automatica fire event Pin
Mark J. Miller15-Jul-08 7:07
Mark J. Miller15-Jul-08 7:07 
QuestionHow to make subreport display based on data Pin
imranafsari15-Jul-08 1:25
imranafsari15-Jul-08 1:25 
AnswerRe: How to make subreport display based on data Pin
TheFM23415-Jul-08 5:33
TheFM23415-Jul-08 5:33 
QuestionResetting Identity Column in oracle Pin
meeram39514-Jul-08 23:45
meeram39514-Jul-08 23:45 
AnswerRe: Resetting Identity Column in oracle Pin
scottgp15-Jul-08 3:58
professionalscottgp15-Jul-08 3:58 
QuestionConfigure SQL 2005 For Remote Connection Pin
swjam14-Jul-08 23:43
swjam14-Jul-08 23:43 
AnswerRe: Configure SQL 2005 For Remote Connection Pin
Tim Leung15-Jul-08 0:30
Tim Leung15-Jul-08 0:30 
Questiondoubt Pin
Kissy1614-Jul-08 23:30
Kissy1614-Jul-08 23:30 
AnswerRe: doubt Pin
Colin Angus Mackay15-Jul-08 3:07
Colin Angus Mackay15-Jul-08 3:07 
GeneralRe: doubt Pin
Alsvha15-Jul-08 23:33
Alsvha15-Jul-08 23:33 

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.