hi dharmendr
below is SP
USE [Digimaster]
GO
/****** Object: StoredProcedure [dbo].[Oreder_Insert] Script Date: 10/26/2016 18:58:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[Oreder_Insert]
@State nvarchar(50)
,@City nvarchar(50)
,@Zone nvarchar(50)
,@Name nvarchar(100)
,@Address nvarchar(MAX)
,@PCode varchar(10)
,@Email varchar(100)
,@Mobile varchar(20)
,@Tell varchar(20)
,@PType nvarchar(50)
,@PName nvarchar(100)
,@PostCode varchar(30)
,@PSectionName nvarchar(100)
,@Format varchar(20)
,@OrderType nvarchar(50)
,@Quantity varchar(5)
,@PriceP varchar(5)
,@PriceT varchar(10)
,@PriceTotal varchar(20)
,@PriceTotalBaste varchar(20)
,@PostType nvarchar(50)
AS
BEGIN
INSERT INTO Order_Users
(Name,[State] ,City,Address,PCode,Email ,Mobile ,Tell ,PType ,PostCode,PName,PSectionName
,Format,OrderType ,Quantity ,PriceP ,PriceT ,PriceTotal,PostType,PriceTotalBaste,zone ,[date],Time)
VALUES
(@Name,@State ,@City,@Address,@PCode,@Email ,@Mobile ,@Tell ,@PType ,@PostCode,@PName ,@PSectionName
,@Format,@OrderType ,@Quantity ,@PriceP ,@PriceT ,@PriceTotal ,@PostType,@PriceTotalBaste,@Zone,GETDATE(),SELECT CONVERT(VARCHAR(7),GETDATE(),108) [Time])
END
but this error happen:
Msg 156, Level 15, State 1, Procedure Oreder_Insert, Line 37
Incorrect syntax near the keyword 'SELECT'.
Msg 102, Level 15, State 1, Procedure Oreder_Insert, Line 37
Incorrect syntax near ')'.