• Home
  • Blog
  • About
  • Contact

"platform to share ideas and knowledge about SQL"

Be aware when you use two digit year in date

SQL Basic Raj Leave a Comment

When you execute the below query, as you expect, the result will be “September 26th 2049” Now, Lets see what happen when we pass 50 instead of 49 You will…

Read more »

How to find whether the date is end date of the month in SQL

How to topics Raj Leave a Comment

Working with date is very interesting, I have seen people add too much code to get desired result while it can be achievable with simple logic. Below sample is to…

Read more »

How to find the Date is first day of the Week in SQL

How to topics Raj Leave a Comment

Some time you may need to find the given date is first day of the week or not? here is the code.

Read more »

Recent Posts

  • Additive, non-additive and semi additive facts in data warehouse fact table
  • DROP multiple tables using a single DROP statement
  • How to Convert Seconds to “HH:MM:SS” format in TSQL
  • Synonym in SQL Server
  • Can TRUNCATE be rolled back in SQL Server?

Categories

  • Data warehouse
  • How to topics
  • Index
  • Partition
  • Performance & Troubleshooting
  • quick bite
  • SQL Basic
  • SSIS

Topics

Compression Data warehouse Date DBCC DMV Error Handling Fact How to topics Identity Index JOIN OUTPUT Query Performance ROLLBACK SELECT SQL Server misc SSIS Table Table Partition Table Value Transaction TRUNCATE

Contact Us

  • Email
    contact@intellectSQL.com

Recent Posts

  • Additive, non-additive and semi additive facts in data warehouse fact table
  • DROP multiple tables using a single DROP statement
  • How to Convert Seconds to “HH:MM:SS” format in TSQL
  • Synonym in SQL Server
  • Can TRUNCATE be rolled back in SQL Server?

Site Links

  • About
  • Blog
  • Contact
  • Home
  • MuleSoft
  • Privacy Policy

Contact

  • Email
    contact@intellectSQL.com

RSS blog – feed

  • Additive, non-additive and semi additive facts in data warehouse fact table
  • DROP multiple tables using a single DROP statement
  • How to Convert Seconds to “HH:MM:SS” format in TSQL
  • Synonym in SQL Server
  • Can TRUNCATE be rolled back in SQL Server?

About intellectSQL

intellectSQL is a platform to share ideas and knowledge on SQL Server.

© 2023 intellectSQL
  • Home
  • Blog
  • About
  • Contact