What is BCP?

What is BCP?

- It is a utility which is used to copy huge data from tables and views without copying schema of the server object.
- It can be used to import large numbers of new rows into SQL server tables or to export data out of tables into data files.
- The BCP utility is accessed by the BCP command.
- This command provides switches that are used to specify the data type of the data file and other information.
How can we move data along with schema of the server object?
We can copy data along schema using DTS package........
Define sub-query
Sub-query is a query within a Query........
sp_grantlogin, sp_denylogin and sp_revokelogin
All these three are the system stored procedure used to manage windows account authentication........
Post your comment