DotNet By Ajay — New: ES2025 cheat-sheet is live!

March 13, 2021

SELECT COUNT(*) + COUNT(*)

 - COUNT always returns an int data type value.

 - COUNT(*) returns the number of items in a group. This includes NULL values and duplicates.

October 14, 2020

What is name of text editor in window to type your SQL queries?


    If you want to edit only SQL Queries. Then you can use in-built editor like "Notepad". There is no specific SQL Query editor pre installed in window OS.

    There is many SQL Editor's are available now days. But I prefer to use "SQL Server Management Studio (SSMS) Query Editor" to edit quires.


    September 17, 2020

    FastStone Capture Full Serial Key

    Registration Code
    Name              : www.xyraclius.com
    Serial              : OOCRYIMDMDPWRETFPSUZ

    September 13, 2020

    OOP's Interview Question: What is OOP in C#?

    Here i am discussing about, "OOP's related inter question's are asked up to fresher level".

    September 7, 2020

    SQL Interview Question: How to create another table using existing table?

    Here i am discussing about, "How to create another table using existing table?" or "How to create Duplicate table in SQL Server?". There is a simple SQL Query to create duplicate table. I have tried and tested. Hope this work for you-