Skip to content
Home » sql practicle

sql practicle

How to fetch alphanumeric string from table

Assume that you have a table which contains alphabetic, numeric, alphanumeric string, and special characters and you are asked to fetch only alphanumeric string from… Read More »How to fetch alphanumeric string from table

 13,052 total views,  16 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 .

 1,890 total views,  2 views today

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?

 20,444 total views,  13 views today