Stored Procedure: SET Ansi - Nulls ON GO SET Quoted - Identifier ON GO

STORED PROCEDURE
-- ================================================
-- Template generated from Template Explorer using:
-- Create Procedure (New Menu).SQL
--
-- Use the Specify Values for Template Parameters
-- command (Ctrl-Shift-M) to fill in the parameter
-- values below.
--
-- This block of comments will not be included in
-- the definition of the procedure.
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE PROCEDURE <Procedure_Name, sysname, ProcedureName>
-- Add the parameters for the stored procedure here
<@Param1, sysname, @p1> <Datatype_For_Param1, , int> = <Default_Value_For_Param1, , 0>,
<@Param2, sysname, @p2> <Datatype_For_Param2, , int> = <Default_Value_For_Param2, , 0>
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here

SELECT <@Param1, sysname, @p1>, <@Param2, sysname, @p2>
END
GO
CREATE PROCEDURE EMPISERTION

(@empid INT)
AS
BEGIN
SET NOCOUNT ON;

if (@empid > 3)
SELECT * from EMPLOYEE where EMP_ID = @empid
Else
PRINT 'NO RECORD FOUND'
END
CREATE PROCEDURE EMPISERTION
(@empid INT)
AS
DECLARE
@tem INT;
BEGIN
SET NOCOUNT ON;

if (@empid > 3)
begin
SELECT @tem = EMP_Name from EMPLOYEE where EMP_ID = @empid;
PRINT @tem;
end
Else
begin
end
END
ALTER PROCEDURE
[dbo].[EMPINSERTION]
(@empid INT)
AS
BEGIN
SET NOCOUNT ON;

if (@empid > 3)
SELECT * from EMPLOYEE where EMP_ID = @empid
Else
END
CREATE PROCEDURE [dbo].[Validate_User]

@Username NVARCHAR(256),
@Password NVARCHAR(2000)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @UserId INT, @LastLoginDate DATETIME
SELECT @UserId = UserId, @LastLoginDate = LastLoginDate

FROM Users WHERE Username = @Username AND [Password] = @Password
IF @UserId IS NOT NULL

BEGIN
IF NOT EXISTS(SELECT UserId FROM UserActivation WHERE UserId = @UserId)
BEGIN
UPDATE Users
SET LastLoginDate = GETDATE()
WHERE UserId = @UserId
SELECT @UserId [UserId] -- User Valid
END
ELSE
BEGIN
SELECT -2 -- User not activated.
END
END
ELSE
BEGIN
SELECT -1 -- User invalid.
END
END
USE [AE]
GO
/****** Object: StoredProcedure [dbo].[sp_INSERT_VENDOR] Script Date: 1/8/2019
10:53:55 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[sp_INSERT_VENDOR] @Vendor_Title nvarchar(MAX),
@Vendor_Organisation nvarchar(50),
@Vendor_Country nvarchar(50), @Vendor_City nvarchar(50), @Vendor_Address1 nvarchar(MAX),
@Vendor_Address2 nvarchar(MAX),
@Vendor_Phone1 bigint, @Vendor_Phone2 bigint,@Id int,@Vendor_Email1
nvarchar(50),@Vendor_Email2 nvarchar(50)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here

INSERT INTO [dbo].[Vendor]
([Vendor_Title]
,[Vendor_Organisation]
,[Vendor_Country]
,[Vendor_City]
,[Vendor_Address1]
,[Vendor_Address2]
,[Vendor_Phone1]
,[Vendor_Phone2]
,[Id]
,Vendor_Email1
,Vendor_Email2)
VALUES
(@Vendor_Title
,@Vendor_Organisation
,@Vendor_Country
,@Vendor_City
,@Vendor_Address1
,@Vendor_Address2
,@Vendor_Phone1
,@Vendor_Phone2
,@Id
,@Vendor_Email1
,@Vendor_Email2)
SELECT SCOPE_IDENTITY()
END
<connectionStrings>
<add name="DefaultConnection" connectionString=" Data
Source=ZSKHAN\SQLEXPRESS;Initial Catalog=ADEMO1;Integrated
Security=True;AttachDbFilename=|DataDirectory|\aspnet-Engineers-84c088c5-51ec-4594-9c2d-
acbdd24210fc.mdf;Integrated Security=SSPI" providerName="System.Data.SqlClient" />
</connectionStrings>
public string GetConnectionString()

{
return
System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].Connecti
onString;
//sets the connection string from your web config file "ConnString" is the name
of your Connection String
private void InsertInfo()

{
Int64 VendorID =0;
SqlConnection conn = new SqlConnection(GetConnectionString());
aa = Convert.ToInt16(Session["UId"]);
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("sp_INSERT_VENDOR", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Vendor_Title", TextBox1.Text);
cmd.Parameters.AddWithValue("@Vendor_Organisation", TextBox2.Text);
cmd.Parameters.AddWithValue("@Vendor_Country", TextBox3.Text);
cmd.Parameters.AddWithValue("@Vendor_City", TextBox4.Text);
cmd.Parameters.AddWithValue("@Vendor_Address1", TextBox5.Text);
cmd.Parameters.AddWithValue("@Vendor_Address2", TextBox6.Text);
cmd.Parameters.AddWithValue("@Vendor_Phone1", TextBox7.Text);
cmd.Parameters.AddWithValue("@Vendor_Phone2", TextBox8.Text);
cmd.Parameters.AddWithValue("@Id", aa);
cmd.Parameters.AddWithValue("@Vendor_Email1", TextBox9.Text);
cmd.Parameters.AddWithValue("@Vendor_Email2", TextBox10.Text);
// cmd.CommandType = CommandType.Text;
VendorID = Convert.ToInt64(cmd.ExecuteScalar());
cmd.Dispose();
insert_product(VendorID);
}
catch (System.Data.SqlClient.SqlException ex)
{
string msg = "Insert Error:";
msg += ex.Message;
throw new Exception(msg);
}
finally
{
conn.Close();
}

Stored Procedure: SET Ansi - Nulls ON GO SET Quoted - Identifier ON GO

Uploaded by

Copyright:

Available Formats

Stored Procedure: SET Ansi - Nulls ON GO SET Quoted - Identifier ON GO

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Stored Procedure: SET Ansi - Nulls ON GO SET Quoted - Identifier ON GO

Uploaded by

Copyright:

Available Formats

STORED PROCEDURE

-- Insert statements for procedure here

CREATE PROCEDURE EMPISERTION

SET NOCOUNT ON;

SET NOCOUNT ON;

SET NOCOUNT ON;

CREATE PROCEDURE [dbo].[Validate_User]

SELECT @UserId = UserId, @LastLoginDate = LastLoginDate

IF @UserId IS NOT NULL

-- Insert statements for procedure here

public string GetConnectionString()

private void InsertInfo()

You might also like