Learn With Sundar

Get Started

  • Find Table Creation Date In SQL Server

    Introduction In this article, we will discuss how to get the created date of a table. Sometimes, we may need to know when the table was created in the particular database. Rather than relying on the row inserted date, we can see when the table was created. Finding the Created date using T-SQL This T-SQL…

  • List All Available Time Zone – SQL Server

    Introduction In this simple tips and tricks article, I would like to share how many time zones does our SQL Server supports. Well, it’s pretty much easy to find by using the system table sys.time_zone_info sys.time_zone_info Here is the sample T-SQL to get the list of time zones our SQL Server supports. is_currently_dst – This column…

  • DAX Basics in Power BI

    Introduction In Power BI, we can do a limited amount of calculations using Power Query Editor, but that is not enough to perform. For that we have DAX. DAX means Data Analysis Expression is an inbuild function which is the formula language that is used by Power BI. DAX is developed by Microsoft to interact…

  • To Get Total Number of Columns In a Table In SQL Server

    Introduction In this simple article, lets explore to get total number of columns in a table in SQL Server Example From the INFORMATION_SCHEMA.COLUMNS table we can find the number of columns in a table. TABLE_CATALOG – We need to pass the database name TABLE_SCHEMA – We need to pass the schema name TABLE_NAME – The…

  • sp_rename – Rename a column or table in MS SQL Server

    Introduction In this article, I would like to share how to rename a column name or table name in SQL Server using T-SQL. For that, we have to use sp_rename. sp_rename renames the objects in the current database. Renaming column name to new column name The syntax for renaming a column in SQL Server using…

  • Altering Column – From NULL to NOT NULL in SQL Server

    Introduction When working in SQL Server tables, sometimes we may need to change a column that allows NULL to NOT NULL. This change is required as part of business requirement, that is definitely this column contains value or else as part of performance improvements, we may be in need to change the column from NULL…

Subscribe

Enter your email below to receive updates.