Problème de connexion à une SGBD SQL Server en PHP

23 avr. 2013, 13:06

Bonjour,

J'espère ne pas m'être trompée de section pour poster.

J'ai une base de données créer sous SQL Server 2012 en local. J'essaie de me connecter à la base de données en php, j'ai essayé plusieurs codes trouvés sur internet mais cela ne fonctionne pas.

J'ai essayé avec un objet PDO, avec mssql et OBDC et j'ai toujours un message d'erreur de driver pour mssql et PDO pourtant j'ai rajouter les drivers demandés sous wamp.
Pour OBDC j'utilise le code ci dessous pour me connecter à la base mais il doit y avoir un problème d'identification car cela ne fonctionne pas.

<?php

$username="PC-de-lafamille\la famille";
$password="";
$bd="Animal"; # non de la base de donnees

$sqlconnect=odbc_connect("DRIVER={SQL Server};SERVER=PC-DE-LAFAMILLE;DATABASE=$bd", $username, $password);
$sqlquery="SELECT * FROM ANIMAL;";
$process=odbc_exec($sqlconnect, $sqlquery);

while(odbc_fetch_row($process)){
$identifiant= odbc_result($process,"identifiant");
echo "$identifiant<br>"; }
odbc_close($sqlconnect);

?>

Ma base de données est sous SQL Server en local et mon authentification de sql est basé sur celle de windows et je n'ai pas de mot de passe.

Merci d'avance car je suis perdue.

23 avr. 2013, 15:09

Tu disposes toujours du code création avec lequel t'as crée ta base de données, ses tables ainsi que de ses champs ?

23 avr. 2013, 15:30

Merci d'avoir répondu.

Oui je dispose toujours du script.

23 avr. 2013, 16:14

Je pense que Marouane est à même de vérifier tes paramètres de connexion à partir de script.

Juste, un détail :
$username="PC-de-lafamille\\la famille";
(on ne sait jamais...)

23 avr. 2013, 19:46

Voila mon script complet (je ne voyais pas de moyen de vous joindre le fichier directement)

