Skip to content
Home » sql example

sql example

SQL ROLLBACK Transactions

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

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,188 total views,  2 views today

SQL FOREIGN KEY Constraint

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

How to access a data of table from another database in SQL Server?

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