How to Capture Deleted Records
This article shows a few techniques that help in capturing deleted records.
2016-12-19
11,539 reads
DML triggers
Query error ?!!!
Hi every one...I execute this query : SELECT news_content.id_doc AS ID, news.publish_date, news.publish_time, news_content.title, news_content.abstract, news_content.lead, news.image_title, news.image_main, SUM(doc_view_stats.hour_00 + doc_view_stats.hour_01 + doc_view_stats.hour_02 + doc_view_stats.hour_03 + doc_view_stats.hour_04 + doc_view_stats.hour_05 + doc_view_stats.hour_06 + doc_view_stats.hour_07 + doc_view_stats.hour_08 + doc_view_stats.hour_09 + doc_view_stats.hour_10 + doc_view_stats.hour_11 + doc_view_stats.hour_12 + doc_view_stats.hour_13 + doc_view_stats.hour_14 + doc_view_stats.hour_15 + doc_view_stats.hour_16 […]
2004-12-06
4 reads
How to ORDER BY using an @parameter
Is it possible to take in a parameter and use it as the column name or column number in the ORDER BY clause of a SQL statement? I've copied the SP_Columns stored procedure and created a new one from it. I want to specify a sort order as one of the parameters when I run the […]
2004-11-24
3,668 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers