SQL Server Export Sample of 100 Records
Posted on 2012-08-19
I would like the step-by-step instructions on how to export (extract) about 100 Records from an existing SQL Server Database (Microsoft SQL Server 2008R2 64-Bit) that contains thousands of records. One of our software developers has requested that we extract a sample of the existing SQL Server Databse and forward (ftp) it to them for testing.
I have limited exposure/experience with SQL Server and have attempted to locate this process using SQL books without any success.