There are a dozen of editions of Microsoft SQL server in the market, which targets different audiences and workloads of all interfaces ranging from the small single interface applications to large interface application with lots of concurrent users.
With lots of scope in the industry, the candidates aiming to cruise with the knowledge of MSSQL can get an extra pair of hands with these interview questions to crack the interview.
From the tools menu of SQL Server configuration properties in the security page, the modes can be changed.
Recursive stored procedure – It is defined as a process of resolving a problem where the solution occurs repetitively.This can be nested up to 32 levels.
Global temporary table – These tables are visible to all users and are deleted when the connection is closed.
DDL (Data Definition Language)
DCL (Data Control Language)
TCL (Transactional Control Language)
Never Miss an Articles from us.