Script pour test
Transact-SQL
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
/****** Script de la commande SelectTopNRows à partir de SSMS ******/ SELECT TOP (1000) [Marque] ,[Modele] ,[Couleur] ,[Annee] FROM [datasets].[dbo].[VoituresSample] ORDER BY NEWID() USE [datasets] GO /****** Object: Table [dbo].[VoituresSample] Script Date: 04/02/2018 14:51:28 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[VoituresSample]( ID INT IDENTITY PRIMARY KEY CLUSTERED, [Marque] [varchar](10) NULL, [Modele] [varchar](33) NULL, [Couleur] [varchar](30) NULL, [Annee] [varchar](4) NULL ) ON [PRIMARY] GO TRUNCATE TABLE VoituresSample INSERT VoituresSample SELECT Marque,Modele,Couleur,Annee FROM dbo.VoituresModelesAnnees VMA TABLESAMPLE (10 PERCENT) WHERE Couleur IN ('Bleu','Rouge','Vert','Noir','Blanc','Argent','Jaune','Gris','Violet') ORDER BY NEWID() SELECT * FROM VoituresSample WHERE ID >= 101 AND ID <=119 |