Database

create table #tableOne
(
  id int,
  name varchar(50),
  email varchar(100)
  )

create table #tableNames
(
  id int,
  name varchar(50)
  )

insert into #tableOne values (1, 'simon','simon@email.com')
insert into #tableOne values (2, 'someone','someone@email.com')

insert into #tableNames values (3, 'fred')


insert into #tableOne 
select id, name,''
from #tablenames


select *
from #tableOne 


drop table #tableNames 
drop table #tableOne 

INSERT INTO b(<<Column_Names>>)
SELECT <<Column_Names>> from a [where <<Condition(if any)>>]

jojoba20 wrote:

how to use fuzzy object oriented database sql?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

jojoba20 wrote:

i dont known any one.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

jojoba20 wrote:

for my collage !
my sir asked me to do that !
and also he doesnt help any!

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Comparison to RDBMS

In an RDBMS, it would be fairly common to see SQL statements like this:
  CREATE TABLE Customers  (
      Id          CHAR(12)    NOT NULL PRIMARY KEY,
      Surname     VARCHAR(32) NOT NULL,
      FirstName   VARCHAR(32) NOT NULL,
      DOB         DATE        NOT NULL
   );
   SELECT InitCap(Surname) || ', ' || InitCap(FirstName)
     FROM Customers
    WHERE Month(DOB) = Month(getdate())
      AND Day(DOB) = Day(getdate())
which some OO fans would describe as overly complex logic. Furthermore, most current SQL databases allow the creation of custom functions, which would allow the query to be expressed as:
   SELECT Formal(Id)
     FROM Customers
    WHERE Birthday(Id) = Today()
In an object-relational database, one might see something like this, where the data types and expressions such as BirthDay() are user-defined.
   CREATE TABLE Customers (
     Id           Cust_Id     NOT NULL  PRIMARY KEY,
     Name         PersonName  NOT NULL,
     DOB          DATE        NOT NULL
   );
   SELECT Formal( C.Name )
     FROM Customers C
    WHERE BirthDay ( C.DOB ) = TODAY;

jojoba20 wrote:

which some OO fans would describe as overly complex logic.

jojoba20 wrote:

In an object-relational database, one might see something like this, where the data types and expressions such as BirthDay() are user-defined.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

jojoba20 wrote:

is there any software that i can make(create) FOODB (Fuzzy Object Oriented DataBase) for SQL ?

jojoba20 wrote:

I am seeking for software to create the DB first.

jojoba20 wrote:

I am confuzed!

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

CREATE TABLE Customers (
  Id           Cust_Id     NOT NULL  PRIMARY KEY,
  Name         PersonName  NOT NULL,
  DOB          DATE        NOT NULL
);



SELECT Formal( C.Name )
  FROM Customers C
 WHERE BirthDay ( C.DOB ) = TODAY;

jojoba20 wrote:

so how to use the code bellow ?

jojoba20 wrote:

I wanna have Object Oriented DataBase

jojoba20 wrote:

In an object-relational database

jojoba20 wrote:

this is example code for creating Table but give error in SQL Server Management 2008 !

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

jojoba20 wrote:

how to use fuzzy object oriented database sql?