Update Data in the Table with Management Studio GUI

Microsoft SQL Server 2017 for Everyone Manipulating Tables and Data
2 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$69.99
List Price:  $99.99
You save:  $30
€64.56
List Price:  €92.23
You save:  €27.67
£55.01
List Price:  £78.59
You save:  £23.58
CA$96.01
List Price:  CA$137.16
You save:  CA$41.15
A$105.78
List Price:  A$151.13
You save:  A$45.34
S$94.50
List Price:  S$135.01
You save:  S$40.50
HK$546.82
List Price:  HK$781.20
You save:  HK$234.38
CHF 64.02
List Price:  CHF 91.46
You save:  CHF 27.44
NOK kr743.24
List Price:  NOK kr1,061.82
You save:  NOK kr318.58
DKK kr481.69
List Price:  DKK kr688.17
You save:  DKK kr206.47
NZ$114.53
List Price:  NZ$163.63
You save:  NZ$49.09
د.إ257.07
List Price:  د.إ367.26
You save:  د.إ110.19
৳8,236.66
List Price:  ৳11,767.17
You save:  ৳3,530.50
₹5,817.67
List Price:  ₹8,311.31
You save:  ₹2,493.64
RM329.75
List Price:  RM471.10
You save:  RM141.34
₦101,485.50
List Price:  ₦144,985.50
You save:  ₦43,500
₨19,541.46
List Price:  ₨27,917.57
You save:  ₨8,376.10
฿2,567.54
List Price:  ฿3,668.07
You save:  ฿1,100.53
₺2,256.81
List Price:  ₺3,224.15
You save:  ₺967.34
B$360.07
List Price:  B$514.41
You save:  B$154.34
R1,286.74
List Price:  R1,838.28
You save:  R551.54
Лв126.27
List Price:  Лв180.40
You save:  Лв54.12
₩95,598.53
List Price:  ₩136,575.19
You save:  ₩40,976.65
₪256.95
List Price:  ₪367.08
You save:  ₪110.13
₱4,074.18
List Price:  ₱5,820.51
You save:  ₱1,746.33
¥10,986.96
List Price:  ¥15,696.33
You save:  ¥4,709.37
MX$1,168.64
List Price:  MX$1,669.55
You save:  MX$500.91
QR256.05
List Price:  QR365.81
You save:  QR109.75
P949.66
List Price:  P1,356.72
You save:  P407.05
KSh9,273.67
List Price:  KSh13,248.67
You save:  KSh3,975
E£3,300.12
List Price:  E£4,714.66
You save:  E£1,414.54
ብር4,034.35
List Price:  ብር5,763.61
You save:  ብር1,729.25
Kz59,523.20
List Price:  Kz85,036.79
You save:  Kz25,513.59
CLP$63,672
List Price:  CLP$90,963.90
You save:  CLP$27,291.90
CN¥497.62
List Price:  CN¥710.91
You save:  CN¥213.29
RD$4,127.47
List Price:  RD$5,896.64
You save:  RD$1,769.17
DA9,410.85
List Price:  DA13,444.65
You save:  DA4,033.79
FJ$158.71
List Price:  FJ$226.74
You save:  FJ$68.02
Q545.60
List Price:  Q779.46
You save:  Q233.86
GY$14,698.27
List Price:  GY$20,998.43
You save:  GY$6,300.16
ISK kr9,664.91
List Price:  ISK kr13,807.61
You save:  ISK kr4,142.70
DH698.43
List Price:  DH997.80
You save:  DH299.37
L1,241.62
List Price:  L1,773.82
You save:  L532.20
ден3,987.30
List Price:  ден5,696.40
You save:  ден1,709.09
MOP$564.71
List Price:  MOP$806.77
You save:  MOP$242.05
N$1,285.96
List Price:  N$1,837.16
You save:  N$551.20
C$2,584.60
List Price:  C$3,692.45
You save:  C$1,107.84
रु9,349.97
List Price:  रु13,357.68
You save:  रु4,007.70
S/262.08
List Price:  S/374.42
You save:  S/112.33
K272.89
List Price:  K389.87
You save:  K116.97
SAR262.50
List Price:  SAR375.02
You save:  SAR112.51
ZK1,859.01
List Price:  ZK2,655.84
You save:  ZK796.83
L321.09
List Price:  L458.72
You save:  L137.63
Kč1,596.60
List Price:  Kč2,280.96
You save:  Kč684.35
Ft24,869.15
List Price:  Ft35,528.88
You save:  Ft10,659.73
SEK kr749.47
List Price:  SEK kr1,070.73
You save:  SEK kr321.25
ARS$62,310.03
List Price:  ARS$89,018.15
You save:  ARS$26,708.11
Bs485.20
List Price:  Bs693.17
You save:  Bs207.97
COP$268,127.80
List Price:  COP$383,056.14
You save:  COP$114,928.33
₡36,004.57
List Price:  ₡51,437.31
You save:  ₡15,432.73
L1,735.35
List Price:  L2,479.18
You save:  L743.82
₲528,059.90
List Price:  ₲754,403.63
You save:  ₲226,343.72
$U2,693.41
List Price:  $U3,847.90
You save:  $U1,154.48
zł275
List Price:  zł392.87
You save:  zł117.87
Already have an account? Log In

Transcript

Hey guys, in this video, we will be looking at how you go about updating records or making changes to existing records using the tools that the studio the Management Studio has given to you. So we had looked at it in a previous video when we looked at inserting records, and we had gone to the table that we would want and right clicked it and then we said edit top 200 rows. And that actually literally allows us to edit or update this data. So by doing so we got this grid form of the data. And from this view, we can actually modify the query that is giving us this data here by clicking that SQL, so SQL pain, it may be in a different position based on your screen on your resolution, but you can just look for it right there. And it would show you the actual query that is being executed.

So if you want more rows would have seen from our select statements that you can see top 200 or top 1000. Or you can change it to what you want. By default, it's giving us the top 200. And this grid actually allows us to go in and make a change as we please. So we could insert a new rule, or we can modify an existing role. So I can change this students 11 to lastname, Wilburn, and this one for Troy.

And then we press enter, and that change is made. And that is how you would go about updating. Mostly if you put in an invalid value, then that updates would not go through and the editor would give you an error message. And here you see that this error message came up saying that the value one is not a valid value, or the type of column that we're using, which is the date time it will not commit that change until it gets legitimately It's value. So I'm just going to re enter date of birth and press Enter. And there you go.

It has been updated. So that's how you go about updating using the SQL Management Server studio.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.