Author |
Message |
Kingchoudary
Bewarse Legend Username: Kingchoudary
Post Number: 80576 Registered: 03-2004 Posted From: 130.138.227.54
| Posted on Friday, November 30, 2012 - 9:10 am: |
|
Rendu dunna pothulu SQL saaku gaa chesukoni bum chik bum vesukuntunnayi gaa madyalo vachedanni kooda idharu nakings anta.... |
Proofdada
Bewarse Legend Username: Proofdada
Post Number: 120839 Registered: 03-2004 Posted From: 93.83.138.98
| Posted on Friday, November 30, 2012 - 8:49 am: |
|
Godfather:
mudhu manaku run ayithe test sesukuni adikivachu ga...anyway...syntax septha boss gaaniki... aa bongulo signature le...
|
Godfather
Bewarse Legend Username: Godfather
Post Number: 69391 Registered: 03-2004 Posted From: 193.9.230.100
| Posted on Friday, November 30, 2012 - 8:46 am: |
|
Proofdada:ade leedhu, idi client system kiki
ee sari PC badhulu ninnu nalugu ghudulu ghudutadu aite.. ayina mee germans antha rude gaa vuntara.. nenu ee 8 yrs loo atta temper loose ayye vadini evarini soodale.. trainee laa daggira nunchi CEO loo dhaka.. |
Godfather
Bewarse Legend Username: Godfather
Post Number: 69390 Registered: 03-2004 Posted From: 193.9.230.100
| Posted on Friday, November 30, 2012 - 8:44 am: |
|
adi run chesse user kee sysadmin rights ivamanu mama.. |
Proofdada
Bewarse Legend Username: Proofdada
Post Number: 120838 Registered: 03-2004 Posted From: 93.83.138.98
| Posted on Friday, November 30, 2012 - 8:43 am: |
|
Godfather:xp_cmdshell kee neeku sysadmin rights vundali.. avi set chesuko , antha set..
ade leedhu, idi client system kiki...maa boss gadu naaku idi cheppi access ichi lunch ku thenkesad edemma, inga raala...ippudochi inka cheyyalaa antad...naa karma...sqlserver naaku thelusu ani seppatama naa penala medhaku vahcinattundhi...... ninna koda excel loo vlookup adigadu... excel guru itu ra annadu...vlookup sood pani seyatla annadu...try sesa antha correctgane vundhi pani seyyatla... naan sinna example raasi soopicha choodu pani sethandhi...ikkada endhukoo pani seyyatla ani seppa...aadu tension thoo pc nu naaluguddulu guddi german booths thittadu... pooni annnu thittala anukunya... aa bongulo signature le...
|
Proofdada
Bewarse Legend Username: Proofdada
Post Number: 120837 Registered: 03-2004 Posted From: 93.83.138.98
| Posted on Friday, November 30, 2012 - 8:40 am: |
|
procedure lo run seyyalante xp_cmdshell use seyyalata inko way ledhata... aa bongulo signature le...
|
Godfather
Bewarse Legend Username: Godfather
Post Number: 69389 Registered: 03-2004 Posted From: 193.9.230.100
| Posted on Friday, November 30, 2012 - 8:39 am: |
|
EXEC xp_cmdshell 'indhaka ichina BCP command' ,no_output try cheyi.. xp_cmdshell kee neeku sysadmin rights vundali.. avi set chesuko , antha set.. |
Proofdada
Bewarse Legend Username: Proofdada
Post Number: 120836 Registered: 03-2004 Posted From: 93.83.138.98
| Posted on Friday, November 30, 2012 - 8:39 am: |
|
Godfather:
ante oka pali soosa eppudoo benchmark loo...... ikkada oka procedure rayamantunnadu...oka csv file loo root dir loo save ayipoyettu... next time client adigithe aa procedure run cheyyatamoo, leka vanikichi run sesuko anatamo sestharu anukunta... aa bongulo signature le...
|
Godfather
Bewarse Legend Username: Godfather
Post Number: 69388 Registered: 03-2004 Posted From: 193.9.230.100
| Posted on Friday, November 30, 2012 - 8:35 am: |
|
Proofdada:they use some bcp something rite
mari ee mukka endhuku use sesavu.. |
Proofdada
Bewarse Legend Username: Proofdada
Post Number: 120835 Registered: 03-2004 Posted From: 93.83.138.98
| Posted on Friday, November 30, 2012 - 8:20 am: |
|
Godfather:
ante command line loo sesukune badulu view daggare export option tho save sesukovachu ga...atta kadhu anee oka procedure rayamannadu... aa bongulo signature le...
|
Godfather
Bewarse Legend Username: Godfather
Post Number: 69387 Registered: 03-2004 Posted From: 193.9.230.100
| Posted on Friday, November 30, 2012 - 8:18 am: |
|
Proofdada:ekkada typali cheppu nuvv sepina stmt...
Command prompt loo.. |
Proofdada
Bewarse Legend Username: Proofdada
Post Number: 120834 Registered: 03-2004 Posted From: 93.83.138.98
| Posted on Friday, November 30, 2012 - 8:13 am: |
|
Godfather:
avunaa...sqlserver la procedure raasi select sesi run kotta...... ekkada typali cheppu nuvv sepina stmt... e lamdike gadu view name seppa kunda thenkesadu...sashtunna aa view eedhoo ani... aa bongulo signature le...
|
Godfather
Bewarse Legend Username: Godfather
Post Number: 69386 Registered: 03-2004 Posted From: 193.9.230.100
| Posted on Friday, November 30, 2012 - 8:07 am: |
|
eda run settunavu BCP nee ? Adi command line utility.. |
Proofdada
Bewarse Legend Username: Proofdada
Post Number: 120833 Registered: 03-2004 Posted From: 93.83.138.98
| Posted on Friday, November 30, 2012 - 7:57 am: |
|
Godfather:BCP <Viewname> out <Outputfilename> -c -t
idi stright ga work out avudda... bcp ante eenti antundhi aa bongulo signature le...
|
Proofdada
Bewarse Legend Username: Proofdada
Post Number: 120832 Registered: 03-2004 Posted From: 93.83.138.98
| Posted on Friday, November 30, 2012 - 7:56 am: |
|
sys.xp_cmdshell option off sesaru security reasons thoo ata, aa msg vashtundhi error loo... aa bongulo signature le...
|
Godfather
Bewarse Legend Username: Godfather
Post Number: 69385 Registered: 03-2004 Posted From: 193.9.230.100
| Posted on Friday, November 30, 2012 - 7:39 am: |
|
Proofdada:@@servername mundhu define sesukovala
adi system variable.. nee servername return settundi. |
Godfather
Bewarse Legend Username: Godfather
Post Number: 69384 Registered: 03-2004 Posted From: 193.9.230.100
| Posted on Friday, November 30, 2012 - 7:37 am: |
|
BCP <Viewname> out <Outputfilename> -c -t idi try chesi choodu.. |
Proofdada
Bewarse Legend Username: Proofdada
Post Number: 120831 Registered: 03-2004 Posted From: 93.83.138.98
| Posted on Friday, November 30, 2012 - 7:34 am: |
|
@@servername mundhu define sesukovala... hmm... aa bongulo signature le...
|
Proofdada
Bewarse Legend Username: Proofdada
Post Number: 120830 Registered: 03-2004 Posted From: 93.83.138.98
| Posted on Friday, November 30, 2012 - 7:32 am: |
|
master as it is ga use seyyala... aa bongulo signature le...
|
Proofdada
Bewarse Legend Username: Proofdada
Post Number: 120829 Registered: 03-2004 Posted From: 93.83.138.98
| Posted on Friday, November 30, 2012 - 7:31 am: |
|
EXEC master..xp_cmdshell @sql dhani menaing eeti seppava... xp_cmdshell annadhi key wordaa attage use seyala aa bongulo signature le...
|
Godfather
Bewarse Legend Username: Godfather
Post Number: 69383 Registered: 03-2004 Posted From: 193.9.230.100
| Posted on Friday, November 30, 2012 - 7:25 am: |
|
master database |
Proofdada
Bewarse Legend Username: Proofdada
Post Number: 120828 Registered: 03-2004 Posted From: 93.83.138.98
| Posted on Friday, November 30, 2012 - 7:22 am: |
|
dantlo master ante eeti aa bongulo signature le...
|
Godfather
Bewarse Legend Username: Godfather
Post Number: 69382 Registered: 03-2004 Posted From: 193.9.230.100
| Posted on Friday, November 30, 2012 - 7:17 am: |
|
http://stackoverflow.com/questions/799465/how-to-export-sql-server-2005-query-to -csv |
Proofdada
Bewarse Legend Username: Proofdada
Post Number: 120827 Registered: 03-2004 Posted From: 93.83.138.98
| Posted on Friday, November 30, 2012 - 7:16 am: |
|
mgmt studio nunche... aa bongulo signature le...
|
Godfather
Bewarse Legend Username: Godfather
Post Number: 69380 Registered: 03-2004 Posted From: 193.9.230.100
| Posted on Friday, November 30, 2012 - 7:15 am: |
|
BCP aite ee example choodu.. http://www.simple-talk.com/sql/database-administration/creating-csv-files-using- bcp-and-stored-procedures/ |
Godfather
Bewarse Legend Username: Godfather
Post Number: 69379 Registered: 03-2004 Posted From: 193.9.230.100
| Posted on Friday, November 30, 2012 - 7:13 am: |
|
TSQL loo eta cheyalo idea ledu mama.. Management studio nunchi cheya vochu.. or else sqlcmd anee okka command vuntundi adi use chesei cheya vochu.. |
Proofdada
Bewarse Legend Username: Proofdada
Post Number: 120826 Registered: 03-2004 Posted From: 93.83.138.98
| Posted on Friday, November 30, 2012 - 7:09 am: |
|
haav ippudu exec procedure name BCP view name queryout path sari podda aa bongulo signature le...
|
Godfather
Bewarse Legend Username: Godfather
Post Number: 69378 Registered: 03-2004 Posted From: 193.9.230.100
| Posted on Friday, November 30, 2012 - 7:08 am: |
|
Sql Server aa ? |
Proofdada
Bewarse Legend Username: Proofdada
Post Number: 120825 Registered: 03-2004 Posted From: 93.83.138.98
| Posted on Friday, November 30, 2012 - 7:07 am: |
|
they use some bcp something rite aa bongulo signature le...
|
Proofdada
Bewarse Legend Username: Proofdada
Post Number: 120824 Registered: 03-2004 Posted From: 93.83.138.98
| Posted on Friday, November 30, 2012 - 7:03 am: |
|
i have a procedure which creates some stuff and cretes a view finally i wrote exec procedure name and go at down but after after creating a view , it should save it as csv byitself, can u please help me out for this... aa bongulo signature le...
|