Category: SQL

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 →