Showing posts with label ideas. Show all posts
Showing posts with label ideas. Show all posts

Tuesday, March 20, 2012

Access 95 to Sql 2000 upgrade....

I am going to have to do an Access 95 to SQL Server 2000 upgrade and
I'm not really sure where to start...
Does anyone have any hints or ideas on where I should begin with this?
Thanks from the newbie.This is a multi-part message in MIME format.
--=_NextPart_000_022A_01C37788.DC0E2D00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
This is a good place to start:
http://www.apress.com/book/bookDisplay.html?bID=3D74
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"otisbirdsong" <seidelts@.hotmail.com> wrote in message =news:3c13052a.0309100642.7de87ba3@.posting.google.com...
I am going to have to do an Access 95 to SQL Server 2000 upgrade and
I'm not really sure where to start...
Does anyone have any hints or ideas on where I should begin with this?
Thanks from the newbie.
--=_NextPart_000_022A_01C37788.DC0E2D00
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

This is a good place to =start:
http://www.apress.com/book/bookDisplay.html?bID=3D74">http://www.=apress.com/book/bookDisplay.html?bID=3D74
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"otisbirdsong" wrote =in message news:3c1305=2a.0309100642.7de87ba3@.posting.google.com...I am going to have to do an Access 95 to SQL Server 2000 upgrade =andI'm not really sure where to start...Does anyone have any hints or =ideas on where I should begin with this?Thanks from the =newbie.

--=_NextPart_000_022A_01C37788.DC0E2D00--

Saturday, February 11, 2012

about datetime

I have to convert date such as '2006-09-21 13:27:25.077' to '20060921'

any ideas?

thanks in advance

I attempted to convert(char(8),getdate()),but result is 'Sep 21...'

I have no idea about that

|||

Problem solved!

datatime have many styles

just like convert(char(8),getdate(),112) can perform what i want