External Article

On Comparing Tables in SQL Server

  • Article

How do you compare two SQL tables? Every SQL Developer or DBA knows the answer, which is 'it depends'. It is not just the size of the table or the type of data in it but what you want to achieve. Phil Factor sets about to cover the basics and point out some snags and advantages to the various techniques.


5,867 reads

Technical Article

How to generate SQL DML

  • Topic

I have this peculiar request. We have a library which all developers use to connect to the Production databases. During the course of their interaction with the DB, any Update or Delete statement requires me to take the current state of the Row(s) based on the where clause from the Update/Delete statement and generate all […]


1 reads

Technical Article

RE: Attached and Detached

  • Reply

If you have SQL Servers list in the database you may run a query that will get a servername from the database, append strings before and after and output in the results window a set of statements like this:SELECT * FROM OPENROWSET('SQLOLEDB','Provider=SQLOLEDB;Server=MyServerName123;Trusted_Connection=yes','select @@servername, <put here everything you want to select according to postings above')Then copy […]


Technical Article

Datetime grouping question

  • Topic

I am writing a report and the users and they would like to select the grouping of the report.All the grouping will be on a single datetime field (oddly enough named datetime).They would like to be able to choose if the report is grouped by half hour, day, week, or month.I can accomplish day by […]


1 reads

Technical Article

RE: SQL Login Security

  • Reply

If your users are connecting through an application server you can put the SQL Server behind a firewall and just allow access through the firewall to the app server IP address, thus denying enyone else access.



Encrypting Your SQL Data Should be Your Default Option


Cyber-attacks and data breaches seem to be perpetually on the rise. Every week we...

Power BI Embedded: Using Row-Level Security for Multilingual Reports


Making multilingual reports in Power BI requires a lot of different elements. Translations can...

Daily Coping 29 Nov 2022


Today’s coping tip is to make a meal using a recipe or ingredient you’ve...

Read the latest Blogs


Sql table join help

By SQL Bee

I have 2 tables . tblStudentMarksOriginal - StudID, Subject, Marks 101, english, 91 101,...

Why do Sql Server In operator behaves differently and return nothing?

By mehmood

I am using sql server 2017. I am trying to use the in operator,...

Basic Checks on a New AWS RDS SQL Server

By Br. Kenneth Igiri

Comments posted to this topic are about the item Basic Checks on a New...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers