SQL Exercise – 20
SQL Exercise: Retrieve a list of all tables along with the number of rows in each table in SQL Server. Soluton: To retrieve a list… Read More »SQL Exercise – 20
Home »
sql interview
SQL Exercise – 17
SQL Exercise: You are given an Employee table containing details about employees, their departments, and their salaries. Your task is to write an SQL query… Read More »SQL Exercise – 17
How to get the sizes of all databases on a SQL Server
How to get the sizes of all databases on a SQL Server ?
SQL Server Computed Columns
A computed column is a virtual column which is used to add a new column to a table with the value derived from the values of other columns in the same table.
Computed column is not physically stored in the table, unless column is marked PERSISTED and it is persisted only if its expression is deterministic.
SQL Q & A on SELECT Statement
Q 1 > SELECT Count(1) as Output 1> NULL 2> Error 3> 1 4> Invalid select statement Answer Q 2 > SELECT Count(*) as… Read More »SQL Q & A on SELECT Statement
Truncate VS Delete statements in SQL Server
What is the Difference between SQL Truncate and SQL Delete statements in SQL Server ?