Format Query Results as JSON with FOR JSON

Learning about FOR JSON

Links and information about the FOR JSON clause in SQL Server 2016.

locating rows with duplicate field values

HI. I have a sql table that has a field that acts as a key but the field was not set up as key. I know there are duplicate values in that field and I want to be able to display the rows where this particular field has been duplicated. Can someone share some sql […]

RE: best way to copy database from one server to another?

hi,i'm a great believer of the saying that one person can make a difference, and i appreciate people like you who by their knowledge and willingness to help make a big difference with a seeming easiness. thank you phil -- thanks to you i successfully restored the file for backup purposes avi