Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amirs
Constraint Violating Yak Guru
260 Posts |
 Posted - 2008-05-28 : 06:09:29
|
| hican any help i have import table to csv file to append , replace, delete condition |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-05-28 : 06:21:56
|
| I take it you mean you need to import a csv file and update a table from it?Import to a staging table using bulk insert then update the table from there.Alternatively use SSIS to update the table without a staging table - the first way is simpler.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
amirs
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-05-28 : 06:57:06
|
| how can write procedure please help |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-05-28 : 15:42:31
|
| Do you know anything about t-sql?Have you made an attempt or a start?Which part are you having problems with?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
amirs
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-05-29 : 00:34:46
|
| i am new in t-sql how can i start to write procedure |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-29 : 01:40:47
|
| Look into books online for CREATE PROCEDURE syntax and usage or refer link below:-[url]http://msdn.microsoft.com/en-us/library/aa258259(SQL.80).aspx[/url] |
|
|
|
|
|
|
import table to csv file