Click here to Skip to main content
15,885,216 members
Home / Discussions / Database
   

Database

 
GeneralRe: One to Many Relationships - Tabular Display Pin
eddieangel16-May-12 12:53
eddieangel16-May-12 12:53 
GeneralRe: One to Many Relationships - Tabular Display Pin
Jörgen Andersson17-May-12 1:51
professionalJörgen Andersson17-May-12 1:51 
GeneralRe: One to Many Relationships - Tabular Display Pin
eddieangel17-May-12 6:43
eddieangel17-May-12 6:43 
AnswerRe: One to Many Relationships - Tabular Display Pin
Mycroft Holmes16-May-12 12:47
professionalMycroft Holmes16-May-12 12:47 
AnswerRe: One to Many Relationships - Tabular Display Pin
PIEBALDconsult16-May-12 14:11
mvePIEBALDconsult16-May-12 14:11 
AnswerRe: One to Many Relationships - Tabular Display Pin
vvashishta16-May-12 20:15
vvashishta16-May-12 20:15 
Questionexport to text file + SQL Pin
jojoba201115-May-12 18:02
jojoba201115-May-12 18:02 
AnswerRe: export to text file + SQL Pin
vvashishta15-May-12 20:48
vvashishta15-May-12 20:48 
For That You Have To Activate Few Services In SQL Server ::

Execute This Command Set;
EXEC master.dbo.sp_configure 'show advanced options', 1
RECONFIGURE
EXEC master.dbo.sp_configure 'xp_cmdshell', 1
RECONFIGURE

Now To Get Output of any SQL query in a text file write this query:

EXEC xp_cmdshell 'bcp "YOUR QUERY HERE" queryout "Location Of TextFile Here" -T -c -t,'
- Happy Coding -
Vishal Vashishta

AnswerRe: export to text file + SQL Pin
Sandeep Mewara15-May-12 20:53
mveSandeep Mewara15-May-12 20:53 
QuestionRe: export to text file + SQL Pin
jojoba201115-May-12 21:53
jojoba201115-May-12 21:53 
QuestionHow to Update Database SQL express DB Pin
jojoba201114-May-12 22:06
jojoba201114-May-12 22:06 
AnswerRe: How to Update Database SQL express DB Pin
Chris Meech15-May-12 2:35
Chris Meech15-May-12 2:35 
QuestionRe: How to Update Database SQL express DB Pin
jojoba201115-May-12 5:10
jojoba201115-May-12 5:10 
QuestionSQL Server database updation from oracle database in realtime Pin
uspatel14-May-12 19:04
professionaluspatel14-May-12 19:04 
AnswerRe: SQL Server database updation from oracle database in realtime Pin
Mycroft Holmes14-May-12 22:23
professionalMycroft Holmes14-May-12 22:23 
GeneralRe: SQL Server database updation from oracle database in realtime Pin
uspatel14-May-12 22:44
professionaluspatel14-May-12 22:44 
GeneralRe: SQL Server database updation from oracle database in realtime Pin
Mycroft Holmes15-May-12 12:51
professionalMycroft Holmes15-May-12 12:51 
GeneralRe: SQL Server database updation from oracle database in realtime Pin
uspatel15-May-12 19:02
professionaluspatel15-May-12 19:02 
GeneralRe: SQL Server database updation from oracle database in realtime Pin
pmpdesign15-May-12 20:45
pmpdesign15-May-12 20:45 
QuestionSQL Table Description Pin
Kevin Marois14-May-12 12:16
professionalKevin Marois14-May-12 12:16 
AnswerRe: SQL Table Description Pin
R. Giskard Reventlov14-May-12 12:31
R. Giskard Reventlov14-May-12 12:31 
GeneralRe: SQL Table Description Pin
Kevin Marois14-May-12 12:33
professionalKevin Marois14-May-12 12:33 
QuestionxBase question Pin
David Crow14-May-12 10:05
David Crow14-May-12 10:05 
AnswerRe: xBase question Pin
Kevin Marois14-May-12 11:40
professionalKevin Marois14-May-12 11:40 
QuestionRe: xBase question Pin
David Crow14-May-12 17:22
David Crow14-May-12 17:22 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.