Salve a tutti , ho creato uno script di un intero database da sql 2008 a 2000 ,
ma in quest'ultimo si presenta un errore di sintassi quando vado poi a caricarlo .
Queste le stringhe imputate e l'errore di slq; Se qualcuno sapesse come correggerlo , Grazie ))
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
GO
/****** Object: View [dbo].[Gens_Varnert] Script Date: 12/30/2017 02:22:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[Gens_Varnert]
AS
SELECT TOP (100) PERCENT Row_Number() OVER (ORDER BY Contribution DESC, Name ASC) AS Rank, Name, Family, Contribution
FROM dbo.Gens_Rank
WHERE (Family = '2')
ORDER BY Contribution DESC, Name ASC
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
Server: Msg 170, Level 15, State 1, Procedure Gens_Varnert, Line 3
Line 3: Incorrect syntax near '('.