I mean its as easy for you to use the seach function on CP or google as it is for anyone else to do the search and send you the links. Its generally known as doing your own research, unfortunately it does not seem to be widely practiced judging by the majority of posts on these forums.
i want to implement data versioning in a CMS.
before it I want to realize it's methods and approches
So first decide on what you actually mean. Do you want to know about data versioning in general, or in relation to a specific CMS product. If the latter, then check with the vendor. If it the former, what do you actually want to know, what it means or how to do it.
As I say, nobody can really help as you are not clear in your requirements.
How to unlock a table in sql server 2005? I tried killing the transaction which has a lock on the table by finding the spid through the sp “sp_lock” but still I’m not able to unlock the table.
A simple select query on this table with no “where” clause takes lot of time, resulting in Timeout Expired error. The table structure is also pretty simple with only one clustered index and the table has got only one record.
Please let me know what I can do in this scenario.
Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.
The transaction has to rollback, so that takes as long (or even longer) than the transaction had been running when you killed it. Everything should go back to normal eventually, if not then you may have to restart the sql server instance.
You didn't mention the lock type on the locked row. If there is X lock present, you cannot select from that row (in normal situation). You'll have to wait that the X lock is gone or kill the transaction that's holding the lock (if it's not expected to hold it).
The problem you're facing may be a result of a transaction that isn't ended as it was supposed to (either rollback or commit).
Also you may want to read through the article I wrote.
Here is my issue -
I have a table with 3 date fields. (Entry Date, Pending Date, Accounting Date) -> in my GridView I need to represent this value in 1 column called (Report Date). My rules are if Accounting Date is null use Finalized Date, if Pending date is null use Entry Date. This rule has to work on a row by row basis as I am returning 100's of rows.
Now if this is better done in the code - I can do that also.
Well, depending on whether or not your DBMS supports it, you could use the CASE statement to accomplish this, or you could use a COALESCE method,e.g.
SELECT COALESCE(AccountingDate, PendingDate, EntryDate) AS RuleDate ...
This assumes that one of these columns has a date value in it. Basically, coalesce falls through from one entry to the next until it finds a none-null value. BTW - I'm assuming that you got your logic a bit wrong in your statement and you mean Pending Date and not Finalized Date.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith
Ive got a Small Sql Server DB which Holds 3 Variables that i want To Update But Not Necessarily togther,Meaning: One time i want to update the first two Variables, the other one ill need to update the other 2, which leads me up to 9 options for updating queries..
Now my question is.. is there any way to write 1 query (With Stored Procedure/not) that somehow ,someway "sees" that if no parameter was sent to update , it will use a default value which ill define ?
I hope i explained myself well
thanks alot !
Last Visit: 31-Dec-99 19:00 Last Update: 28-Jan-23 17:48