Viewing 15 posts - 1 through 15 (of 132 total)
like inlinable scalar udfs requiremnts , is there any link which can tell me requiremnts of UDF like this one
March 13, 2024 at 9:58 am
do u want to say that we should not use begin end in inlined scalar functions?
March 11, 2024 at 11:29 am
do u want to say that we should not use begin end in inlined scalar functions?
March 11, 2024 at 10:27 am
the case is one bat file runs at a time. kindly answer in this light.
regarding q1) are u saying sqlcmd when completes, it closes the connection or it keeps the...
December 1, 2023 at 11:16 am
this is how i am calling
xyz.bat this is called from microsoft sheduler. the contenct of .bat is followng.
sqlcmd -S abc -U rr -P xyz -Q "use db EXEC usppp @strSourcedb...
November 22, 2023 at 4:45 am
With one exception, you can switch from one isolation level to another at any time during a transaction. The exception occurs when changing from any isolation level to SNAPSHOT isolation....
June 2, 2023 at 6:07 am
thanks, quite clear, can I get some MSDN links where I can read related to this topic, in detail.
June 1, 2023 at 2:58 pm
My question was something else, kindly help here.
I know about committing and rollback.
yours sincerley
June 1, 2023 at 5:58 am
we do not want to use xml. so pls tell me with out it?
April 12, 2023 at 5:27 am
write , my question is with top n would it work?
here i want the activity name and code of first activiytid? ( activitid is pk)
declare @v varchar(max)='',@v1 varchar(max)=''
select top 1 @v=activityname ,@v1= code...
April 11, 2023 at 11:01 am
insted of first query i wanted to known about second query. so i am rephrasing the question.
here i want the activity name and code of first activiytid?
they did not write...
April 11, 2023 at 10:39 am
please tell me is there anything wrong in first query or should I go for second one or use some with cte etc. etc.
Yours sincerely
April 11, 2023 at 7:35 am
I agree with your point, but it is needed sometimes, so please tell me is there anything wrong in first query or should I go for second one or use...
April 11, 2023 at 7:34 am
this this the orignal query
INSERT INTO [ReportSyncQueue]
([ProjectId]
,[LineloopId]
,[SubSystemId]
,[ActivityHeaderId]
,[ActivityId]
,[TableName]
,[ClassAuditId]
,[Remarks]
,[Status]
,[CreatedDt]
,[UpdatedDt]
,[CDataSource]
,[UDataSource]
,IsSyncMtr
,IsSyncDR
,IsSyncPB
,ReportDt
)
SELECT l.ProjectId, l.LineloopId,AH.SubSystemId,ah.ActivityHeaderId,a.ActivityId,'PipeJoinMethod' AS TabelName
,PJLCA.PipeJoinMethodId1 AS ClassauditId
,null,1,getdate(),getdate(),'HOSO','HOSO'
,0 AS IsSyncMtr
,0 AS IsSyncDr
,1 AS ISSyncPB
,NULL AS ReportDt
FROM
ActivityHeader ah
JOIN WeldingAudit sa ON ah.ActivityHeaderId=sa.ActivityHeaderId AND sa.Status=1
join Activity a...
February 28, 2023 at 11:38 am
I have removed the trigger and indexed views also, but it comes after sometimes.
I have taken permission , i will soon send the code
February 28, 2023 at 10:51 am
Viewing 15 posts - 1 through 15 (of 132 total)