Computer Science Homework Solutions
Problem
#154861

Create a SQL alter table statement to change the name of a column

I have a SQL database table dbo.Mytable which has a column WhatsUpDude.
I need an ALTER Table statement written that will assign the default value of the Windows user name to the WhatsUpDude column.

Solution
What is this?
By OTA - Overall OTA Rating
Debraj Banerjee, MIT (IP) - 4.8/5
Purchase Cost Now
$2.19 CAD (was ~$15.96)
Included in Download
  • Plain text response
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
  • Pagination (PHP) - The purpose of the attach php code searches a MYSQL database and then return the results to the screen. It works very well, just that it displays all the search results all in one screenful. If it ...
  • What are the security features in SQL Server that do not exist in Access? - Help with this questions. What are the security features in SQL Server that do not exist in Access?
  • Please answer and elaborate on the following - What are the various types of clients that can be used to connect to SQL Server 2000 and the network requirements necessary for successful communications between the client and server? How do the ...
  • Need a script that uses a cursor - I am trying to create a script that uses a cursor based on the select statement: SELECT name, database_id FROM sys.databases The scope of the script is to build and execute a BACKUP DATABASE state ...
  • SQL Indexes and Sequences - What are sequences and indexes in database tables? When to use sequence and when to use index?
Browse