USE [Animal]
GO
/****** Object:  StoredProcedure [dbo].[ModificationAnimal]    Script Date: 23/04/2013 15:28:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[ModificationAnimal] 
	-- Add the parameters for the stored procedure here
	 @idFamille int,@idOrdre int, @idTypeMenace int, @idRegne int, @idGenre int, @idClasse int,
	@nomAnimal varchar(50), @image varchar(100), @date varchar(30), @nbIndividu bigint , @resume text
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	UPDATE ANIMAL
	SET  [ID_FAMILLE] = @idFamille, [ID_ORDRE] = @idOrdre,
	[ID_TYPE_MENACE] = @idTypeMenace, [ID_REGNE] = @idRegne, [ID_GENRE] = @idGenre,
	[ID_CLASSE] = @idClasse,[NOM_ANIMAL] = @nomAnimal, [IMAGE_ANIMAL] = @image, [DATE_EXTINCTION] = @date,
	[NB_INDIVIDUS_RESTANTS] = @nbIndividu, [RESUME] = @resume
	WHERE [NOM_ANIMAL] = @nomAnimal
END


GO
/****** Object:  StoredProcedure [dbo].[supressionAnimal]    Script Date: 23/04/2013 15:28:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[supressionAnimal] 
	-- Add the parameters for the stored procedure here
	@NOMANIMAL varchar(50)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	DELETE FROM ANIMAL 
	WHERE NOM_ANIMAL=@NOMANIMAL
END


GO
/****** Object:  Table [dbo].[ANIMAL]    Script Date: 23/04/2013 15:28:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ANIMAL](
	[ID_ANIMAL] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
	[ID_FAMILLE] [numeric](18, 0) NOT NULL,
	[ID_ORDRE] [numeric](18, 0) NOT NULL,
	[ID_TYPE_MENACE] [numeric](18, 0) NOT NULL,
	[ID_REGNE] [numeric](18, 0) NOT NULL,
	[ID_GENRE] [numeric](18, 0) NOT NULL,
	[ID_CLASSE] [numeric](18, 0) NOT NULL,
	[NOM_ANIMAL] [varchar](50) NOT NULL,
	[IMAGE_ANIMAL] [varchar](100) NOT NULL,
	[DATE_EXTINCTION] [varchar](30) NULL,
	[NB_INDIVIDUS_RESTANTS] [bigint] NULL,
	[RESUME] [text] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[CLASSE]    Script Date: 23/04/2013 15:28:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CLASSE](
	[ID_CLASSE] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
	[INTITULE_CLASSE] [varchar](50) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[FAMILLE]    Script Date: 23/04/2013 15:28:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FAMILLE](
	[ID_FAMILLE] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
	[INTITULE_FAMILLE] [varchar](50) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[GENRE]    Script Date: 23/04/2013 15:28:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[GENRE](
	[ID_GENRE] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
	[INTITULE_GENRE] [varchar](50) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ORDRE]    Script Date: 23/04/2013 15:28:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ORDRE](
	[ID_ORDRE] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
	[INTITULE_ORDRE] [varchar](50) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[REGNE]    Script Date: 23/04/2013 15:28:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[REGNE](
	[ID_REGNE] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
	[INTITULE_REGNE] [varchar](50) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[TYPE_MENACE]    Script Date: 23/04/2013 15:28:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TYPE_MENACE](
	[ID_TYPE_MENACE] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
	[INTITULE_TYPE_MENACE] [varchar](50) NOT NULL,
	[CODE_TYPE_MENACE] [varchar](2) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[ANIMAL] ON 

INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(1 AS Numeric(18, 0)), CAST(130 AS Numeric(18, 0)), CAST(46 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), CAST(4 AS Numeric(18, 0)), N'Dodo', N'\Animal\Dodo.png', N'Fin du 17ème siècle', 0, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(2 AS Numeric(18, 0)), CAST(91 AS Numeric(18, 0)), CAST(28 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(35 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), N'Auroch', N'\Animal\Auroch.png', N'Dernier spécimen en 1627', 0, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(3 AS Numeric(18, 0)), CAST(114 AS Numeric(18, 0)), CAST(45 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(5 AS Numeric(18, 0)), CAST(16 AS Numeric(18, 0)), N'Grand Pingouin', N'\Animal\grandpingouin.png', N'Milieu du 19ème siècle', 0, N'Test ')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(4 AS Numeric(18, 0)), CAST(2 AS Numeric(18, 0)), CAST(28 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(55 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), N'Hippopotamus Lemerlei', N'\Animal\hippopotame-nain.png', N'Il y a 500 ans environ', 0, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(5 AS Numeric(18, 0)), CAST(79 AS Numeric(18, 0)), CAST(22 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(21 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), N'Lion du Cap', N'\Animal\lionducap.png', N'1865', 0, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(6 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), CAST(53 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(56 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), N'Parameles eremiana', N'\Animal\Perameles_big.png', N'Dernier spécimen en 1943', 0, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(7 AS Numeric(18, 0)), CAST(4 AS Numeric(18, 0)), CAST(29 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(57 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), N'Rhinocéros de Java', N'\Animal\rhinocerosdejava.png', N'', 40, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(8 AS Numeric(18, 0)), CAST(5 AS Numeric(18, 0)), CAST(54 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(58 AS Numeric(18, 0)), CAST(6 AS Numeric(18, 0)), N'Anguille d''Europe', N'\Animal\anguilledeurope.png', N'', NULL, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(9 AS Numeric(18, 0)), CAST(6 AS Numeric(18, 0)), CAST(52 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(59 AS Numeric(18, 0)), CAST(16 AS Numeric(18, 0)), N'Bulbul du Libéria', N'\Animal\bulbulduliberia.png', N'', NULL, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(10 AS Numeric(18, 0)), CAST(7 AS Numeric(18, 0)), CAST(55 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(60 AS Numeric(18, 0)), CAST(16 AS Numeric(18, 0)), N'Cacatoès des Philippines', N'\Animal\cacatoesdesphilippines.png', N'', 4000, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(17 AS Numeric(18, 0)), CAST(92 AS Numeric(18, 0)), CAST(29 AS Numeric(18, 0)), CAST(4 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(64 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), N'Cheval de Przewalski', N'\Animal\chevaldeprzewalski.png', N'', 1800, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(19 AS Numeric(18, 0)), CAST(10 AS Numeric(18, 0)), CAST(59 AS Numeric(18, 0)), CAST(4 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(64 AS Numeric(18, 0)), CAST(16 AS Numeric(18, 0)), N'Albatros de l''Océan Indien', N'\Animal\albatrosoceanindien.png', N'', NULL, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(20 AS Numeric(18, 0)), CAST(60 AS Numeric(18, 0)), CAST(14 AS Numeric(18, 0)), CAST(4 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(41 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), N'Babina okinavana', N'\Animal\abinaokinavana.png', N'', NULL, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(21 AS Numeric(18, 0)), CAST(76 AS Numeric(18, 0)), CAST(22 AS Numeric(18, 0)), CAST(4 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(52 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), N'Panda géant', N'\Animal\pandageant.png', N'', 2000, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(22 AS Numeric(18, 0)), CAST(92 AS Numeric(18, 0)), CAST(29 AS Numeric(18, 0)), CAST(5 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(71 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), N'Zèbre de Hartmann', N'\Animal\zebrehartmann.png', N'', 60000, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(23 AS Numeric(18, 0)), CAST(97 AS Numeric(18, 0)), CAST(60 AS Numeric(18, 0)), CAST(5 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(67 AS Numeric(18, 0)), CAST(4 AS Numeric(18, 0)), N'Aigle impérial', N'\Animal\Aigle impérial.png', N'', NULL, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(24 AS Numeric(18, 0)), CAST(11 AS Numeric(18, 0)), CAST(61 AS Numeric(18, 0)), CAST(5 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(68 AS Numeric(18, 0)), CAST(17 AS Numeric(18, 0)), N'Hippocampus Erectus', N'\Animal\hippocampuserectus.png', N'', NULL, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(25 AS Numeric(18, 0)), CAST(79 AS Numeric(18, 0)), CAST(22 AS Numeric(18, 0)), CAST(5 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(69 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), N'Panthère nébuleuse', N'\Animal\pantherenebuleuse.png', N'', 10000, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(26 AS Numeric(18, 0)), CAST(12 AS Numeric(18, 0)), CAST(62 AS Numeric(18, 0)), CAST(5 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(70 AS Numeric(18, 0)), CAST(5 AS Numeric(18, 0)), N'Requin-baleine', N'\Animal\requinbaleine.png', N'', NULL, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(28 AS Numeric(18, 0)), CAST(68 AS Numeric(18, 0)), CAST(63 AS Numeric(18, 0)), CAST(6 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(72 AS Numeric(18, 0)), CAST(7 AS Numeric(18, 0)), N'Tortue d''Hermann', N'\Animal\tortuehermann.png', N'', NULL, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(29 AS Numeric(18, 0)), CAST(91 AS Numeric(18, 0)), CAST(28 AS Numeric(18, 0)), CAST(6 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(73 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), N'Bison américain', N'\Animal\bisonamericain.png', N'', 80000, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(30 AS Numeric(18, 0)), CAST(79 AS Numeric(18, 0)), CAST(22 AS Numeric(18, 0)), CAST(6 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(21 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), N'Jaguar', N'\Animal\jaguar.png', N'', NULL, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(31 AS Numeric(18, 0)), CAST(13 AS Numeric(18, 0)), CAST(24 AS Numeric(18, 0)), CAST(6 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(74 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), N'Maki Catta', N'\Animal\lemur.png', N'', NULL, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(32 AS Numeric(18, 0)), CAST(14 AS Numeric(18, 0)), CAST(64 AS Numeric(18, 0)), CAST(6 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(75 AS Numeric(18, 0)), CAST(5 AS Numeric(18, 0)), N'Requin-tigre', N'\Animal\requintigre.png', N'', NULL, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(33 AS Numeric(18, 0)), CAST(15 AS Numeric(18, 0)), CAST(22 AS Numeric(18, 0)), CAST(7 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(76 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), N'Léopard des mers', N'\Animal\leoparddesmers.png', N'', 300000, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(34 AS Numeric(18, 0)), CAST(80 AS Numeric(18, 0)), CAST(22 AS Numeric(18, 0)), CAST(7 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(77 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), N'Raton laveur', N'\Animal\ratonlaveur.png', N'', NULL, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(36 AS Numeric(18, 0)), CAST(16 AS Numeric(18, 0)), CAST(24 AS Numeric(18, 0)), CAST(7 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(78 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), N'Galago à queue touffue', N'\Animal\galago.png', N'', NULL, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(37 AS Numeric(18, 0)), CAST(117 AS Numeric(18, 0)), CAST(52 AS Numeric(18, 0)), CAST(7 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(79 AS Numeric(18, 0)), CAST(16 AS Numeric(18, 0)), N'Alouette à ailes rousses', N'\Animal\alouette.png', N'', NULL, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(38 AS Numeric(18, 0)), CAST(18 AS Numeric(18, 0)), CAST(55 AS Numeric(18, 0)), CAST(7 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(80 AS Numeric(18, 0)), CAST(16 AS Numeric(18, 0)), N'Ara rouge', N'\Animal\ararouge.png', N'', NULL, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(39 AS Numeric(18, 0)), CAST(2 AS Numeric(18, 0)), CAST(2 AS Numeric(18, 0)), CAST(2 AS Numeric(18, 0)), CAST(2 AS Numeric(18, 0)), CAST(2 AS Numeric(18, 0)), CAST(2 AS Numeric(18, 0)), N'Baleine à bec pygmée', N'grdsgsgdgsdg', N'dgdfdfqfs', 25, N'fsdfqfbhqsghfsgyf')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(40 AS Numeric(18, 0)), CAST(85 AS Numeric(18, 0)), CAST(67 AS Numeric(18, 0)), CAST(8 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(82 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), N'Gerbille occidentale', N'\Animal\gerbille.png', N'', NULL, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(11 AS Numeric(18, 0)), CAST(79 AS Numeric(18, 0)), CAST(22 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(53 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), N'Guépard asiatique', N'\Animal\guepardasiatique.png', N'', NULL, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(12 AS Numeric(18, 0)), CAST(91 AS Numeric(18, 0)), CAST(56 AS Numeric(18, 0)), CAST(2 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(23 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), N'Oryx Algazelle', N'\Animal\oryxalgazelle.png', N'', NULL, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(13 AS Numeric(18, 0)), CAST(79 AS Numeric(18, 0)), CAST(22 AS Numeric(18, 0)), CAST(2 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(21 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), N'Lion de l''Atlas', N'\Animal\liondelatlas.png', N'', 36, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(14 AS Numeric(18, 0)), CAST(109 AS Numeric(18, 0)), CAST(46 AS Numeric(18, 0)), CAST(2 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(27 AS Numeric(18, 0)), CAST(4 AS Numeric(18, 0)), N'Tourterelle de Socorro', N'\Animal\tourterelledesocorro.png', N'', NULL, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(15 AS Numeric(18, 0)), CAST(90 AS Numeric(18, 0)), CAST(28 AS Numeric(18, 0)), CAST(2 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(16 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), N'Cerf du père David', N'\Animal\cerfduperedavid.png', N'', 3500, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(16 AS Numeric(18, 0)), CAST(8 AS Numeric(18, 0)), CAST(57 AS Numeric(18, 0)), CAST(2 AS Numeric(18, 0)), CAST(2 AS Numeric(18, 0)), CAST(63 AS Numeric(18, 0)), CAST(10 AS Numeric(18, 0)), N'Partula rosea', N'\Animal\partularosea.png', N'', NULL, N'Test')
INSERT [dbo].[ANIMAL] ([ID_ANIMAL], [ID_FAMILLE], [ID_ORDRE], [ID_TYPE_MENACE], [ID_REGNE], [ID_GENRE], [ID_CLASSE], [NOM_ANIMAL], [IMAGE_ANIMAL], [DATE_EXTINCTION], [NB_INDIVIDUS_RESTANTS], [RESUME]) VALUES (CAST(18 AS Numeric(18, 0)), CAST(9 AS Numeric(18, 0)), CAST(58 AS Numeric(18, 0)), CAST(4 AS Numeric(18, 0)), CAST(1 AS Numeric(18, 0)), CAST(65 AS Numeric(18, 0)), CAST(3 AS Numeric(18, 0)), N'Eléphant d''Asie', N'\Animal\elephantasie.png', N'', 50000, N'Test')
SET IDENTITY_INSERT [dbo].[ANIMAL] OFF
SET IDENTITY_INSERT [dbo].[CLASSE] ON 

INSERT [dbo].[CLASSE] ([ID_CLASSE], [INTITULE_CLASSE]) VALUES (CAST(1 AS Numeric(18, 0)), N'Amphibien')
INSERT [dbo].[CLASSE] ([ID_CLASSE], [INTITULE_CLASSE]) VALUES (CAST(2 AS Numeric(18, 0)), N'Crocodilien')
INSERT [dbo].[CLASSE] ([ID_CLASSE], [INTITULE_CLASSE]) VALUES (CAST(3 AS Numeric(18, 0)), N'Mammifère')
INSERT [dbo].[CLASSE] ([ID_CLASSE], [INTITULE_CLASSE]) VALUES (CAST(4 AS Numeric(18, 0)), N'Oiseau')
INSERT [dbo].[CLASSE] ([ID_CLASSE], [INTITULE_CLASSE]) VALUES (CAST(5 AS Numeric(18, 0)), N'Poisson')
INSERT [dbo].[CLASSE] ([ID_CLASSE], [INTITULE_CLASSE]) VALUES (CAST(6 AS Numeric(18, 0)), N'Serpent et lézard')
INSERT [dbo].[CLASSE] ([ID_CLASSE], [INTITULE_CLASSE]) VALUES (CAST(7 AS Numeric(18, 0)), N'Tortue')
INSERT [dbo].[CLASSE] ([ID_CLASSE], [INTITULE_CLASSE]) VALUES (CAST(8 AS Numeric(18, 0)), N'Bivalve')
INSERT [dbo].[CLASSE] ([ID_CLASSE], [INTITULE_CLASSE]) VALUES (CAST(9 AS Numeric(18, 0)), N'Céphalopode')
INSERT [dbo].[CLASSE] ([ID_CLASSE], [INTITULE_CLASSE]) VALUES (CAST(10 AS Numeric(18, 0)), N'Gastéropode')
INSERT [dbo].[CLASSE] ([ID_CLASSE], [INTITULE_CLASSE]) VALUES (CAST(11 AS Numeric(18, 0)), N'Arachnide')
INSERT [dbo].[CLASSE] ([ID_CLASSE], [INTITULE_CLASSE]) VALUES (CAST(12 AS Numeric(18, 0)), N'Crustacé')
INSERT [dbo].[CLASSE] ([ID_CLASSE], [INTITULE_CLASSE]) VALUES (CAST(13 AS Numeric(18, 0)), N'Insecte')
INSERT [dbo].[CLASSE] ([ID_CLASSE], [INTITULE_CLASSE]) VALUES (CAST(14 AS Numeric(18, 0)), N'Myriapope')
INSERT [dbo].[CLASSE] ([ID_CLASSE], [INTITULE_CLASSE]) VALUES (CAST(16 AS Numeric(18, 0)), N'Aves')
INSERT [dbo].[CLASSE] ([ID_CLASSE], [INTITULE_CLASSE]) VALUES (CAST(17 AS Numeric(18, 0)), N'Actinopterygii')
SET IDENTITY_INSERT [dbo].[CLASSE] OFF
SET IDENTITY_INSERT [dbo].[FAMILLE] ON 

INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(2 AS Numeric(18, 0)), N'Hippopotamidae')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(3 AS Numeric(18, 0)), N'Peramelidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(4 AS Numeric(18, 0)), N'Rhinocerotidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(5 AS Numeric(18, 0)), N'Anguillidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(6 AS Numeric(18, 0)), N'Pycnonotidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(7 AS Numeric(18, 0)), N'Cacatuidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(8 AS Numeric(18, 0)), N'Partulidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(9 AS Numeric(18, 0)), N'Elephantidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(10 AS Numeric(18, 0)), N'Diomedeidae')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(11 AS Numeric(18, 0)), N'Syngnathidae')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(12 AS Numeric(18, 0)), N'Rhincodontidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(13 AS Numeric(18, 0)), N'Lemuridés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(14 AS Numeric(18, 0)), N'Carcharhinidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(15 AS Numeric(18, 0)), N'Phocidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(16 AS Numeric(18, 0)), N'Galagonidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(17 AS Numeric(18, 0)), N'Alaudidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(18 AS Numeric(18, 0)), N'Psittacidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(19 AS Numeric(18, 0)), N'Ziphiidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(20 AS Numeric(18, 0)), N'Elapidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(55 AS Numeric(18, 0)), N'Iulidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(56 AS Numeric(18, 0)), N'Salmonidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(57 AS Numeric(18, 0)), N'Cyprinidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(58 AS Numeric(18, 0)), N'Salamandridés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(59 AS Numeric(18, 0)), N'Bufonidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(60 AS Numeric(18, 0)), N'Ranidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(61 AS Numeric(18, 0)), N'Hylidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(62 AS Numeric(18, 0)), N'
Lacertidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(63 AS Numeric(18, 0)), N'Geckonidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(64 AS Numeric(18, 0)), N'Anguidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(65 AS Numeric(18, 0)), N'Scincidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(66 AS Numeric(18, 0)), N'Colubridés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(67 AS Numeric(18, 0)), N'Vipéridés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(68 AS Numeric(18, 0)), N'Testudidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(69 AS Numeric(18, 0)), N'Erinacéidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(70 AS Numeric(18, 0)), N'Talpidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(71 AS Numeric(18, 0)), N'Soricidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(72 AS Numeric(18, 0)), N'Molossidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(73 AS Numeric(18, 0)), N'Rhinolophidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(74 AS Numeric(18, 0)), N'Vespertilionidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(75 AS Numeric(18, 0)), N'Canidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(76 AS Numeric(18, 0)), N'Ursidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(77 AS Numeric(18, 0)), N'Mustélidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(78 AS Numeric(18, 0)), N'Viverridés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(79 AS Numeric(18, 0)), N'Félidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(80 AS Numeric(18, 0)), N'Procyonidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(81 AS Numeric(18, 0)), N'Sciuridés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(82 AS Numeric(18, 0)), N'Castoridés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(83 AS Numeric(18, 0)), N'Gliridés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(84 AS Numeric(18, 0)), N'Arvicolidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(85 AS Numeric(18, 0)), N'Muridés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(86 AS Numeric(18, 0)), N'Myocastoridés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(87 AS Numeric(18, 0)), N'Hystricidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(88 AS Numeric(18, 0)), N'Léporidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(89 AS Numeric(18, 0)), N'Suidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(90 AS Numeric(18, 0)), N'Cervidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(91 AS Numeric(18, 0)), N'Bovidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(92 AS Numeric(18, 0)), N'Équidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(93 AS Numeric(18, 0)), N'Phalocrocoracidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(94 AS Numeric(18, 0)), N'Ardéidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(95 AS Numeric(18, 0)), N'Ciconiidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(96 AS Numeric(18, 0)), N'Anatidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(97 AS Numeric(18, 0)), N'Accipitridés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(98 AS Numeric(18, 0)), N'Falconidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(99 AS Numeric(18, 0)), N'Tétraonidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(100 AS Numeric(18, 0)), N'Phasianidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(101 AS Numeric(18, 0)), N'Numinidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(102 AS Numeric(18, 0)), N'Méléagridés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(103 AS Numeric(18, 0)), N'Rallidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(104 AS Numeric(18, 0)), N'Charadriidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(105 AS Numeric(18, 0)), N'Laridés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(106 AS Numeric(18, 0)), N'Recurvirostridés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(107 AS Numeric(18, 0)), N'Scolopacidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(108 AS Numeric(18, 0)), N'Sternidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(109 AS Numeric(18, 0)), N'Columbidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(110 AS Numeric(18, 0)), N'Cuculidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(111 AS Numeric(18, 0)), N'Tytonidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(112 AS Numeric(18, 0)), N'Strigidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(113 AS Numeric(18, 0)), N'Apodidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(114 AS Numeric(18, 0)), N'Alcélinidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(115 AS Numeric(18, 0)), N'Upupidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(116 AS Numeric(18, 0)), N'Picidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(117 AS Numeric(18, 0)), N'Alaudidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(118 AS Numeric(18, 0)), N'Cinclidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(119 AS Numeric(18, 0)), N'Turdidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(120 AS Numeric(18, 0)), N'Fringillidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(121 AS Numeric(18, 0)), N'Motacillidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(122 AS Numeric(18, 0)), N'Lanidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(123 AS Numeric(18, 0)), N'Paridés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(124 AS Numeric(18, 0)), N'Corvidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(125 AS Numeric(18, 0)), N'Sturnidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(126 AS Numeric(18, 0)), N'Passéridés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(127 AS Numeric(18, 0)), N'Prunellidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(128 AS Numeric(18, 0)), N'Sylviidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(129 AS Numeric(18, 0)), N'Trichodromadidés')
INSERT [dbo].[FAMILLE] ([ID_FAMILLE], [INTITULE_FAMILLE]) VALUES (CAST(130 AS Numeric(18, 0)), N'Raphidés')
SET IDENTITY_INSERT [dbo].[FAMILLE] OFF
SET IDENTITY_INSERT [dbo].[GENRE] ON 

INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(1 AS Numeric(18, 0)), N'Amblysomus')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(2 AS Numeric(18, 0)), N'Lipotes')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(3 AS Numeric(18, 0)), N'Raphus')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(4 AS Numeric(18, 0)), N'Bos')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(5 AS Numeric(18, 0)), N'Pinguinus')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(6 AS Numeric(18, 0)), N'Conuropsis')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(7 AS Numeric(18, 0)), N'Thylacinus')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(8 AS Numeric(18, 0)), N'Mammuthus')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(9 AS Numeric(18, 0)), N'Heteralocha')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(10 AS Numeric(18, 0)), N'Xenicus')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(11 AS Numeric(18, 0)), N'Ectopistes')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(12 AS Numeric(18, 0)), N'Hydrodamalis')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(13 AS Numeric(18, 0)), N'Pezophap')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(14 AS Numeric(18, 0)), N'Aylacostoma')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(15 AS Numeric(18, 0)), N'Betula')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(16 AS Numeric(18, 0)), N'Elaphurus')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(17 AS Numeric(18, 0)), N'Corvus')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(18 AS Numeric(18, 0)), N'Cyanea')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(19 AS Numeric(18, 0)), N'Cyprinodon')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(20 AS Numeric(18, 0)), N'Mitu')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(21 AS Numeric(18, 0)), N'Panthera')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(22 AS Numeric(18, 0)), N'Nilssonia')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(23 AS Numeric(18, 0)), N'Oryx')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(24 AS Numeric(18, 0)), N'Partula')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(25 AS Numeric(18, 0)), N'Gallirallus')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(26 AS Numeric(18, 0)), N'Sophora')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(27 AS Numeric(18, 0)), N'Zenaida')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(28 AS Numeric(18, 0)), N'Addax')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(29 AS Numeric(18, 0)), N'Boninthemis')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(30 AS Numeric(18, 0)), N'Anthracoceros')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(31 AS Numeric(18, 0)), N'Dendrotriton')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(32 AS Numeric(18, 0)), N'Himantopus')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(33 AS Numeric(18, 0)), N'Gazella')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(34 AS Numeric(18, 0)), N'Incilius')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(35 AS Numeric(18, 0)), N'Bos')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(36 AS Numeric(18, 0)), N'Chondrohierax')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(37 AS Numeric(18, 0)), N'Oxylapia')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(38 AS Numeric(18, 0)), N'Puma')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(39 AS Numeric(18, 0)), N'Diceros')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(40 AS Numeric(18, 0)), N'Thalassarche')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(41 AS Numeric(18, 0)), N'Babina')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(42 AS Numeric(18, 0)), N'Crotaphytus')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(43 AS Numeric(18, 0)), N'Dasyornis')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(44 AS Numeric(18, 0)), N'Glaucis')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(45 AS Numeric(18, 0)), N'Hippoglossus')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(46 AS Numeric(18, 0)), N'Hylobates')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(47 AS Numeric(18, 0)), N'Huso')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(48 AS Numeric(18, 0)), N'Iguana')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(49 AS Numeric(18, 0)), N'Apteryx')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(50 AS Numeric(18, 0)), N'Neophoca')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(51 AS Numeric(18, 0)), N'Spheniscus')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(52 AS Numeric(18, 0)), N'Ailuropoda')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(53 AS Numeric(18, 0)), N'Acinonyx')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(54 AS Numeric(18, 0)), N'Ambystoma')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(55 AS Numeric(18, 0)), N'Hippopotamus')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(56 AS Numeric(18, 0)), N'Parameles')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(57 AS Numeric(18, 0)), N'Rhinoceros')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(58 AS Numeric(18, 0)), N'Anguilla')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(59 AS Numeric(18, 0)), N'Phyllastrephus')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(60 AS Numeric(18, 0)), N'Cacatua')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(61 AS Numeric(18, 0)), N'Zenaida')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(62 AS Numeric(18, 0)), N'Elaphurus')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(63 AS Numeric(18, 0)), N'Partula')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(64 AS Numeric(18, 0)), N'Thalassarche')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(65 AS Numeric(18, 0)), N'Elephas')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(66 AS Numeric(18, 0)), N'Ailuropoda')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(67 AS Numeric(18, 0)), N'Aquila')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(68 AS Numeric(18, 0)), N'Hippocampus')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(69 AS Numeric(18, 0)), N'Neofelis')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(70 AS Numeric(18, 0)), N'Rhincodon')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(71 AS Numeric(18, 0)), N'Equus')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(72 AS Numeric(18, 0)), N'Testudo')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(73 AS Numeric(18, 0)), N'Bison')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(74 AS Numeric(18, 0)), N'Lemur')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(75 AS Numeric(18, 0)), N'Galeocerdo')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(76 AS Numeric(18, 0)), N'Hydrurga')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(77 AS Numeric(18, 0)), N'Procyon')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(78 AS Numeric(18, 0)), N'Otolemur')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(79 AS Numeric(18, 0)), N'Mirafra')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(80 AS Numeric(18, 0)), N'Ara')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(81 AS Numeric(18, 0)), N'Mesoplodon')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(82 AS Numeric(18, 0)), N'Gerbillus')
INSERT [dbo].[GENRE] ([ID_GENRE], [INTITULE_GENRE]) VALUES (CAST(83 AS Numeric(18, 0)), N'Naja')
SET IDENTITY_INSERT [dbo].[GENRE] OFF
SET IDENTITY_INSERT [dbo].[ORDRE] ON 

INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(1 AS Numeric(18, 0)), N'Isopodes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(2 AS Numeric(18, 0)), N'Décapodes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(3 AS Numeric(18, 0)), N'Odonates')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(4 AS Numeric(18, 0)), N'Dictyoptères')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(5 AS Numeric(18, 0)), N'Orthoptères')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(6 AS Numeric(18, 0)), N'Hémiptères')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(7 AS Numeric(18, 0)), N'Diptères')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(8 AS Numeric(18, 0)), N'Hyménoptères')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(9 AS Numeric(18, 0)), N'Coléoptères')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(10 AS Numeric(18, 0)), N'Lépidoptères')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(11 AS Numeric(18, 0)), N'Salmoniformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(12 AS Numeric(18, 0)), N'Cypriniformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(13 AS Numeric(18, 0)), N'Urodèles')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(14 AS Numeric(18, 0)), N'Anoures')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(15 AS Numeric(18, 0)), N'sauriens')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(16 AS Numeric(18, 0)), N'Ophidiens')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(17 AS Numeric(18, 0)), N'Chéloniens')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(18 AS Numeric(18, 0)), N'Insectivores')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(19 AS Numeric(18, 0)), N'Chiroptères')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(20 AS Numeric(18, 0)), N'Dermoptères')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(21 AS Numeric(18, 0)), N'Hyracoïdes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(22 AS Numeric(18, 0)), N'Carnivores')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(23 AS Numeric(18, 0)), N'Pinnipèdes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(24 AS Numeric(18, 0)), N'Primates')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(25 AS Numeric(18, 0)), N'Rongeurs')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(26 AS Numeric(18, 0)), N'Macroscélidés')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(27 AS Numeric(18, 0)), N'Lagomorphes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(28 AS Numeric(18, 0)), N'Artiodactyles')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(29 AS Numeric(18, 0)), N'Périssodactyles')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(30 AS Numeric(18, 0)), N'Cétacés')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(31 AS Numeric(18, 0)), N'Monotrèmes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(32 AS Numeric(18, 0)), N'Pholidotes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(33 AS Numeric(18, 0)), N'Proboscidiens')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(34 AS Numeric(18, 0)), N'Scandencia')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(35 AS Numeric(18, 0)), N'Siréniens')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(36 AS Numeric(18, 0)), N'Tubulidentés')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(37 AS Numeric(18, 0)), N'Xénarthres')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(38 AS Numeric(18, 0)), N'Pélécaniformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(39 AS Numeric(18, 0)), N'Ciconiiformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(40 AS Numeric(18, 0)), N'Phoenicoptériformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(41 AS Numeric(18, 0)), N'Ansériformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(42 AS Numeric(18, 0)), N'Falconiformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(43 AS Numeric(18, 0)), N'Galliformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(44 AS Numeric(18, 0)), N'Gruiformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(45 AS Numeric(18, 0)), N'Charadriiformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(46 AS Numeric(18, 0)), N'Columbiformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(47 AS Numeric(18, 0)), N'Cuculiformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(48 AS Numeric(18, 0)), N'Strigiformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(49 AS Numeric(18, 0)), N'Apodiformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(50 AS Numeric(18, 0)), N'Coraciiformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(51 AS Numeric(18, 0)), N'Piciformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(52 AS Numeric(18, 0)), N'Passériformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(53 AS Numeric(18, 0)), N'Marsupialia')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(54 AS Numeric(18, 0)), N'Anguilliformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(55 AS Numeric(18, 0)), N'Psittaciformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(56 AS Numeric(18, 0)), N'Cetartiodactyla')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(57 AS Numeric(18, 0)), N'Stylommatophora')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(58 AS Numeric(18, 0)), N'Proboscidés')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(59 AS Numeric(18, 0)), N'Procellariiformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(60 AS Numeric(18, 0)), N'Accipitriformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(61 AS Numeric(18, 0)), N'Syngnathiformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(62 AS Numeric(18, 0)), N'Orectolobiformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(63 AS Numeric(18, 0)), N'Testudines')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(64 AS Numeric(18, 0)), N'Carcharhiniformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(65 AS Numeric(18, 0)), N'Passeriformes')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(66 AS Numeric(18, 0)), N'Cetacea')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(67 AS Numeric(18, 0)), N'Rodentia')
INSERT [dbo].[ORDRE] ([ID_ORDRE], [INTITULE_ORDRE]) VALUES (CAST(68 AS Numeric(18, 0)), N'Squamata')
SET IDENTITY_INSERT [dbo].[ORDRE] OFF
SET IDENTITY_INSERT [dbo].[REGNE] ON 

INSERT [dbo].[REGNE] ([ID_REGNE], [INTITULE_REGNE]) VALUES (CAST(1 AS Numeric(18, 0)), N'Vertébré')
INSERT [dbo].[REGNE] ([ID_REGNE], [INTITULE_REGNE]) VALUES (CAST(2 AS Numeric(18, 0)), N'Mollusque')
INSERT [dbo].[REGNE] ([ID_REGNE], [INTITULE_REGNE]) VALUES (CAST(3 AS Numeric(18, 0)), N'Arthropode')
SET IDENTITY_INSERT [dbo].[REGNE] OFF
SET IDENTITY_INSERT [dbo].[TYPE_MENACE] ON 

INSERT [dbo].[TYPE_MENACE] ([ID_TYPE_MENACE], [INTITULE_TYPE_MENACE], [CODE_TYPE_MENACE]) VALUES (CAST(1 AS Numeric(18, 0)), N'Eteint', N'EX')
INSERT [dbo].[TYPE_MENACE] ([ID_TYPE_MENACE], [INTITULE_TYPE_MENACE], [CODE_TYPE_MENACE]) VALUES (CAST(2 AS Numeric(18, 0)), N'Eteint à l''état sauvage', N'EW')
INSERT [dbo].[TYPE_MENACE] ([ID_TYPE_MENACE], [INTITULE_TYPE_MENACE], [CODE_TYPE_MENACE]) VALUES (CAST(3 AS Numeric(18, 0)), N'Danger critique d''extinction', N'CR')
INSERT [dbo].[TYPE_MENACE] ([ID_TYPE_MENACE], [INTITULE_TYPE_MENACE], [CODE_TYPE_MENACE]) VALUES (CAST(4 AS Numeric(18, 0)), N'Espèce en danger', N'EN')
INSERT [dbo].[TYPE_MENACE] ([ID_TYPE_MENACE], [INTITULE_TYPE_MENACE], [CODE_TYPE_MENACE]) VALUES (CAST(5 AS Numeric(18, 0)), N'Espèce vulnérable', N'VU')
INSERT [dbo].[TYPE_MENACE] ([ID_TYPE_MENACE], [INTITULE_TYPE_MENACE], [CODE_TYPE_MENACE]) VALUES (CAST(6 AS Numeric(18, 0)), N'Espèce quasi menacée', N'NT')
INSERT [dbo].[TYPE_MENACE] ([ID_TYPE_MENACE], [INTITULE_TYPE_MENACE], [CODE_TYPE_MENACE]) VALUES (CAST(7 AS Numeric(18, 0)), N'Préoccupation mineure', N'LC')
INSERT [dbo].[TYPE_MENACE] ([ID_TYPE_MENACE], [INTITULE_TYPE_MENACE], [CODE_TYPE_MENACE]) VALUES (CAST(8 AS Numeric(18, 0)), N'Données Insuffisantes', N'DD')
SET IDENTITY_INSERT [dbo].[TYPE_MENACE] OFF
/****** Object:  Index [PK_ANIMAL]    Script Date: 23/04/2013 15:28:03 ******/
ALTER TABLE [dbo].[ANIMAL] ADD  CONSTRAINT [PK_ANIMAL] PRIMARY KEY NONCLUSTERED 
(
	[ID_ANIMAL] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [PK_CLASSE]    Script Date: 23/04/2013 15:28:03 ******/
ALTER TABLE [dbo].[CLASSE] ADD  CONSTRAINT [PK_CLASSE] PRIMARY KEY NONCLUSTERED 
(
	[ID_CLASSE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [PK_FAMILLE]    Script Date: 23/04/2013 15:28:03 ******/
ALTER TABLE [dbo].[FAMILLE] ADD  CONSTRAINT [PK_FAMILLE] PRIMARY KEY NONCLUSTERED 
(
	[ID_FAMILLE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [PK_GENRE]    Script Date: 23/04/2013 15:28:03 ******/
ALTER TABLE [dbo].[GENRE] ADD  CONSTRAINT [PK_GENRE] PRIMARY KEY NONCLUSTERED 
(
	[ID_GENRE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [PK_ORDRE]    Script Date: 23/04/2013 15:28:03 ******/
ALTER TABLE [dbo].[ORDRE] ADD  CONSTRAINT [PK_ORDRE] PRIMARY KEY NONCLUSTERED 
(
	[ID_ORDRE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [PK_REGNE]    Script Date: 23/04/2013 15:28:03 ******/
ALTER TABLE [dbo].[REGNE] ADD  CONSTRAINT [PK_REGNE] PRIMARY KEY NONCLUSTERED 
(
	[ID_REGNE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [PK_TYPE_MENACE]    Script Date: 23/04/2013 15:28:03 ******/
ALTER TABLE [dbo].[TYPE_MENACE] ADD  CONSTRAINT [PK_TYPE_MENACE] PRIMARY KEY NONCLUSTERED 
(
	[ID_TYPE_MENACE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ANIMAL]  WITH CHECK ADD  CONSTRAINT [FK_ANIMAL_FAMILLE] FOREIGN KEY([ID_FAMILLE])
REFERENCES [dbo].[FAMILLE] ([ID_FAMILLE])
GO
ALTER TABLE [dbo].[ANIMAL] CHECK CONSTRAINT [FK_ANIMAL_FAMILLE]
GO
ALTER TABLE [dbo].[ANIMAL]  WITH CHECK ADD  CONSTRAINT [FK_ANIMAL_GENRE] FOREIGN KEY([ID_GENRE])
REFERENCES [dbo].[GENRE] ([ID_GENRE])
GO
ALTER TABLE [dbo].[ANIMAL] CHECK CONSTRAINT [FK_ANIMAL_GENRE]
GO
ALTER TABLE [dbo].[ANIMAL]  WITH CHECK ADD  CONSTRAINT [FK_ANIMAL_ORDRE] FOREIGN KEY([ID_ORDRE])
REFERENCES [dbo].[ORDRE] ([ID_ORDRE])
GO
ALTER TABLE [dbo].[ANIMAL] CHECK CONSTRAINT [FK_ANIMAL_ORDRE]
GO
ALTER TABLE [dbo].[ANIMAL]  WITH CHECK ADD  CONSTRAINT [FK_ANIMAL_REGNE] FOREIGN KEY([ID_REGNE])
REFERENCES [dbo].[REGNE] ([ID_REGNE])
GO
ALTER TABLE [dbo].[ANIMAL] CHECK CONSTRAINT [FK_ANIMAL_REGNE]
GO
ALTER TABLE [dbo].[ANIMAL]  WITH CHECK ADD  CONSTRAINT [FK_ANIMAL_TYPE_MENACE] FOREIGN KEY([ID_TYPE_MENACE])
REFERENCES [dbo].[TYPE_MENACE] ([ID_TYPE_MENACE])
GO
ALTER TABLE [dbo].[ANIMAL] CHECK CONSTRAINT [FK_ANIMAL_TYPE_MENACE]
GO

Problème de connexion à une SGBD SQL Server en PHP

Qui est en ligne