Load file

I am using MSSQL 2000, I also using mysql.
I want to know does mssql 2k had a command or function like mysql that (
load data infile.........) this synax?
??X wrote:
> I am using MSSQL 2000, I also using mysql.
> I want to know does mssql 2k had a command or function like mysql
> that ( load data infile.........) this synax?
Look at the BCP utility in BOL. You can also script data out using the
Import Export Wizard.
David Gugick
Imceda Software
www.imceda.com
|||Or the BULK INSERT command...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:OyhifiasEHA.2720@.TK2MSFTNGP12.phx.gbl...
> ??X wrote:
> Look at the BCP utility in BOL. You can also script data out using the
> Import Export Wizard.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
sql

Load file

I am using MSSQL 2000, I also using mysql.
I want to know does mssql 2k had a command or function like mysql that (
load data infile.........) this synax???_ wrote:
> I am using MSSQL 2000, I also using mysql.
> I want to know does mssql 2k had a command or function like mysql
> that ( load data infile.........) this synax?
Look at the BCP utility in BOL. You can also script data out using the
Import Export Wizard.
David Gugick
Imceda Software
www.imceda.com|||Or the BULK INSERT command...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:OyhifiasEHA.2720@.TK2MSFTNGP12.phx.gbl...
> ??_ wrote:
> Look at the BCP utility in BOL. You can also script data out using the
> Import Export Wizard.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>

Load file

I am using MSSQL 2000, I also using mysql.
I want to know does mssql 2k had a command or function like mysql that (
load data infile.........) this synax?¬ÓªÌ¤§­· wrote:
> I am using MSSQL 2000, I also using mysql.
> I want to know does mssql 2k had a command or function like mysql
> that ( load data infile.........) this synax?
Look at the BCP utility in BOL. You can also script data out using the
Import Export Wizard.
--
David Gugick
Imceda Software
www.imceda.com|||Or the BULK INSERT command...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:OyhifiasEHA.2720@.TK2MSFTNGP12.phx.gbl...
> ¬ÓªÌ¤§­· wrote:
>> I am using MSSQL 2000, I also using mysql.
>> I want to know does mssql 2k had a command or function like mysql
>> that ( load data infile.........) this synax?
> Look at the BCP utility in BOL. You can also script data out using the
> Import Export Wizard.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>

little problem..

hey guys, i have a little problem:

i use ASP with MSSQL and i have a query that adds these values to the database:

values(' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ')

when a value is empty, the fields are not filled
but when a value contains a single quote ('), that quote ends the value:

values(' hel'lo ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ')

so my question is, how can i make the quote (') in hel'lo .. invisible or something, so MSSQL wont see it as the end of the value.

(im MYSQL, you can just place a (\) in front of the (') but that doenst work in MSSQL...)use like this :

values(' hel''lo ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ')

-Rohit|||Use one more single quote as the escape character.|||thanx lads! :)

Linux user: creating databases

Hi all.
I just installed MSSQL 2005 Express but I can′t find a sql client I can use to create databases.
Do I have to download it or it′s placed somewhere on my HD?
The only tools I see are placed at Start > Programs > Microsoft SQL Serve 2005 > Configuration Tools
Sorry about the dump question. I come from a linux background and everything seems to be different!
Cheers.
The download for the Express Edition does not include a GUI tool for managing the database. We have posted a pre-release version of the free management GUI tool - Management Studio Express Edition on the web for download. You can get it at: http://www.microsoft.com/downloads/details.aspx?FamilyID=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&DisplayLang=en.

You can also download the documentation for Express at http://www.microsoft.com/downloads/details.aspx?FamilyID=9697aaaa-ad4b-416e-87a4-a8b154f92787&DisplayLang=en.

Out-of-the-box Express includes a command line tool SQLCMD for working with the installation (creating databases, creating tables, etc.) You can read more about it in the documentation.

Good luck.

Dan|||Hi Dan. Thanks for your quick reply!
In the meanwhile I downloaded the trial version (~900mb, outch!!).
How do I import ddl files into a database (trial version)?
Can I do it using theManagement Studio Express Edition too?
Cheers!
|||You can execute your sql script using SQLCMD.exe (from the command line) or using the Management Studio Express GUI.