MS SQL Server 的 bulk insert permission - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

MS SQL Server 的 bulk insert permission

MS SQL Server 的 bulk insert permission# Database - 数据库

h*j2012-01-30 08:01

1 楼

Xbox Live负责人Major Nelson今日宣布，《魂斗罗铁血军团》《火爆赛车》《弹魂》
《弹魂：无限爆发》《虫虫军团》等五款游戏加入Xbox One向下兼容列表，至此支持
Xbox One向下兼容的游戏已经超过330款。
像以前一样，如果你已经在Xbox 360上购买过这些游戏，则他们会自动出现在你的游戏
列表中；如果你还没买过，可以在Xbox Store的向下兼容游戏分类中找到他们。
向下兼容是Xbox One推出的一项重要服务，此前Phil Spencer曾表示有近50%的Xbox
One拥有者游玩了这些向下兼容的游戏作品，对比Xbox One的销量，可以说这是一个非
常庞大的群体。对于这样的成绩，Phil Spencer感到非常高兴，最后也感谢玩家对于向
下兼容功能的支持。

O*e2012-01-30 08:01

2 楼

http://www.youtube.com/watch?v=hLQl3WQQoQ0
Adele
Someone like you
I heard that you're settled down
That you found a girl and you're married now.
I heard that your dreams came true.
Guess she gave you things I didn't give to you.
Old friend, why are you so shy?
Ain't like you to hold back or hide from the light.
I hate to turn up out of the blue uninvited
But I couldn't stay away, I couldn't fight it.
I had hoped you'd see my face and that you'd be reminded
That for me it isn't over.
Never mind, I'll find someone like you
I wish nothing but the best for you too
Don't forget me, I beg
I remember you said,
"Sometimes it lasts in love but sometimes it hurts instead,
Sometimes it lasts in love but sometimes it hurts instead"
You know how the time flies
Only yesterday was the time of our lives
We were born and raised
In a summer haze
Bound by the surprise of our glory days
I hate to turn up out of the blue uninvited
But I couldn't stay away, I couldn't fight it.
I'd hoped you'd see my face and that you'd be reminded
That for me it isn't over.
Never mind, I'll find someone like you
I wish nothing but the best for you too
Don't forget me, I beg
I remember you said,
"Sometimes it lasts in love but sometimes it hurts instead."
Nothing compares
No worries or cares
Regrets and mistakes
They are memories made.
Who would have known how bittersweet this would taste?
Never mind, I'll find someone like you
I wish nothing but the best for you
Don't forget me, I beg
I remember you said,
"Sometimes it lasts in love but sometimes it hurts instead."
Never mind, I'll find someone like you
I wish nothing but the best for you too
Don't forget me, I beg
I remember you said,
"Sometimes it lasts in love but sometimes it hurts instead,
Sometimes it lasts in love but sometimes it hurts instead."

g*r2012-01-30 08:01

3 楼

请问要 bulk insert 就一定要是 bulkadmin 吗。
I don't want to give bulkadmin to everybody in the team, but they have to
run a stored procedure that has a bulk insert statement. Is there other ways
to grant them permissions? Thank you.

y*w2012-01-30 08:01

4 楼

做个表，比如叫做bulk_request，上面放个trigger可以根据insert的内容bulk insert
。你只要给他们insert就行了。善后的可以用pipe或某字段或另一个表通知他们干完
活儿了。怕滥用的话加些constraint。

have to
other
ways

【在 g*****r 的大作中提到】

: 请问要 bulk insert 就一定要是 bulkadmin 吗。
: I don't want to give bulkadmin to everybody in the team, but they have to
: run a stored procedure that has a bulk insert statement. Is there other ways
: to grant them permissions? Thank you.

g*r2012-01-30 08:01

5 楼

谢，头像照片很可爱地说。

insert

【在 y****w 的大作中提到】

: 做个表，比如叫做bulk_request，上面放个trigger可以根据insert的内容bulk insert
: 。你只要给他们insert就行了。善后的可以用pipe或某字段或另一个表通知他们干完
: 活儿了。怕滥用的话加些constraint。
:
: have to
: other
: ways