MS SQL SERVER

One SQL Script to take Backup of all DataBases [ MS SQL SERVER]

One SQL Script to take Backup of all DataBases [ MS SQL SERVER]

 MS SQL Backup all databases: Here in this article will see how to take backup of all database from SQL Server step by step. From SQL Server Management Studio we can make our databases backup .i.e using user interface we can easily get the .bak file of our database, which we can restore later anywhere. […]


by - Satinder singh

Get Time part from Datetime in MS SQL server

Get Time part from Datetime in MS SQL server

 TIME PART FROM DATETIME: This article shows how to get only time part from DateTime in MS SQL Server. While development sometimes we need to take solely Time part from the whole Datetime. That is if the given date value is  2017-01-01 09:32:15.000  and here we want to fetch only time part for this given date […]


by - Satinder singh