Skip to content
Home » sql statement

sql statement

SQL Server CONCAT_WS Function

SQL Server CONCAT_WS() function is a string function that is used concatenates two or more strings together with a separator.

It separates those concatenated string values with the delimiter specified in the first function parameter.

 1,592 total views,  1 views today

SQL Server ROW_NUMBER()

SQL Row_Number() is a ranking function/window function that is used to assign a sequential integer to each row within a partition of a result set. The row number starts with one for the first row in each partition.

 1,725 total views,  1 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