Viewing 15 posts - 2,131 through 2,145 (of 2,857 total)
That is true. I suppose then it all depends on what you define as a "sequence". If having the "Sequence ID" reset itself is a common occurrence, AND if resetting...
June 24, 2019 at 8:44 pm
To avoid the "0" and negative problem, change it from using the sequence number to using the event record ID. In the example you have above, it looks like that...
June 14, 2019 at 9:52 pm
I think it depends on what you want in the app. If you are looking for an app that will load a web page in a specialized frame that prevents...
June 14, 2019 at 9:09 pm
You could try turning on the legacy cardinality estimator. It'll almost be like running it without doing the upgrade unfortunately, but might be able to narrow things down a bit.
Since...
June 13, 2019 at 9:40 pm
My opinion, that is one of those "it depends" problems. Is the timeout in code execution OR is the timeout in the connection?
If the timeout is in code execution, do...
June 12, 2019 at 7:33 pm
I think in this case "best" is a relative term.
There are several ways to do it. long character separated string values, key value pairs, very wide tables with non-descript column...
June 12, 2019 at 7:22 pm
It depends entirely on the language you are working with. As this is SQL Server Central, I am assuming you are working in SQL Server.
The way I would do this...
June 7, 2019 at 7:31 pm
As a thought... I wonder if MAYBE the user is a member of a group that has deny permissions on a system object but you also granted the permissions explicitly.
What...
June 6, 2019 at 5:21 pm
We use it to transfer realtime data from one system to another. Mostly as a way to break reliance on linked servers where possible.
We pull data from system X into...
May 31, 2019 at 9:54 pm
how about this:
CAST(xmldata.value('(ns8:date)[1]','DATETIMEOFFSET') AS DATE) AS RDATEBasically get the value in it's original format (DATETIMEOFFSET) and then cast that to a DATE.
May 31, 2019 at 9:15 pm
Putting in the restriction on delete isn't a bad idea, but depending on the permissions the user is granted, it may not be enough. what if they drop that trigger? ...
May 24, 2019 at 6:16 pm
I should add that there is a little bit of risk with SQL injection depending on what is in the code.
For example, the Query that is being executed is:
May 24, 2019 at 3:51 pm
This may not be the most elegant solution, but I believe it should work for you. Just need to un-comment the EXEC(@SQLCMD) line:
DECLARE @SQLCMD VARCHAR(MAX) = '';
DECLARE...
May 23, 2019 at 8:55 pm
Quick fix:
In the line "SET @SQLQuery", try casting your @intID to an NVARCHAR(255).
EDIT - re-read your post and I see you tried this already. Is it giving the same error...
May 23, 2019 at 3:20 pm
Viewing 15 posts - 2,131 through 2,145 (of 2,857 total)