It's explained in the text you quoted:
"... the system's restart procedure will still record those updates in the database: it is able to discover the values to be written by examining the relevant records in the log."
Tara11 wrote:
Why it would be unreasonable to declare an integrity constraint to that effect?
Mainly because integrity constraint operate on row-basis. Transactions then again ensure that the operation is completed as a whole even when multiple commands are affected. But neither of these guarantee that the total sum is unaffected when money is transferred. If this would be a single table operation, a trigger could be utilized to do that check.
anybody can help me improve the code belowing in order to export rows that department column is '10':
foreach (string s in scripter.EnumScript(new Urn[] { table.Urn }))
{
sb.Append(s);
sb.Append(Environment.NewLine);
}
Have some Google Foo just to make your life richer Difference Between T-SQL and PL-SQL (with Comparison Chart) - Tech Differences[^] And Oracle WANTS TO SHOUT AT YOU.
Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP
You can not do loops in SQL. I have a feeling that what you need is as simple as:
SUM(CASE
WHEN jos.SetupComplete = 0
THEN (((jods.SetupLabRate * jods.CrewSize) * jos.EstSetHours) * (1 - (jos.SetupPctComplete / 100)))
ELSE 0
END) AS SetupLabCost
Otherwise you need to tell us what you're trying to achieve
Wrong is evil and must be defeated. - Jeff Ello
Check your index if the fragmentation is high then re organize it or re index. And If you have index like non cluster or cluster and you changed it or add new index please review.thanks
You cannot use CREATE or ALTER PROCEDURE inside a transaction. But you can cheat, like this:
EXEC ('create procedure dbo.whatever
as
begin
select * from some_table
end')
Wrong is evil and must be defeated. - Jeff Ello
Lots of possible causes for that error: MSSQLSERVER_18456 - SQL Server | Microsoft Docs[^] It sounds like your connection is using Windows authentication instead of SQL authentication. The full error message should give you more details.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
MySQL is an RDBMS. It will be good if first, you will start learning database concepts. After that, you can do many good things for the database using MySQl. Here is one book DataBase Book Please learn the following. 1. What is RDBMS 2. Why Normalization requires. 3. Normal Forms 4. What is SQL and what is PLSql. 5. Do some practice with MySqL
No problem :)
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
