SQL Server Interview Questions & Answers Question 1: How does the database recovery model impact database backups? Ans. Database recovery model is responsible for the retention of the transaction log entries.So the setting determines if transaction log backups need to be issued on a regular or not. SQL Server database recovery models: Simple – Committed transactions […]
Category: Sql Server
SQL Server Tutorials, SQL Server Tutorials for Beginners, SQL Server Online Course, Microsoft SQL Server Learning, Microsoft Online Learing
How To Insert Values Into An Identity Column In SQL Server In this tutorial i will explain you How To Insert Values Into An Identity Column In SQL Server.Identity columns are mostly used as primary keys in tables.These columns automatically assign a value for each new row.But if you want to insert your own value into the […]
How To Backup All Database In SQL Server Which Are Online In this tutorial i will explain How To Backup All Database In SQL Server Which Are Online.We are using CURSOR to achieve this.Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis. Script: DECLARE @name VARCHAR(50) — database name DECLARE @path […]
What Is Function In SQL Server and How To Use It In this tutorial i will let you know What Is Function In SQL Server and How To Use It.Function is a Transact-SQL or common language runtime (CLR) routine that accepts parameters, performs an action, and returns the resulte.The return value can either be a […]