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 |
|
dishant jain
Starting Member
5 Posts |
 Posted - 2014-06-25 : 09:13:17
|
| Hi,How can i get the output (like 1 rows(s) inserted)in a file from an input file through sql command prompt.Thanks in advanceDishant jain |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-06-25 : 14:50:51
|
I'm not sure what you are asking here. If you want to get the message "1 row(s) inserted" which is returned to an application, it presents itself as a recordset. For a SELECT statement executed, it would be the second recordset returned; the first being the actual SELECTed records. Note that "SET NOCOUNT ON" would prevent the message from being generated.
Too often we enjoy the comfort of opinion without the discomfort of thought. - John F. Kennedy |
 |
|
|
|
|
|
command prompt output capture