Latest posts on tagged on "SQL"

If you run following script in this SQL Command. Itwill give you same results and no performance difference. It will return the current server time.

Best way to use an INFORMATION_SCHEMA view. These views are most standard across the plateform.

I have the specified start date time and end date time i.e (end date time is end of sequence), I add a time interval (this can vary) to the start date time in minutes and this gives me the end date time. we can set time interval 15minutes (60 sec*15 min=900sec).

Here I am using CTE(Common Table Expression) for Delete duplicate rows. PARTITION BY : It devides the query result into partitions Row_NUMBER : gives unique name for all duplicate rows ie., if one row record repeated for 3 times . it gives the index such as 1,2 and 3 Using this query we can delete all duplicate rows in a table

If it's not a nullable column, you have to insert some value to existing table in SQL server.

Create a folder in a directory.Take database Backup by executing SQL command.Below query will return a listing of all backup files in all databases on a SQL instance.