Viewing 15 posts - 16 through 30 (of 132 total)
yes,
kkrMain has one trigger which also inserts in KKR table ( but that one only works in update mode, and I got the error in inserts also)
and one indexed view...
February 27, 2023 at 6:46 am
due to company policy i can not send the stored procudure.
but this is the line which is creating problem. and same line is written many times in the SP with...
February 25, 2023 at 7:03 am
This is the code which is creating the problem (bridgid is bigint ,remaks is varchar(250) status smallint) in both the tables mentioned below.
INSERT INTO KKR (BridgID,Remarks,Status)
SELECT DISTINCT BridgID,Remarks,1
FROM
kkrMain where kkrmainid=23
February 21, 2023 at 6:02 am
1)it is my stored procedure.
2) I debuged my sp and it stated running properly. and after that it was also running properly with same params.
but after sometimes it showed me...
February 20, 2023 at 9:39 am
February 20, 2023 at 6:34 am
informaton schema was taking 0 cpu and 0 time.
February 10, 2023 at 11:23 am
February 9, 2023 at 6:56 am
February 9, 2023 at 6:54 am
i think information schema is better because col_length is a function call and finally it would go to sys.objects or all_objects or information schema it self.
February 9, 2023 at 4:47 am
We do not want to change the script, as there are many stored procedures and functions.
if anything is there at system databases, or server level setting for databases, that would...
December 9, 2022 at 6:08 am
The situation is, the table is small, we do not have indexes or relevant stats, and we want to loop, and there are no joins.
In this situation what would be...
November 30, 2022 at 9:44 am
well , there must be some thumb of rule , i think that can be answered.
November 30, 2022 at 4:57 am
well , there must be thumb of rule , i think that can be answered.
November 30, 2022 at 4:56 am
like [ \t] is used for spaces and tabs, is there anything for finding carriage return in TSQL
ex
where Result =
'Uwon'
October 4, 2022 at 11:06 am
thank u,
on more concern i have used utf8 ,becuase i wanted to use Unicode(multilingual) so i have used Modern_Spanish_100_CI_AS_SC_UTF8
in this I have used SC also I think this combination will...
September 28, 2022 at 4:28 am
Viewing 15 posts - 16 through 30 (of 132 total)