set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author: Lokesh Rao V.L
-- Create date: 18 June 2007
-- Description: Adds, updates LogCompliance details.
-- =============================================
ALTER PROCEDURE [dbo].[logLogComplianceAddUpd]
@loginUserId Int,
@logId Int,
@complianceIds Varchar(4000),
@logComplianceAnswers 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(',' , @logComplianceAnswers , 1)
SET @pos2 = CHARINDEX(',' , @complianceIds , 1)
WHILE @pos1 > 0
BEGIN
SET @answer = Convert(Int,LTRIM(RTRIM(LEFT(@logComplianceAnswers , @pos1 - 1))))
SET @logComplianceAnswers = RIGHT(@logComplianceAnswers, LEN(@logComplianceAnswers) - @pos1)
SET @complianceId = Convert(Int,LTRIM(RTRIM(LEFT(@complianceIds, @pos2 - 1))))
SET @complianceIds = RIGHT(@complianceIds, LEN(@complianceIds) - @pos2)
SET @pos1 = CHARINDEX(',', @logComplianceAnswers, 1)
SET @pos2 = CHARINDEX(',', @complianceIds, 1)
INSERT INTO [LogCompliance]
(
[ComplianceId]
,[LogId]
,[ComplianceAnswer]
,[SortOrder]
,[CreatedDate]
,[LastModifiedDate]
,[CreatedById]
,[LastModifiedById]
,[CreatedByIp]
,[LastModifiedByIp]
,[RecordStatusId]
)
VALUES
(
@complianceId,
@logId,
@answer,
0,
getDate(),
getDate(),
@loginUserId,
@loginUserId,
@createdByIp,
@createdByIp,
1
)
END
END
Can I typecast like this and into database?