TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Thulasiram pakala
906
872
116.4k
convertion nvarchar to numaric error please
Apr 28 2021 3:35 AM
in this Ounsumer id i got convertion nvarchar to numaric error please any body help
Alter
Procedure
[dbo].[Proc_ConsumermasterInsert1]
(@DCM_DeptName nvarchar(100),
@DCM_Address
varchar
(200),
@DCM_MobileNumber
varchar
(20),
@DCM_CEOName
varchar
(50),
@DCM_EmailID
varchar
(50),
@DCM_DeptDescription
varchar
(200),
@DCM_AddedBy
int
,
@DCM_AddedIPAddress
varchar
(50),
@DCM_Remarks
varchar
(50),
@DCM_Abbrivation
char
(5),
@DCM_CategoryAgencyId
int
,
@DCM_ContactPersonName
varchar
(100),
@DCM_ContactPersonMobileNumber
varchar
(15),
@DCM_ContactPersonEmailID
varchar
(50),
@DCM_ContactPersonLandLineNumber
varchar
(20)
)
as
begin
DECLARE
@consumerid nvarchar(20)
Declare
@
output
nvarchar(
max
)
BEGIN
TRANSACTION
;
insert
into
[dbo].[DataConsumerMaster] (DCM_DeptName, DCM_Address, DCM_MobileNumber, DCM_CEOName, DCM_EmailID, DCM_DeptDescription,
DCM_DataConsumer, DCM_AddedOn, DCM_AddedBy, DCM_AddedIPAddress, DCM_Status,DCM_Remarks,DCM_EntryMode, DCM_Abbrivation,DCM_CategoryAgencyId,
DCM_ContactPersonName,DCM_ContactPersonMobileNumber,DCM_ContactPersonEmailID,DCM_ContactPersonLandLineNumber)
values
(@DCM_DeptName, @DCM_Address, @DCM_MobileNumber, @DCM_CEOName, @DCM_EmailID, @DCM_DeptDescription,
'A'
, getdate(), @DCM_AddedBy, @DCM_AddedIPAddress,
'A'
,@DCM_Remarks,
'D'
,@DCM_Abbrivation,@DCM_CategoryAgencyId,
@DCM_ContactPersonName,@DCM_ContactPersonMobileNumber,@DCM_ContactPersonEmailID,@DCM_ContactPersonLandLineNumber)
Select
@consumerid=
'CM00'
+ SCOPE_IDENTITY()
--IF EXISTS (SELECT DCM_ConsumerID FROM [DataConsumerMaster] WHERE DCM_DeptName =@DCM_DeptName)
--Then
if(@@ROWCOUNT>0)
--SET @output=
--PRINT convert(varchar(30), @output)
--RETURN @output
Insert
into
Login88(
Password
,UserName,Officer_Name,Officer_Mobile,Email_ID,Type_Of_User,Status,Date_of_Creation,created_by,Date_of_Modification,Roles)
Values
(
'ov2FeiYRwvE='
,
Convert
(nvarchar(50), @consumerid) ,@DCM_CEOName,@DCM_MobileNumber,@DCM_EmailID,4,
'Approved'
,
''
,@DCM_AddedBy,
''
,
'C'
)
Commit
TRANSACTION
;
END
Reply
Answers (
2
)
scope identity want to add 'CM00'
How to Export store procedure create alter statement query