REQUEST---> Tutorial how to make a query

[killerflood]

Hello all,

I want to request a tutorial how to make query's.
Since i want to add the Sro-R skills, i should have to add many rows. but to do that all with the hand... no thanks...

With this rows i have to do it...

(CHeck the link.)



Thanks allot.

Greetings,

[katasuki]

ever heard of Copy Paste ?

you can use this as well for example... Im not sure if it works !!

BULK INSERT dbo.NAME FROM 'C:\Path\notepadname.txt' WITH(
DATAFILETYPE = 'widechar',
FIELDTERMINATOR = ' ',
ROWTERMINATOR = '\n'
)
GO

change the red fields with your database table and .txt path

[killerflood]

Originally Posted by katasuki

ever heard of Copy Paste ?

you can use this as well for example... Im not sure if it works !!


change the red fields with your database table and .txt path

Copy paste doesnt work with me, dunno how...

Im gonna test it soon, thanks!

Doesnt work!!

[katasuki]

As i said, i wasn't sure that it's gonna work, since i can't try by my self =D And that query i copied from somerwhere from i-net =D.
But you can try use Update instead of Insert.
I dont know sql, i just tried it once
I could try it to do it, but i don't have time ..

[killerflood]

Does not work either to badly...

Thanks anyway.