How to get the sizes of all databases on a SQL Server
How to get the sizes of all databases on a SQL Server ?
4,384 total views, 7 views today
Home ยป
sql interview
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.
2,178 total views, 2 views today
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
1,872 total views, 1 views today
Truncate VS Delete statements in SQL Server
What is the Difference between SQL Truncate and SQL Delete statements in SQL Server ?
2,150 total views, 1 views today