Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 SQL Extract Practice tests

Author  Topic 

sz1
Aged Yak Warrior

555 Posts

Posted - 2012-03-22 : 16:13:08
Hey is there any sites I can use that will ask me questions such as get me this information from these tables and do this and do that...so Joins, summing totals...I have a chance of a new job and need to brush up on data extraction and rather that use practice tables of my own think it would be more beneficial to be asked what to retrieve...

Any advice appreciated.
Thanks
S

X002548
Not Just a Number

15586 Posts

Posted - 2012-03-22 : 16:26:38
1. How can you Export Data from a SQL Server table to a file
1.a. in tab delimited format
2.a. into Excel
3.a. into a mainframe flat file format


Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page
   

- Advertisement -