Use multiple statements in if condition SQL Server

eshant.k...

SOLVED CLOSED ACTIVE ANSWERED
User: eshant.kapoor.5
Posted: on May 16, 2015 11:05 PM
Forum: SQL Server
Answer: 1
Views: 2646

Hi , i want to insert value into table in stored procedure and return true or false based n condition

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE spx_CheckUserAvailability
      @UserName VARCHAR(50)
AS
BEGIN
      SET NOCOUNT ON;
      IF NOT EXISTS
            (SELECT * FROM Users
             WHERE UserName = @UserName
            )
            SELECT 'true'
      ELSE
            SELECT 'false'
END
GO

If output is true then it insert into user table as username into users table and then return true else false

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 1

Reply
ANSWER
User: Mudassar
Replied: on May 16, 2015 11:06 PM
Modified: on May 16, 2015 11:06 PM
Report

This way

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE spx_CheckUserAvailability
      @UserName VARCHAR(50)
AS
BEGIN
      SET NOCOUNT ON;
      IF NOT EXISTS
            (SELECT * FROM Users
             WHERE UserName = @UserName
            )
      BEGIN
            
            --WRITE INSERT QUERY HERE
	    SELECT 'true'
      END
      ELSE
            SELECT 'false'
END

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Use multiple statements in if condition SQL Server

Company

Explore

Follow us

Contact Us