2002-05-01
391 reads
GetPage - paging functionality
All what you need to do is to set the values of a couple of variables; NAME OF the TABLE you want to query (or you can write your own select statement here), NAMES OF COLUMNS you want to display, name of COLUMN for SORTING, define NUMBER OF ROWS on one page, NUMBER OF REQUIRED […]
2002-05-01
356 reads
Detection of Broken Forign Key Relationship
Under special circumstances, it could happen that database contains "orphan" records. Data in dependant table exists without it's "parent" record in a master table. It could be caused by a bulk insert operation without CHECK_CONSTRAINTS option, or by disabling foreign key for a while or adding a foreign key to a table that already contains […]
2002-03-27
183 reads
Blogs
Weekly reading #15
By damianwidera
SQLDay 2019 is gone. The Data Community.PL has now a new goal – it...
Last Weeks Reading (2019-05-26)
By KamilN78
It was tremendously extensive week for me (a week ago) when I spent time...
Migrating SSIS to Azure – Slidedeck (Techorama 2019)
Techorama 2019 is over and it was a blast, as usual. Neatly organised, great...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
Streamlining a Power BI Solution
Comments posted to this topic are about the item Streamlining a Power BI Solution
Proverbial Tree Barking
Hi All, I'm just after a pointer really. I've had an idea. I want...
Ask SSC