Database

henry1951 wrote:

If I could build a suitable function I still might do that. I probably could do so by using a single row table with one tuple holding the last integer used, but I have not tried that yet.

henry1951 wrote:

unsigned integers

henry1951 wrote:

faster when dealing with integer

henry1951 wrote:

I chose them for the absolute certainty that there would be no collisions in IDs

PIEBALDconsult wrote:

in Oracle we used "sequences"

Mycroft Holmes wrote:

And the practical difference between a ident and a sequence is?

Mycroft Holmes wrote:

I spend a lot of time chasing down problems in the data

PIEBALDconsult wrote:

Sequences aren't tied to a particular table. You can get a value from a sequence without adding a record

saud_a_k wrote:

<Connection Name="UserID" Value="user" />
<Connection Name="Password" Value="pwd" />

using System;
using System.Data.SqlClient;

static class SqlTester
{
  public static int Main (string[] args)
  {
    using (SqlConnection con = new SqlConnection(args[0])
    {
      try
      {
         con.Open ();
         Console.WriteLine ("Connected succesfull, your ConnectionString is correct :)");
      }
      catch (Exception ex)
      {
         Console.WriteLine ("Something went wrong:\n" + ex.ToString ());
      }
    }
  }
}

• an account with given UserID (should be in the same place as the 'sa')
  
• allowed mixed mode access (not just Windows-authentication)
  
• whether the servers' name is correct (express versions are called different than full servers, and they might even be using a named instance)
  

I are Troll

Eddy Vluggen wrote:

an account with given UserID (should be in the same place as the 'sa')

allowed mixed mode access (not just Windows-authentication)

whether the servers' name is correct (express versions are called different than full servers, and they might even be using a named instance)

saud_a_k wrote:

I checked all these options but I still get the same error

Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

saud_a_k wrote:

I also gave the location of another server but still the page shows up on the server but not on the client

I are Troll

Delete from mytable
where ID not in (select top 100 from mytable order bt ID desc)