Topics Topics Help/Instructions Help Edit Profile Profile Member List Register Paatha Gnyapakaalu - Archives from Old DB  
Search New Posts 1 | 2 | 8 Hours Search New Posts 1 | 3 | 7 Days Search Search Tree View Tree View Latest tweets Live Tweets   Hide Images
Bewarse Talk Discussion Board * Archives - 2012 * Cine Talk - Reviews, Gossips, Insider Info etc. * Archive through December 03, 2012 * Its very urgent sql need < Previous Next >

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Kingchoudary
Bewarse Legend
Username: Kingchoudary

Post Number: 80576
Registered: 03-2004
Posted From: 130.138.227.54

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 9:10 am:    Edit Post Delete Post Print Post

Rendu dunna pothulu SQL saaku gaa chesukoni bum chik bum vesukuntunnayi gaa madyalo vachedanni kooda idharu nakings anta....
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 120839
Registered: 03-2004
Posted From: 93.83.138.98

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 8:49 am:    Edit Post Delete Post Print Post


Godfather:


mudhu manaku run ayithe test sesukuni adikivachu ga...anyway...syntax septha boss gaaniki...
aa bongulo signature le...
Top of pagePrevious messageNext messageBottom of page Link to this message

Godfather
Bewarse Legend
Username: Godfather

Post Number: 69391
Registered: 03-2004
Posted From: 193.9.230.100

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 8:46 am:    Edit Post Delete Post Print Post


Proofdada:

ade leedhu, idi client system kiki




ee sari PC badhulu ninnu nalugu ghudulu ghudutadu aite.. CLIPART--lol2

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..
Top of pagePrevious messageNext messageBottom of page Link to this message

Godfather
Bewarse Legend
Username: Godfather

Post Number: 69390
Registered: 03-2004
Posted From: 193.9.230.100

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 8:44 am:    Edit Post Delete Post Print Post

adi run chesse user kee sysadmin rights ivamanu mama..
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 120838
Registered: 03-2004
Posted From: 93.83.138.98

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 8:43 am:    Edit Post Delete Post Print Post


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...CLIPART--asdf...

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...
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 120837
Registered: 03-2004
Posted From: 93.83.138.98

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 8:40 am:    Edit Post Delete Post Print Post

procedure lo run seyyalante xp_cmdshell use seyyalata inko way ledhata...
aa bongulo signature le...
Top of pagePrevious messageNext messageBottom of page Link to this message

Godfather
Bewarse Legend
Username: Godfather

Post Number: 69389
Registered: 03-2004
Posted From: 193.9.230.100

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 8:39 am:    Edit Post Delete Post Print Post

EXEC xp_cmdshell 'indhaka ichina BCP command' ,no_output

try cheyi..

xp_cmdshell kee neeku sysadmin rights vundali.. avi set chesuko , antha set..
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 120836
Registered: 03-2004
Posted From: 93.83.138.98

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 8:39 am:    Edit Post Delete Post Print Post


Godfather:


ante oka pali soosa eppudoo benchmark loo...MOVIEART--bemmi.adi...

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...
Top of pagePrevious messageNext messageBottom of page Link to this message

Godfather
Bewarse Legend
Username: Godfather

Post Number: 69388
Registered: 03-2004
Posted From: 193.9.230.100

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 8:35 am:    Edit Post Delete Post Print Post


Proofdada:

they use some bcp something rite




mari ee mukka endhuku use sesavu.. MOVIEART--kota.kick
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 120835
Registered: 03-2004
Posted From: 93.83.138.98

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 8:20 am:    Edit Post Delete Post Print Post


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...
Top of pagePrevious messageNext messageBottom of page Link to this message

Godfather
Bewarse Legend
Username: Godfather

Post Number: 69387
Registered: 03-2004
Posted From: 193.9.230.100

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 8:18 am:    Edit Post Delete Post Print Post


Proofdada:

ekkada typali cheppu nuvv sepina stmt...




Command prompt loo..
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 120834
Registered: 03-2004
Posted From: 93.83.138.98

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 8:13 am:    Edit Post Delete Post Print Post


Godfather:


avunaa...sqlserver la procedure raasi select sesi run kotta...CLIPART--lol2...

ekkada typali cheppu nuvv sepina stmt...

e lamdike gadu view name seppa kunda thenkesadu...sashtunna aa view eedhoo ani...
aa bongulo signature le...
Top of pagePrevious messageNext messageBottom of page Link to this message

Godfather
Bewarse Legend
Username: Godfather

Post Number: 69386
Registered: 03-2004
Posted From: 193.9.230.100

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 8:07 am:    Edit Post Delete Post Print Post

eda run settunavu BCP nee ? Adi command line utility..
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 120833
Registered: 03-2004
Posted From: 93.83.138.98

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 7:57 am:    Edit Post Delete Post Print Post


Godfather:

BCP <Viewname> out <Outputfilename> -c -t


idi stright ga work out avudda...

bcp ante eenti antundhi
aa bongulo signature le...
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 120832
Registered: 03-2004
Posted From: 93.83.138.98

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 7:56 am:    Edit Post Delete Post Print Post

sys.xp_cmdshell

option off sesaru security reasons thoo ata, aa msg vashtundhi error loo...
aa bongulo signature le...
Top of pagePrevious messageNext messageBottom of page Link to this message

Godfather
Bewarse Legend
Username: Godfather

Post Number: 69385
Registered: 03-2004
Posted From: 193.9.230.100

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 7:39 am:    Edit Post Delete Post Print Post


Proofdada:

@@servername mundhu define sesukovala




adi system variable.. nee servername return settundi.
Top of pagePrevious messageNext messageBottom of page Link to this message

Godfather
Bewarse Legend
Username: Godfather

Post Number: 69384
Registered: 03-2004
Posted From: 193.9.230.100

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 7:37 am:    Edit Post Delete Post Print Post

BCP <Viewname> out <Outputfilename> -c -t

idi try chesi choodu..
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 120831
Registered: 03-2004
Posted From: 93.83.138.98

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 7:34 am:    Edit Post Delete Post Print Post

@@servername mundhu define sesukovala... hmm...
aa bongulo signature le...
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 120830
Registered: 03-2004
Posted From: 93.83.138.98

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 7:32 am:    Edit Post Delete Post Print Post

master as it is ga use seyyala...
aa bongulo signature le...
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 120829
Registered: 03-2004
Posted From: 93.83.138.98

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 7:31 am:    Edit Post Delete Post Print Post

EXEC master..xp_cmdshell @sql

dhani menaing eeti seppava... xp_cmdshell annadhi key wordaa attage use seyala
aa bongulo signature le...
Top of pagePrevious messageNext messageBottom of page Link to this message

Godfather
Bewarse Legend
Username: Godfather

Post Number: 69383
Registered: 03-2004
Posted From: 193.9.230.100

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 7:25 am:    Edit Post Delete Post Print Post

master database
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 120828
Registered: 03-2004
Posted From: 93.83.138.98

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 7:22 am:    Edit Post Delete Post Print Post

dantlo master ante eeti
aa bongulo signature le...
Top of pagePrevious messageNext messageBottom of page Link to this message

Godfather
Bewarse Legend
Username: Godfather

Post Number: 69382
Registered: 03-2004
Posted From: 193.9.230.100

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 7:17 am:    Edit Post Delete Post Print Post

http://stackoverflow.com/questions/799465/how-to-export-sql-server-2005-query-to -csv
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 120827
Registered: 03-2004
Posted From: 93.83.138.98

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 7:16 am:    Edit Post Delete Post Print Post

mgmt studio nunche...
aa bongulo signature le...
Top of pagePrevious messageNext messageBottom of page Link to this message

Godfather
Bewarse Legend
Username: Godfather

Post Number: 69380
Registered: 03-2004
Posted From: 193.9.230.100

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 7:15 am:    Edit Post Delete Post Print Post

BCP aite ee example choodu.. http://www.simple-talk.com/sql/database-administration/creating-csv-files-using- bcp-and-stored-procedures/
Top of pagePrevious messageNext messageBottom of page Link to this message

Godfather
Bewarse Legend
Username: Godfather

Post Number: 69379
Registered: 03-2004
Posted From: 193.9.230.100

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 7:13 am:    Edit Post Delete Post Print Post

TSQL loo eta cheyalo idea ledu mama.. Management studio nunchi cheya vochu.. or else sqlcmd anee okka command vuntundi adi use chesei cheya vochu..
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 120826
Registered: 03-2004
Posted From: 93.83.138.98

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 7:09 am:    Edit Post Delete Post Print Post

haav

ippudu

exec procedure name BCP view name queryout path

sari podda
aa bongulo signature le...
Top of pagePrevious messageNext messageBottom of page Link to this message

Godfather
Bewarse Legend
Username: Godfather

Post Number: 69378
Registered: 03-2004
Posted From: 193.9.230.100

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 7:08 am:    Edit Post Delete Post Print Post

Sql Server aa ?
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 120825
Registered: 03-2004
Posted From: 93.83.138.98

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 7:07 am:    Edit Post Delete Post Print Post

they use some bcp something rite
aa bongulo signature le...
Top of pagePrevious messageNext messageBottom of page Link to this message

Proofdada
Bewarse Legend
Username: Proofdada

Post Number: 120824
Registered: 03-2004
Posted From: 93.83.138.98

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, November 30, 2012 - 7:03 am:    Edit Post Delete Post Print Post

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

Topics | Last Hour | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration