Linked List in SQL

by

create a table with two self referencing columns PreviousID and NextID. If the item is the first thing in the list PreviousID will be null, if it is the last, NextID will be null. The SQL will look something like this:

create table tblDummy
{
     PKColumn     int     not null, 
     PreviousID     int     null, 
     DataColumn1     varchar(50)     not null, 
     DataColumn2     varchar(50)     not null,  
     DataColumn3     varchar(50)     not null, 
     DataColumn4     varchar(50)     not null, 
     DataColumn5     varchar(50)     not null, 
     DataColumn6     varchar(50)     not null, 
     DataColumn7     varchar(50)     not null, 
     NextID     int     null
}

More Related Contents:

  1. Case statement for multiple columns
  2. Transaction lock in sql
  3. SQL where clause odd behavior [closed]
  4. SQL Server Exec issue [closed]
  5. Count(*) vs Count(1) – SQL Server
  6. Selecting data from two different servers in SQL Server
  7. PostgreSQL: running count of rows for a query ‘by minute’
  8. Is a view faster than a simple query?
  9. How to get matching data from another SQL table for two different columns: Inner Join and/or Union?
  10. SQL SELECT WHERE field contains words
  11. How to use the ‘as’ keyword to alias a table in Oracle?
  12. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  13. Date Difference between consecutive rows
  14. What does Include() do in LINQ?
  15. SQL Server: Howto get foreign key reference from information_schema?
  16. How do you import a large MS SQL .sql file?
  17. Difference between Subquery and Correlated Subquery
  18. How do SQL EXISTS statements work?
  19. Sql script to find invalid email addresses
  20. ORA 00904 Error:Invalid Identifier
  21. postgresql: INSERT INTO … (SELECT * …)
  22. Does Sql JOIN order affect performance?
  23. Best equivalent for IsInteger in SQL Server
  24. What does the colon sign “:” do in a SQL query?
  25. Using tuples in SQL “IN” clause
  26. Unfindable SQLite Syntax Error
  27. Inserting into Oracle and retrieving the generated sequence ID
  28. Converting String List into Int List in SQL
  29. How can I find Unicode/non-ASCII characters in an NTEXT field in a SQL Server 2005 table?
  30. Postgres: convert single row to multiple rows (unpivot)

Leave a Comment