10. Describe how to use 'CURSOR' in SQL procedure. Please write a procedure that uses CURSOR to return result set with 'select col1 from t1'. General Questions of SQL SERVER What is Cursor? Cursor is a database object used by applications to manipulate data in a set on a row-by-row...
To open SQL Server’s configuration manager, log in to your database server. Click the Windows “Start” button and click the program group for your SQL Server version. In this example, SQL Server 2008 is used. Click “SQL Server Configuration Manager” in the configuration folder. Get some...
Below, I have prepared a list of the most common database modeling interview questions, along with their correct answers. These questions give you an idea of how to prepare for an interview. But let me warn you first: while thoroughly studying this list of questions and answers helps you sh...
SQL Server Database Fabulous Collection of SQL Server Multiple Choice Questions & SQL Server Database Online Quiz for students, fresher’s and experienced to improve your own SQL Server knowledge.(90 Questions, 4970 Times Visited) SQL Server DBA ...
In SQL Server, procedures and functions can return values. (In Oracle, procedures cannot directly return a value). The major difference with a function is that it can be used in a value assignment. Such as: –system function Declare @mydate datetime ...
SQL Server Interview: How to prevent ‘SELECT *’ using T-SQL Script? More SQL Server Interview: A Golden question, Can we disable the Clustered Index? More A Day in the life of a DBA ! More NoSQL: The latest buzzword in Data Science, What is NoSQL? (Day 1) ...
Server Testing HR Java TPF Tutorial Tools Test and Papers Silverlight Science Techonlogy :) Latest Topic AJAX VB.NET SQL Query UDDI CLASS JavaScript Questions SharePoint Interview SilverLight WCF general knowledge asp net questions :) :) Topic of Day :) Hot Jobs ASP.NET Developer(2-5 yea...
Ben has simplified sub-queries for me, regex, and many other topics. I feel slow when reading a lot of explanations off the internet, but his explanations are so clear, they make these topics easy to understand. The "SQL Interview Questions & Answers", which I nearly didn't read, was ...
Interview questions for Oracle DBA and MS SQL Server Oracle RAC Interview Questions Oracle DBA Basic Interview Questions Part B Oracle DBA Basic Interview Questions Part C Oracle DBA Basic Interview Questions Part A Oracle Standby Database Interview Questions View All 11 MariaDB MariaDB Da...
I have explained various popular SQL Server interview questions and... Read More → How to Download, Install and Restore AdventureWorks Database in SQL Server September 18, 2022• Database administration Sometimes, we need a sample database that has all the required objects along with a ...