Datediff Sql Compare two dates
In this article, I will explain how to compare two dates and gets number of days using Datediff in SQL …
Read More →
Sep 05, 2016
Tag: SQL
Browse articles tagged with "SQL"
Aug 24, 2016
How to convert SQL Query to Linq syntax?
You can convert common SQL Queries to Linq syntax using Linq Converter.
Read More →
Jul 08, 2016
Sql server isnull example?
In this article, I describe How to use NULLIF in sql server. As we knows nullif clause used to check …
Read More →
Jul 08, 2016
How to modify or insert already existing table value using by another table in sql server?
In this article, I describe How to modify or insert into already existing table value using by another table.This is …
Read More →
Jul 08, 2016
How to copy/insert a table value from one table to another in sql server?
In this article, I describe How to copy or insert one table value to another table.This is achieved by a …
Read More →
May 31, 2016
How to delete multiple rows in datatables grid using asp.net MVC?
In this article we will discuss how to delete multiple rows in datatables grid using in asp.net. We are binding …
Read More →
May 07, 2016
How to create while loop SQL server?
In this article we will discuss, How to create while loop SQL server We will be using Employee table. Below …
Read More →
May 04, 2016
How to connect ADO.NET code to SQL Server Database and retrieve data?
In this article we will discuss, to connect ADO.NET code to SQL Server Database and retrieve data. We are using …
Read More →
Mar 23, 2016
How to find your Current bank balance using SQL query?
In this section, I explain how to find your bank balance using sql query. This questions asked by many interviewer, …
Read More →
Mar 21, 2016
How to append prefix to existing value in a field using sql query?
In this article, I describe how to append prefix to all existing value in a field using sql query. Here …
Read More →
Mar 21, 2016
How to get first, last date and total days in a month from current date using sql query?
In this article, I found a sql query to find first, last and total days in a month from the …
Read More →
Mar 21, 2016
How to get DAY , MONTH and YEAR from current date using sql query?
In this article, I found a sql query to find day, month and year from the current or any date …
Read More →
Feb 18, 2016
How to get previous date query using SQL server?
If you need to get previous date time.(i.e., current date minus 1)
Read More →
Feb 18, 2016
how do get day of Date? eg: monday, friday
If you need to get the day name (i.e. Monday, Tuesday, etc.)
Read More →
Feb 18, 2016
How to get current year,month,day in sql server?
In GETDATE() function will return current date and time from the SQL Server.
Read More →
Feb 18, 2016
how to implement Progressive (continuous) dots for article using SQL?
We are going to learn how to implement Progressive (continuous) for an article using SQL server using SUBSTRING.
Read More →
Feb 18, 2016
How to get datetime in sql query?
If you run following script in this SQL Command. Itwill give you same results and no performance difference. It will …
Read More →
Feb 18, 2016
how to check table exists in SQL Server?
Best way to use an INFORMATION_SCHEMA view. These views are most standard across the plateform.
Read More →
Feb 18, 2016
How to generate a row of every 15 minutes of the start time and end time?
I have the specified start date time and end date time i.e (end date time is end of sequence), I …
Read More →
Feb 17, 2016
How to delete duplicate rows in sql?
Here I am using CTE(Common Table Expression) for Delete duplicate rows. PARTITION BY : It devides the query result into …
Read More →
Feb 17, 2016
How to add a column with a default value, to an existing table in SQL Server?
If it's not a nullable column, you have to insert some value to existing table in SQL server.
Read More →
Feb 15, 2016
Database backup easily using DB SQL command
Create a folder in a directory.Take database Backup by executing SQL command.Below query will return a listing of all backup …
Read More →
« Previous
Page 2 of 2