Queries with param

Hey Group

Will this be possible to convert into Access (mdb) Query?

CREATE PROCEDURE sp_TeamAdd
@p_TeamName nvarchar(50),
@p_Notes text,
@p_TeamID_out bigint output,
@p_LeaderName nvarchar(10)
AS

-- Teamname can only exists once in the table
IF NOT EXISTS ( SELECT * FROM [tblTeams] WHERE [TeamName] = @p_TeamName)

BEGIN

DECLARE @v_Created datetime
DECLARE @v_Modified datetime
DECLARE @v_LeaderID bigint

SET @v_Created = getdate()
SET @v_Modified = @v_Created

INSERT INTO [tblTeams]
( [TeamName],
[TeamNotes],
[Created],
[Modified]
)
Values
(
@p_TeamName,
@p_Notes,
@v_Created,
@v_Modified
)

SET @p_TeamID_out = SCOPE_IDENTITY()

IF @p_LeaderName IS NOT NULL
SET @v_LeaderID = ( SELECT TOP 1 [UserID] FROM [tblUsers] WHERE
[UserIdent] = @p_LeaderName )

IF @v_LeaderID IS NOT NULL
UPDATE [tblTeams] SET [FK_TeamLeader] = @v_LeaderID WHERE [TeamID] =
@p_TeamID_out
ELSE
RAISERROR ( 'No Leaders was found.', 16, 1 )

END

Kind regards
Johnny Emde Jensen


.

Relevant Pages

  • Re: Spalten alternativ ansprechen
    ... DECLARE @Monat INT ... '01' AS DATETIME) ... case when DATUM between '...' ... then UMSATZ as ...
    (microsoft.public.de.access.clientserver)
  • Re: a view based on stored procedure
    ... DECLARE @Week_1 DATETIME ... DECLARE @CubeTime DATETIME ... INSERT INTO WrkAvailPlanHours ...
    (microsoft.public.sqlserver.programming)
  • Re: Language problem
    ... @datum datetime ... > Then in application I have settings of my connection: ... > everything else doesn't because all other functions are set to slovenian. ... > DECLARE @dt DATETIME,@datumMesec dateTime,@datumTedenZ datetime,@datumTedenK ...
    (microsoft.public.sqlserver.programming)
  • RE: User Defined Function Help
    ... @startDateTime datetime = null, ... DECLARE @selectFromList varchar ... SET @subservice = RTRIM ... EXEC ...
    (microsoft.public.sqlserver.programming)
  • Re: get time in SQL server
    ... >conversion to datetime data type but could not do it. ... >declare @date2 as datetime ... declare @date1 varchar ...
    (microsoft.public.sqlserver.server)