Whenever we are finding some issues in performance, we are also try to avoid Dynamic Sql in Stored Procedure.To avoid
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.
014. Who has CONNECT permission for an endpoint script – SQL Server
When we install SQL Server, SQL Server requires some of permissions like TSQL Local Machine, TSQL Named Pipes, TSQL Default
Difference between Abstract class and Interface in C#
Difference between Abstract class and Interface in C# Hello folks, today we will discuss regarding Top 6 Differences of Abstract class and
Top 5 Static code Analysis Tools for Visual Studio
Hello Folks, today we will explore regarding Top 5 Static code Analysis Tools for Visual Studio, which also includes other
What is the use of @@TRANCOUNT in SQL Server?
Returns the number of active transactions for the current connection. PRINT @@TRANCOUNT — The BEGIN TRAN statement will increment the
How to return XML in SQL Server?
We can use FOR XML statement at the end of the query to return xml data from the SQL Server.
What is trigger in sql server?
Triggers allows us to execute a batch of SQL code when either an insert, update or delete command is executed
Top 10 examples of SubString in C#
Top 10 examples of SubString in C# Hello folks, after long time I am back with simple but so important
Top 9 differences between Array and ArrayList in C#
Top 9 differences between Array and ArrayList Array ArrayList Array is strongly typed. This means that an array can store