Get all schemas in SQL Server database –Get all schemas in SQL Server database SELECT s.name as schema_name, s.schema_id, u.name
Month: December 2018
011. Get all available Databases in SQL Server Instance
Get all available Databases in SQL Server Instance select [name] as database_nane, database_id, create_date from sys.databases order by name
006. Find most used column names in database – Sql Server
Find most used column names in database Query: select col.name as ColumnName, count(*) as Tables, cast(100.0 * count(*) / (select
Difference between temporary table and table variable in sql server
Difference between temporary table and table variable in sql server Table variable Temporary table You can use it in User
Evaluate code execution time in C#
Evaluate code execution time in C# Hello folks, sometime we as a developer wants to check exact execution time to
Visual Studio 2019 Preview Released
Visual Studio 2019 Preview Released You can download Visual Studio 2019 Preview. Please find video regarding New features in Visual Studio
WPF and Windows Forms are Now open source
WPF and Windows Forms are Now open source Recently Microsoft has announced WPF and Windows form as a Open source.