Interview Query – 1

Somewhere on internet i found this question. Thought to share it with you all.
We have two tables,  school_students and Class_student.

2018-09-17 (first published: )

2,450 reads

Starting with MS SQL Server

In one of my previous blog (https://sqldose.wordpress.com/2015/10/20/a-basic-introduction-of-database-tables-and-sql/ ) I gave a basic introduction about what is A Database and what is...


523 reads

Non-Clustered Index

In my previous blog I explained about clustered index (https://sqldose.wordpress.com/2015/09/20/clustered-index-and-related-interview-questions/ ).
Considering that we are versed with the concept of heap,...


377 reads


Beginning T-SQL and Career Roadmap for Women (and Men)! #SQLSatBR


Download session materials and watch the recordings of my excellent sessions on Transact-SQL and...

Actual Kubernetes


This post continues looking at my process of learning more about Kubernetes. I’ve been...

New product: Azure Data Share


A brand new product by Microsoft called Azure Data Share was recently announced. It...

Read the latest Blogs


How to make in memory SQL transformations within a data flow task

By svenflock

Hi all, first of all, I am new to Integration Services. I googled everything...

CAST FOR XML - Illegal Name Character

By jamie_collins

I am trying to write a query that generates an html report to be...

Get the inactive records in sqlserver

By kbhanu15

HI Team, please help to get the expected data. my Data like below: create...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers