| 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...
|
Archives - 2012