Get all tables from database – SQL Server –Get all tables from database – SQL Server SELECT schema_name(t.schema_id) as schema_name,
Author: Dhruv Sheth
Hello friends, My self Dhruv Sheth, I have more than 10 years of Industrial experience as a Software Developer. In my career I got chance to work with asp.net, c#,Web API, JavaScript, JQuery, WPF, WCF , Windows Application, PostScript, vb.net, GhostScript etc. So I have decided to share my knowledge with everyone and finally I have come up with TechnoThirsty.
012. Get all schemas in SQL Server database
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
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.
Difference between static and non-static variable in C#
Difference between static and non-static variable in C# Staic Variable Non Static Variable Staic keyword must be used to
Capitalize First Letter of each Words of string in C#
Capitalize First Letter of each Words of string in C# Hello folks, sometimes we may have requirement like to have Capitalize
NumberStyle in Parse() and TryParse() in C#
NumberStyle in Parse() and TryParse() in C# Hello folks, today we will learn about NumberStyle in Parse() and TryParse() in
Difference between JSON.stringify() and JSON.parse() in JSON – JavaScript
Difference between JSON.stringify() and JSON.parse() in JSON Now a days all browsers supports JSON and in JSON we have stringify()