PHPfrance

la communauté d'entraide francophone dédiée au PHP

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

Répondre


Cette question est un moyen d’empêcher des soumissions automatisées de formulaires par des robots.
Smileys
:D :) :( :o :shock: :? 8-) :lol: :x :P :oops: :cry: :evil: :twisted: :roll: :wink: :!: :?: :idea: :arrow: :| :mrgreen: =D> #-o =P~ :^o :non: :priere: 8-|
Voir plus de smileys
  Revue du sujet
 

  Étendre la vue Revue du sujet : Problème de connexion à une SGBD SQL Server en PHP

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

par debounette » 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

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

par Mazarini » 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...)

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

par debounette » 23 avr. 2013, 15:30

Merci d'avoir répondu.

Oui je dispose toujours du script.

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

par marouane91 » 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 ?

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

par debounette » 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.