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 […]

5 (1)

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 […]

5 (1)

2002-03-27

183 reads

Blogs

Daily Coping 7 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Publish ADF from code to further environments

By

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

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

JSON - What am I doing wrong

By NicHopper

Hi, So I'm having a little play with JSON as I need to store...

Using azcopy to copy files

By garryha

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?

By umeshamin

So I'm building a system for a client and they want to have a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers