删除 [英] Delete

问题描述

我有一张叫做学生的桌子。有一个名为creditsavailable的列。

现在例如说特定学生有500个学分，我想从中删除250个。

我将使用什么删除语句从学生所拥有的500个学分中删除250个学分> ???

I have a table called students. with a column called creditsavailable.
now for example say that the specific student has 500 credits and i would like to delete 250 from it.
what delete statement would i use to delete 250 credits from the 500 credits that the student has >???

推荐答案

我有一个名为学生们。有一个名为creditsavailable的列。

现在例如说特定学生有500个学分，我想从中删除250个。

我将使用什么删除语句从学生所拥有的500个学分中删除250个学分> ???

I have a table called students. with a column called creditsavailable.
now for example say that the specific student has 500 credits and i would like to delete 250 from it.
what delete statement would i use to delete 250 credits from the 500 credits that the student has >???

试试这个：

try this:

展开 | 选择 | Wrap | 行号

谢谢......

我从来不知道一个人能做到这一点，我以前从未使用过类似的东西.....再次感谢。

THANKS....
I never knew a person could do that, i have never used something like that before.....thanks again.

I还有另外一个问题，你可以帮我解决

//


我用BULK INSERT插入一个完整的.csv文件的学生，名字，姓氏等


现在这只会每2个月左右完成一次，比如100名学生购买更多学分和津贴并不想一次做1个更改，使用批量插入如何更换信用值而不重复

学生???


该表的PK是StudentID，现在在CSV文件中我有2列是StudentID和CreditsAvailable，现在可以更新那些学生的学分???


请帮助：（

I have another problem thati u can mayb help me out with
//

I use a BULK INSERT to insert a entire .csv file of students, name, surname etc

now this will only be done like every 2 months or so, say the 100 students bought more credits and the admin doesnt want to do the changes 1 at a time, using the bulk insert how can u replace the credit values without duplicating the
students ???

the PK for the table is the StudentID, now in the CSV file i have 2 columns which are StudentID and CreditsAvailable, now is it possible just to update the credits for those students ???

PLEASE HELP :(

这篇关于删除的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！