1
  • ‘convert as/400 dates ’0001-01-01′ to SQL Server 2000′

    How do I convert ISO dates of '0001-01-01' to SQL Server 2000 Datetime format?

    Jld10 pointsBadges:
  • SQL 2000 view debug help

    I have the following (admittedly convoluted) view that I cannot get right for some reason that I cannot see. Consider the following: SELECT     s.s_SAMPLEID AS LimsSampleId, s.U_CLIENT_SAM_NO AS ADASampleId, MAX(s.SAMPLEDESC) AS SampleDescription,                      ...

    DavidHa!!110 pointsBadges:
  • Migration checker tool for Sql Server 2000 to Sql Server 2008 Migration

      Hello, Please let me know is there any tool available to check the SQL Server 2000 to Sql Server 2008 Migration, so that we can anlyze the procedure or any discrepancies with the Database we are trying to migrate and list all potential issues. Thanks Naina

    Naina5 pointsBadges:
  • How can I use SQL codes in delphy7?

    I am going to use the sql code below in a query in delphy7 SELECT     left(edit1.text, 5)+'0 ' FROM        edit.text2

    Ramin5 pointsBadges:
  • Data type : GMToffset in SQL Server 2000

    how this data type GMToffset will work.?? can you please help me in that where the offset is a feild in the table & GMToffset is its data type exist in sql server 2000 or it is derived ?? why we use GMT instead of local time?? Is this data type x

    NSH5 pointsBadges:
  • SQL Server Agent Job Creation

    Hello, My self Ashish Amodia from India, I want to send Automatic mail with an attachment for that I have created job and from job that I want to open my web page automatically - I am using SQL server 2000. If u know how to open web page from job than please let me know :) Thank you

    AshishAmodia20 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following