http://sqlserver.ro/forums/16/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/7659.aspxThu, 08 Oct 2009 15:59:27 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7659Diana0http://sqlserver.ro/forums/thread/7659.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7659You're welcome...Si iarta-ma ca am batut campii...:)http://sqlserver.ro/forums/thread/7658.aspxThu, 08 Oct 2009 15:52:57 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7658tebbaerty0http://sqlserver.ro/forums/thread/7658.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7658YUPIIII .... <br><br>Acum am vazut si eu ca lipseste -n care inseamna el native. <br>Este exact ceea ce am nevoie .<br><br><br>Multumesc mult :D<br>http://sqlserver.ro/forums/thread/7657.aspxThu, 08 Oct 2009 14:26:59 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7657Diana0http://sqlserver.ro/forums/thread/7657.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7657Incearca si <br />bcp tabel_or_view format nul -S "serverName" -U "userName" -P "******" -n -f FormatFile.xml -x <br />...acum vad ca "-n" lipseste...scuze. <br />Vezi BOL pentru posibile alternative la "-n".http://sqlserver.ro/forums/thread/7656.aspxThu, 08 Oct 2009 14:19:17 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7656Diana0http://sqlserver.ro/forums/thread/7656.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7656Atunci poate ca ar fi bine sa regandesti procesul? Poti sa ne spui ce faci, pas cu pas?http://sqlserver.ro/forums/thread/7655.aspxThu, 08 Oct 2009 14:03:09 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7655tebbaerty0http://sqlserver.ro/forums/thread/7655.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7655dar vreau sa il fac de fiecare data. format file se face peste un view ce se poate modifica tot tp :(ai inteles bine<br>http://sqlserver.ro/forums/thread/7654.aspxThu, 08 Oct 2009 13:58:17 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7654Diana0http://sqlserver.ro/forums/thread/7654.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7654Vrei sa creezi un "format file"? <br />...atunci nu ar trebui sa ai probleme cu "intrebarile" - fisierul il faci o singura data. <br />Sper ca te-am inteles...http://sqlserver.ro/forums/thread/7653.aspxThu, 08 Oct 2009 13:52:42 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7653tebbaerty0http://sqlserver.ro/forums/thread/7653.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7653trebuie sa fie ori IN or OUT or format. In cazul meu este format . nu ?<br>http://sqlserver.ro/forums/thread/7652.aspxThu, 08 Oct 2009 13:41:44 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7652Diana0http://sqlserver.ro/forums/thread/7652.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7652Incearca sa scoti optiunea "format".http://sqlserver.ro/forums/thread/7651.aspxThu, 08 Oct 2009 13:26:21 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7651tebbaerty0http://sqlserver.ro/forums/thread/7651.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7651Salut,<br><br>Nu stiu daca acesta este locul unde pot intreba asa ceva , dar aveti idee cum as putea automatiza <br><br>bcp tabel_or_view format nul -S "serverName" -U "userName" -P "******" -f FormatFile.xml -x <br><br>momentan daca rulezi aceasta comanda te vei trezi cu o serie de intrebari despre coloane unde trebuie sa dai enter..enter .... pana se termina toate coloanele(daca dai enter se ia default).<br><br>Eu as dori sa sar peste acel enter. .. enter ... si sa pastrez totusi formatul XML. (ceva gen sa ii puna valoarea default automat)<br><br><br>Multumesc anticipat,<br>