Learn With Sundar

Get Started

  • Difference between CURRENT_TIMESTAMP vs GETDATE() vs SYSDATETIME() vs GETUTCDATE() in SQL Server

    Introduction In this article, we will discuss the difference between CURRENT_TIMESTAMP , GETDATE() , SYSDATETIME() GETUTCDATE() in SQL Server. Even though all four SQL Server function returns the current date-time in SQL Server, there are some subtle differences between them. The main difference between GETDATE() and SYSDATETIME() is that GETDATE returns current date and time…

  • Change Schema Name Of Table In MS SQL Server

    Introduction In this article we will learn the trick to Move a Table from One Schema to Another Schema. Sometimes accidentally we might have given the incorrect name of a schema for the table while creating. But we can move the newly created table from one schema to another schema. Syntax Example Here Details is…

  • What is Blazor and How does it works

    Introduction In this article, we will discuss about the amazing technology called Blazor. Personally after working on this amazing technology, it increased my development works so much productive and interesting. In this article, we will cover the overall features of Blazor like as, What is Blazor Why should we use Blazor Getting started with Blazor…

  • 5 Tips to Improve SQL Query Performance

    Introduction In this article, I will share few SQL Tips for Boosting our SQL Query Performance. We nobody likes delay in response, right !!. Here are some simple changes that we have to make our query perform faster. The following is the flow of this write-up, Use Schema Name Always Select ONLY required Columns Use…

  • Identifying object dependencies in SQL Server using SP_DEPENDS

    Introduction When developing components for SQL Server one change may affect another database object.  Finding these dependent objects should be straightforward, but in most cases it is not as easy as we would think. There are several methods of getting this information, in this article we will have a look using SP_DEPENDS a System Stored Procedure.…

  • Select Names Starting With Vowels in MS SQL Server

    Introduction Sometime we may need to select the column results that the string starts with Vowels. In this article, We will have a look, How to select the columns results starting with Vowels. Example As an example, we have a StudentDetails table, first lets select all the results from the table. The above query’s result…

Subscribe

Enter your email below to receive updates.