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… Read More »Delete Horizontal White Space in SQL Serve
1,307 total views
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… Read More »SQL ROLLBACK Transactions
5,008 total views, 1 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.
2,188 total views, 2 views today
Blocking occurs when a process hold a lock and other process has to wait till the first process completes.
9,181 total views, 3 views today
CUBE operator is used to calculate subtotals and grand total for all combinations of grouping columns specified in the GROUP BY clause.
2,283 total views
Temporary or Temp tables are tables that exist temporarily on the SQL Server.
2,775 total views, 1 views today
SQL interview question and answer on Substring function
3,938 total views, 3 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… Read More »SQL Q & A on SELECT Statement
1,879 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 .
2,703 total views
What is the Difference between SQL Truncate and SQL Delete statements in SQL Server ?
2,158 total views
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?
26,604 total views, 9 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 .
1,806 total views