In this article, I will show you how much space used/unused by the all tables in SQL server database using SQL Query.
In this article, I will show you how to create password encryption and decryption in c# asp.net. I am going to encrypt password before saving using the entity framework sql server.
In this article I will show you how to create Sql Server Stored procedure like, parameter implemented for it. Here I used nullable parameter (IsNull) and search the product using Like keyword.
You can identify the SQL server database version and SQL server Editon of installed product in PC/server by using the following SQL script.
In this article, I will explain how to compare two dates and gets number of days using Datediff in SQL server.
You can convert common SQL Queries to Linq syntax using Linq Converter.
In this article, I describe How to use NULLIF in sql server. As we knows nullif clause used to check the value is null or not. If the value is null then we define some default value.
In this article, I describe How to modify or insert into already existing table value using by another table.This is achieved by a select statement.
In this article, I describe How to copy or insert one table value to another table.This is achieved by a select statement.
In this article we will discuss how to delete multiple rows in datatables grid using in asp.net. We are binding record(s) using datatable grid each row contains check box.If the user wants to delete multiple rows by select using checkbox.