Share via

Structured Query Language

Ann Brennan 1 Reputation point
2021-08-10T20:43:54.043+00:00

I am trying to add column to table, used ALTER TABLE, ADD but shows error when I type ADD col.name ki

SQL Server Reporting Services
SQL Server Reporting Services

A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ann Brennan 1 Reputation point
    2021-08-23T08:30:29.207+00:00

    Hi

    This is what I was required to do in my query.
    Write a query that will generate a list showing Product_Names, Prices, Salesdates, before 2020/04/06 and a new colun named discount where €5 is subtracted from sale price. Comany.product is database.

    I found out that I was not required to alter table just add column as Alias.

    Thanks for your help

    Ann

    Was this answer helpful?

    0 comments
  2. Olaf Helper 47,616 Reputation points
    2021-08-11T12:37:55.35+00:00 
    select *
from sys.messages
where message_id = 1064

    Error 1064 = "A filegroup cannot be used with log files."
    I can not imagine that SQL Server throws this error on a simple add column command.

    As Martin already asked for, please post your SQL command and the complete error message, not only a number.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.