19. August 2020
Mehedi
SQL Tips
Technically, SQL Server does not support multiple IDENTITY Columns in a single table. Can we still achieve this? If yes, how?
[More]
19. August 2020
Mehedi
SQL Tips
Let's discuss some more interesting and unusual use of IDENTITY function. Can we use negative value in identity column?
[More]
5. August 2020
Mehedi
SQL Tips
Did you ever wondered how to INSERT values in IDENTITY column or fill the gap of missing value of ID
[More]
29. July 2020
Mehedi
SQL Tips
In my Ranking Function article, I have briefly described about ROW_NUMBER() function. Let's have a p
[More]
28. July 2020
Mehedi
SQL Tips
Explore the all four RANK functions of SQL Server
[More]
16. July 2020
Mehedi
SQL Tips
This article will enlight on how to examine SQL Server Agent job status using T-SQL
[More]
15. July 2020
Mehedi
SQL Tips
Explaining use of SQL CASE statement
[More]
13. July 2020
Mehedi
SQL Tips
In some cases, I used linked server. If you use linked server you might get "Linked Server - Error 7
[More]
13. July 2020
Mehedi
SQL Tips
Use case of SQL Server INFORMATION_SCHEMA Views where your historical data tables are preserved by renaming.
[More]