Error Log

Technical Article

RE: Trigger not firing

  • Reply

While doing some more research and testing I discovered some interesting fact. If I change the order of the tables in my view definition the trigger works. So instead of from (select fnc.id fnc_id,fnc.name fnc_name,lst.* from us_functions fnc, us_lists lst where lst.list_type = 1) lst left join us_list_values liv on liv.lst_id = lst.id and liv.fnc_id […]

You rated this post out of 5. Change rating

2003-06-27

Technical Article

RE: MS SQL Server 2000 vs Oracle

  • Reply

Hi The biggest ive seen to date hosted in oracle is a 450Gb beast. The size is one thing, but really high throughput db's and massive numbers of users is another. Ive seen a case sometime back for a smart card system that needed to process 10000 requests per sec during peak times from realtime […]

You rated this post out of 5. Change rating

2003-06-25

1 reads

Technical Article

RE: Rounding Problem

  • Reply

Not answering the question, but the concept is too cool! May be my inexperience, but I've not seen a numbering system like this before. Is there an official name for this. Twelvish?

You rated this post out of 5. Change rating

2003-06-20

1 reads

Blogs

Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox

By

Are you ready to take your SQL skills from theoretical to tactical? If you've...

Set a Runtime Variable in an Azure DevOps Pipeline

By

Note: I DO NOT recommend this. Any changes to a pipeline should be in...

A New Word: Symptomania

By

symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers