2002-05-01
394 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
362 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
Daily Coping 7 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Publish ADF from code to further environments
By Kamil
Struggling with #ADF deployment? adf_publish branch doesn’t suit your purposes? Don’t have skills with PowerShell? I have good...
Getting the Proc Code–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
JSON - What am I doing wrong
Hi, So I'm having a little play with JSON as I need to store...
Using azcopy to copy files
Im trying to copy the contents of my sql server backup .bak files to...
How to efficiently perform search on my DB and Word documents on my server?
So I'm building a system for a client and they want to have a...
Ask SSC