-
Find When was a SQL Server View Last Modified
Introduction In this simple tips and tricks article, I would like to share how to when was a view last modified. Let’s have a look at the below T-SQL Statement In the above T-SQL Statement list, from the column LastModifiedDt column we can find when was the view last modified. Conclusion We will learn more…
-
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…
Subscribe
Enter your email below to receive updates.
