Skip to content
Home » SQL Server

SQL Server

SQL Server basic to advance level tutorials with query Optimization techniques, learn step by step with an example.

150 SQL Interview Questions and Answers Cheat Sheet

BASIC SQL INTERVIEW QUESTIONS (1–50) 1. What is SQL? Answer: SQL stands for Structured Query Language used to manage and query databases. 2. What is a database? Answer: A database is an organized collection of data stored electronically. 3. What is a table in SQL? Answer: A table is a collection of related data in Read More

Loading

DELETE Statement SQL SERVER

SQL Server DELETE Statement

The SQL Server DELETE statement is used to delete particular record or all records from table. It’s comes under Data Manipulation Language(DML). Read More

Loading

CREATE TABLE in SQL SERVER

SQL Server Create Table

The CREATE TABLE statement is used to create a new table in a database, this statement comes under SQL Server Data Definition Language (DDL) commands. Read More

Loading

Read Uncommitted Isolation Level

SQL Server Dirty Read Concurrency Problem

SQL Server Dirty Read is a part of Concurrency problem, it occurs when one transaction is allowed to read the uncommitted data. Read More

Loading

Convert VS Try

SQL CONVERT() Vs TRY_CONVERT() function

The SQL Convert() or TRY_Convert() both are SQL Conversions Functions and similar to CAST() or TRY_CAST() functions with an additional optional parameter ‘Style’. Read More

Loading