Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 1273
Home > Interviews > Sql Server >

You want to update the properties of the Suburb (name) column in the Address(employee) table of the temp database. This table is located in the Products schema. The column should now use the nvarchar(150) data type.

Which of the following Transact-SQL statements can you use to accomplish this goal?

 Posted by Rajkatie on 6/30/2013 | Category: Sql Server Interview questions | Views: 5246 | Points: 40
Post | Interview FAQs | Exclusive Questions | Interview Home  
Select from following answers:
  1. ALTER TABLE [Products].[employee] ALTER COLUMN name nvarchar(150)
  2. ALTER TABLE [employee].[ Products] ALTER COLUMN name nvarchar(150)
  3. ALTER COLUMN [Products].[employee].[name] nvarchar(150)
  4. All Above

Show Correct Answer


Source: measureup.com | | Alert Moderator 

Bookmark It

Comments or Responses

Login to post response

More Interview Questions by Rajkatie


Latest Interview Questions