Files
DP44/DataPRO_sql/dbo.sp_TestEngineerDetailsGet.StoredProcedure.sql

65 lines
2.0 KiB
MySQL
Raw Permalink Normal View History

2026-04-17 14:55:32 -04:00
<EFBFBD><EFBFBD>IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_TestEngineerDetailsGet]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_TestEngineerDetailsGet]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_TestEngineerDetailsGet]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_TestEngineerDetailsGet] AS'
END
GO
ALTER PROCEDURE [dbo].[sp_TestEngineerDetailsGet]
@Name nvarchar(255) = null
AS
BEGIN
SET NOCOUNT ON;
declare @EngineerId int
set @EngineerId = dbo.foo_IdGetEngineer(@Name)
SELECT [Name]
,[TestEngineerName]
,[TestEngineerPhone]
,[TestEngineerFax]
,[TestEngineerEmail]
,[LocalOnly]
,[LastModified]
,[LastModifiedBy]
,[Version]
FROM [dbo].[TestEngineerDetails] where @Name is null or [TestEngineerId] = @EngineerId
END
GO