microsoft / microsoft/sql-server-samples

some error on https://www.microsoft.com/en-us/sql-server/developer-get-started/python/mac/step/2.html

Open
#544 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
PowerShell
Stars
11.2k
Forks
9.1k
Avg merge
2d 7h
Merged PRs (30d)
14

Description

on "Step 2.3 Create a Python app that connects to SQL Server and executes queries"

sqlcmd -S localhost -U sa -P your_password -Q "USE DATABASE SampleDB; CREATE TABLE Employees (Id INT IDENTITY(1,1) NOT NULL PRIMARY KEY, Name NVARCHAR(50), Location NVARCHAR(50));"

sqlcmd -S localhost -U sa -P your_password -Q "USE DATABASE SampleDB; INSERT INTO Employees (Name, Location) VALUES (N'Jared', N'Australia'), (N'Nikita', N'India'), (N'Tom', N'Germany');"

it may should be

sqlcmd -S localhost -U sa -P your_password -Q "USE SampleDB; CREATE TABLE Employees (Id INT IDENTITY(1,1) NOT NULL PRIMARY KEY, Name NVARCHAR(50), Location NVARCHAR(50));"

sqlcmd -S localhost -U sa -P your_password -Q "USE SampleDB; INSERT INTO Employees (Name, Location) VALUES (N'Jared', N'Australia'), (N'Nikita', N'India'), (N'Tom', N'Germany');"

this error also found at
https://www.microsoft.com/en-us/sql-server/developer-get-started/python/rhel/step/2.html
https://www.microsoft.com/en-us/sql-server/developer-get-started/python/sles/step/2.html
https://www.microsoft.com/en-us/sql-server/developer-get-started/python/ubuntu/step/2.html
https://www.microsoft.com/en-us/sql-server/developer-get-started/python/windows/step/2.html

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the Step 2.3 instructions on the macOS, RHEL, SLES, Ubuntu, and Windows URLs listed in the issue, and verify the two sqlcmd examples. Done means the commands use the correct database syntax consistently on all five pages.

Written by the indexing model from the issue text.

Assessment

Tech stack
python, sql
Domain
databases, documentation
Issue type
Documentation
Difficulty
1/5
Estimated time
Under an hour
Activity status
Stale
Clarity
Clearly specified
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.