CREATE PROCEDURE [dbo].[Settings_Select]
@pSettingsId Int = NULL
,@pSettingsName NVarChar(MAX) = NULL
AS
BEGIN
SET NOCOUNT ON;
Select
[Settings].[SettingsId],
[Settings].[SettingsName],
[Settings].[SettingsDescription]
from [Settings]
where
(([Settings].[SettingsId] = @pSettingsId ) OR (@pSettingsId IS NULL)) And
(([Settings].[SettingsName] = @pSettingsName ) OR (@pSettingsName IS NULL))
END
Перенашу на 2000 SQL и все хранимки ругаются:
Server: Msg 170, Level 15, State 1, Procedure Settings_Select, Line 9
Line 9: Incorrect syntax near 'MAX'.
Server: Msg 137, Level 15, State 1, Procedure Settings_Select, Line 22
Must declare the variable '@pSettingsName'.
Не знаю, что и делать помогите, а таких хранимок > 200 и приложение. Скрипт генерировался в SMS -> Script for Server Version: SQL Server 2000.
... << RSDN@Home 1.2.0 alpha 4 rev. 1111>>