SQL --Ejecutar comandos del sistema desde Transact-sql
Ejecutar comandos del sistema desde Transact-sql
Una de las múltiples opciones que tiene SQL Server es ejecutar comandos del sistema operativo desde Transact-SQL. Probablemente no es una de las opciones más utilizadas pero a veces es necesario recurrir a ella.
Para realizar esta acción utilizaremos un Extended Stored Procedure que incorpora SQL Server en la base de datos master, xp_cmdshell:
xp_cmdshell {'command_string'} [, no_output]
'command_string', es la sentencia del sistema que ejecutara
no_output, Es un parámetro opcional para que no devuelva nada.
Ejemplo:
xp_cmdshell 'dir.exe c:\*.*'
Mas Informacion:
Una de las múltiples opciones que tiene SQL Server es ejecutar comandos del sistema operativo desde Transact-SQL. Probablemente no es una de las opciones más utilizadas pero a veces es necesario recurrir a ella.
Para realizar esta acción utilizaremos un Extended Stored Procedure que incorpora SQL Server en la base de datos master, xp_cmdshell:
xp_cmdshell {'command_string'} [, no_output]
'command_string', es la sentencia del sistema que ejecutara
no_output, Es un parámetro opcional para que no devuelva nada.
Ejemplo:
xp_cmdshell 'dir.exe c:\*.*'
Mas Informacion:
posted by JEGI at 2:47 p. m.
3 Comments:
top [url=http://www.c-online-casino.co.uk/]uk bonus casino[/url] check the latest [url=http://www.realcazinoz.com/]online casinos[/url] free no set aside bonus at the chief [url=http://www.baywatchcasino.com/]no lay gratuity
[/url].
[url=http://longchampsoldesk.xanga.com/]sac longchamp moins cher[/url] They Cheapest Mulberry Bayswater Natural Leather Briefcase Brown for Men,Sale Mulberry Handbags in a range of styles. explain how to locate bargain copies of modern classics--or the real things--and how to mix flea-market or thrift-store finds with high-end basics. The second part of the book, Putting It All Together, shows how to incorporate the style in every room--from the spaces where you cook, eat, sleep, or relax to bathing spaces and work spaces. The book ends with an extensive directory of suppliers.
[url=http://www.benimblog.com/longchampbagsd/]sac longchamps[/url] Dehydrated food is not all bad. Buying your own dehydrator will allow you to customize your meal options to just about anything your mind can cook up. Dehydrators are relatively inexpensive and easy to use. Overall, the N2N Poop Patrol Dispenser is a great device for keeping pet waste bags by your side at Highly Appreciated Mulberry Women's Bayswater Leather Toter Black Bag, and our shop provides quality Mulberry bags, handbags, purses on sale prices and big discount. all times, but out of the way enough that they aren a burden to carry. They always be with you, and if you leave the dispenser on the leash during non use, you never have to worry about remembering bags. The construction is pretty durable, the ease of use is great, and it does what it should do..
[url=http://longchamppliagea.busythumbs.com/]sac longchamps[/url] One of these simple add-ons may be the handbag because it can complement the gown and add a feeling of perfection towards the women. I share info on items from wallet size Evening Bag Online towards the large totebag and my way through between! Most of the counterfeit handbags simulate this property. When you are getting solutions which are confusing this will call forth indicators. Check carefully to make sure the handbag you're considering purchasing is in good shape. If you notice stains or indications of deterioration on a prospective buy, you should pass it up. However, if the wear and tear is negligible, it might be possible to repair and restore it. Handbags and purses are an integral part of fashion industry. With people seeking to be dressed to perfection always, they refuse to ignore this very important aspect for the overall look. This object of utility has been converted into a fashion accessory and an industry so vast Adorable Mulberry Women's Smaller Bayswater Printed Leather Shoulder Black Bag with big discount that people all across the world can connect to it..
http://news1.equities.com/2013/05/16/1416195.html Majority of Western public against sanctions on Press TV: Survey [Press TV (Iran)]Al Bawaba Ltd.An IRS poll asking a total of 6,121 people in Britain, Canada, France, Germany, Spain and the United States indicates that 73-85 percent of the respondents aware of the sanction on Press TV are against the bans. Moreover, 65 percent opposed the imposition of sanctions on Iran because of the Islamic Republic's political standpoint, while 88 percent [url=http://www.agoshow.net/Reds-19-Botto-Black-2011-All-Star-Jerseys-100/]Reds 19 Botto Black 2011 All Star Jerseys[/url] opposed banning Iranian media only due to their country of origin. The [url=http://www.agoshow.net/Rays-3-Evan-Longoria-red-2010-All-Star-Jerseys-44/]Rays 3 Evan Longoria red 2010 All Star Jerseys[/url] opinion poll [url=http://www.agoshow.net/Mets-5-David-Wright-Road-Cool-Base-Grey-2010-All-Star-Jerseys-76/]Mets 5 David Wright Road Cool Base Grey 2010 All Star Jerseys[/url] also found out that 90 percent of the respondents believe in the unrestricted expression of various political viewpoints and 77 percent consider sanctions on media as a violation of freedom of speech. Among the people questioned in the survey, the French and Spaniards were most vociferous against media restrictions, with 87 and 86 percent respectively rejecting [url=http://www.agoshow.net/2009-World-Baseball-Classic-15-Beltran-white-jersey-24/]2009 World Baseball Classic 15 Beltran white jersey[/url] any such sanctions. Press TV and other Iranian broadcasters have been repeatedly targeted by restrictive measures spearheaded by Zionist Israeli elements. In January, the Arab satellite provider Gulfsat banned Iran's movie channel iFilm and its Arabic-language Al-Kawthar under direct pressure from the European satellite company, Eutelsat. The decision came one day after Eutelsat, owned by Franco-Israeli Michel de Rosen, asked Nilesat to take Press TV off the air. On December 21, 2012, HispaSat took Iran's Press TV and Hispan TV off the air, and ordered Overon, a subsidiary satellite company, [url=http://www.agoshow.net/2010-All-Star-Jerseys-Patch-26/]2010 All Star Jerseys Patch[/url] to stop the transmission of the two international TV channels. In November 2012, the Hong Kong-based Asia Satellite Telecommunications Co. Ltd. (AsiaSat) also took Iranian channels off the air in East Asia. Last October, Eutelsat SA and Intelsat SA stopped the broadcast of several Iranian satellite channels, citing pressure by the European Union. The EU, however, denied the claims by the European satellite companies. MRS/HMV
[url=]more[/url]
Publicar un comentario
<< Home