set ANSI_NULLS ON
set QUOTED_IDENTIFI ER ON
go
-- =============== =============== ===============
-- Author: Lokesh Rao V.L
-- Create date: 18 June 2007
-- Description: Adds, updates LogCompliance details.
-- =============== =============== ===============
ALTER PROCEDURE [dbo].[logLogComplianc eAddUpd]
@loginUserId Int,
@logId Int,
@complianceIds Varchar(4000),
@logComplianceA nswers Varchar(4000),
@createdByIp Varchar(50),
@errNumber Int Output
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SET CONTEXT_INFO @loginUserId;
SET @errNumber = 0
DELETE FROM LogCompliance WHERE LogId = @logId
DECLARE @answer Int, @pos1 Int, @complianceId Int, @pos2 Int
SET @pos1 = CHARINDEX(',' , @logComplianceA nswers , 1)
SET @pos2 = CHARINDEX(',' , @complianceIds , 1)
WHILE @pos1 > 0
BEGIN
SET @answer = Convert(Int,LTR IM(RTRIM(LEFT(@ logComplianceAn swers, @pos1 - 1))))
SET @logComplianceA nswers = RIGHT(@logCompl ianceAnswers, LEN(@logComplia nceAnswers) - @pos1)
SET @complianceId = Convert(Int,LTR IM(RTRIM(LEFT(@ complianceIds, @pos2 - 1))))
SET @complianceIds = RIGHT(@complian ceIds, LEN(@compliance Ids) - @pos2)
SET @pos1 = CHARINDEX(',', @logComplianceA nswers, 1)
SET @pos2 = CHARINDEX(',', @complianceIds, 1)
INSERT INTO [LogCompliance]
(
[ComplianceId]
,[LogId]
,[ComplianceAnswe r]
,[SortOrder]
,[CreatedDate]
,[LastModifiedDat e]
,[CreatedById]
,[LastModifiedByI d]
,[CreatedByIp]
,[LastModifiedByI p]
,[RecordStatusId]
)
VALUES
(
@complianceId,
@logId,
@answer,
0,
getDate(),
getDate(),
@loginUserId,
@loginUserId,
@createdByIp,
@createdByIp,
1
)
END
END
Can I typecast like this and into database?