microsoft / microsoft/sql-server-samples
Syntax error on comma
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 11.2k
- Forks
- 9.1k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 14
Description
Hi,
I am trying to change datatype for two columns at a time, but receiving error stating - Incorrect syntax near ','. Syntax is given below.
Alter Table Trail14
Alter Column ID Int,
Alter column Weight Decimal;
Please let me know can Datatype, or alter column or constraint can be changed for multiple columns at a time?
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
The issue names only the SQL statement for Trail14 and does not identify a repository file, test, or entry point. Start by reviewing the reported ALTER TABLE syntax in the context of SQL Server samples and determine whether this repository contains a relevant sample to update. Done means the supported multi-column datatype or constraint guidance is clear and verified against the appropriate SQL Server behavior.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 20/100