Just another way to do this with Powershell:

Invoke-Sqlcmd -Query "SELECT * FROM your_table;" -ServerInstance yourserver -Database yourdatabase | export-csv your.csv

It can also be scheduled as you will any other...

Are you trying your hand at creating a database for your own business or is this just homework?

noy2014 (7/12/2014)

---

I am new to php and sql, but learning fast. I'm trying to understand the behavior of the db when importing data files using phpMyAdmin. Here is what...

Joe Contreras-290946 (7/9/2014)

---

Hi,

I created an ETL process using C# (SSIS was not available) and ran into some issues with one of the fields.

I have a [description] that contains...

You would have had to have had some kind of change tracking in place...

Andrew in WV (6/21/2012)

---

ColdCoffee (2/16/2012)

---

THere is something called as Output Parameters while defining a Stored Procedures. Thats what you are looking for .

Here is the link : CREATE PROCEDURE

To...

cadam (4/14/2014)

---

Hello forum. I want to introduce myself as Adam. I am a self starter and self motivated learning. I am an Electrical Engineer by trade but...

I very much agree with what Grant has said here.

I doubt you'd find consensus on the "best" tool to do any kind of monitoring on account of varying needs and...

jimbeam10 (4/3/2014)

---

Hi, i have a stored procedure which uses the DB2OLEDB driver which i use to connect to an AS400 database. When the MSSQL job calls the Stored Proc i...

This post goes into a bit more detail:

http://sqlinthewild.co.za/index.php/2011/03/08/full-backups-the-log-chain-and-the-copy_only-option/

robertsquednau (3/26/2014)

---

OK lets start with the basics. This is day 1 of learning to script in sql for me so please correct me if I'm making an assuption to do...

1. You would do well to get yourself a copy of SQL Server Developer Edition (It's relatively cheap) and install it on your laptop or machine so you have...

ben.brugman (3/25/2014)

---

Similar question from here.

Regulary I want to import Excel files. (Or CSV files).

Extention is known.

Format is not predetermined.

Is there a solution for this ?

A general solution which imports data...

I didn't write it 🙂 ... but you are very welcome.

Just to clarify...

If you are receiving what is essentially the same file but it could be in differing formats (.csv, .txt, .xls etc) then, by far, the easiest thing to...