When you are required to import data received from different different file format such as .txt, .csv., or excel files, sometimes you see a white spaces along with the data, which may create a problem…
192 total views, 1 views today
SQL ROLLBACK transaction statement rolls back an explicit or implicit transaction to the beginning of the transaction. If savepoint is specified then it rolls back the transaction to a savepoint within the transaction. Basically, it…
1,358 total views, 7 views today
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.
226 total views
Blocking occurs when a process hold a lock and other process has to wait till the first process completes.
966 total views, 6 views today
CUBE operator is used to calculate subtotals and grand total for all combinations of grouping columns specified in the GROUP BY clause.
396 total views
Temporary or Temp tables are tables that exist temporarily on the SQL Server.
462 total views, 1 views today
SQL interview question and answer on Substring function
407 total views, 6 views today
Q 1 > SELECT Count(1) as Output 1> NULL 2> Error 3> 1 4> Invalid select statement Answer Q 2 > SELECT Count(*) as Output 1> NULL 2> 1 3> Error 4> Invalid select…
153 total views
A foreign key is a key used to link two tables together. This is sometimes also called as a referencing key , usually a primary key table is considered as a parent table while a foreign key table is considered as a child table .
170 total views
What is the Difference between SQL Truncate and SQL Delete statements in SQL Server ?
174 total views, 2 views today
How to copy a data of table from another database in SQL Server?
Suppose, you have a database1 and table1 and one another database2 and table2 in SQL server.
Now you are required to select data of a table1 of database1 from database2 of table2.
What would be a query for that?
2,290 total views, 19 views today
It fires in response to LOGON events of SQL Server is raised .
A LOGON Triggers can be useful in may ways, such as to restrict number of connection made by a Login or to prevent a user from logging-in outside .
109 total views, 3 views today