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.
| Author |
Topic |
|
thelak
Starting Member
5 Posts |
 Posted - 2010-09-23 : 07:42:44
|
| How to copy a content of the table fully in to text fileplease provide the commandRegThelak |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2010-09-23 : 07:52:53
|
| Look up BCP, the best way to learn is to find out yourself. |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-09-23 : 08:03:09
|
Examplebcp "SELECT * FROM pubs..authors" queryout authors.txt -U garth -P pw -c Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
thelak
Starting Member
5 Posts |
Posted - 2010-09-23 : 09:00:19
|
| Hi charlie, I am not working in T-sql please help me to know these things in sql server please.RegThelak |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-09-23 : 09:15:02
|
quote:
Originally posted by thelak
Hi charlie, I am not working in T-sql please help me to know these things in sql server please.RegThelak
..................?T-SQL is the flavour of SQL used by Microsoft SQL Server (it's short for TRANSACT SQL) (because it has transactions).Are you using microsoft SQL SERVER? or something else. If you are not using Microsoft SQL SERVER then we won't be able to help you.BCP is a command line utility.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
|
|
|
|
|
|
|
copy