后端服务器如何把收到的数据放到数据库

有两种方法，第一，把你的图片转成字节流，然后用post方法把字节流传到服务端，然后服务端接收到字节流之后，开启一个线程把它重新压缩成图片，保存在某个文件夹下面。

第二，开启一个线程，用socket直接把图片放到stream中传到服务端，服务端接收后保存到文件夹下。

Transact-SQL 参考

BULK INSERT

以用户指定的格式复制一个数据文件至数据库表或视图中。

语法

BULK INSERT [ [ 'database_name'.][ 'owner' ].]{ 'table_name' FROM 'data_file' }

[ WITH

(

[ BATCHSIZE [ = batch_size ] ]

[ [ , ] CHECK_CONSTRAINTS ]

[ [ , ] CODEPAGE [ = 'ACP' | 'OEM' | 'RAW' | 'code_page' ] ]

[ [ , ] DATAFILETYPE [ =

{ 'char' | 'native'| 'widechar' | 'widenative' } ] ]

[ [ , ] FIELDTERMINATOR [ = 'field_terminator' ] ]

[ [ , ] FIRSTROW [ = first_row ] ]

[ [ , ] FIRE_TRIGGERS ]

[ [ , ] FORMATFILE = 'format_file_path' ]

[ [ , ] KEEPIDENTITY ]

[ [ , ] KEEPNULLS ]

[ [ , ] KILOBYTES_PER_BATCH [ = kilobytes_per_batch ] ]

[ [ , ] LASTROW [ = last_row ] ]

[ [ , ] MAXERRORS [ = max_errors ] ]

[ [ , ] ORDER ( { column [ ASC | DESC ] } [ ,...n ] ) ]

[ [ , ] ROWS_PER_BATCH [ = rows_per_batch ] ]

[ [ , ] ROWTERMINATOR [ = 'row_terminator' ] ]

[ , [ TABLOCK ] ]

)

]

---