SQL_테이블 만들고 넣기

Windows PowerShell
Copyright (C) Microsoft Corporation. All rights reserved.
                                                                                                                        새로운 기능 및 개선 사항에 대 한 최신 PowerShell을 설치 하세요! https://aka.ms/PSWindows PS C:\WINDOWS\system32> netstat -an | find "1443"                                                                       FIND: 매개 변수 형식이 틀립니다.                                                                                        PS C:\WINDOWS\system32> Install-Module -Name SqlServer -AllowClobber -Scope CurrentUser

계속하려면 NuGet 공급자가 필요합니다.
NuGet 기반 리포지토리를 조작하려면 PowerShellGet에 NuGet 공급자 버전 '2.8.5.201' 이상이 필요합니다. 'C:\Program
Files\PackageManagement\ProviderAssemblies' 또는
'C:\Users\SD1-06\AppData\Local\PackageManagement\ProviderAssemblies'에서 NuGet 공급자를 사용할 수 있어야 합니다. 또한
'Install-PackageProvider -Name NuGet -MinimumVersion 2.8.5.201 -Force'를 실행하여 NuGet 공급자를 설치할 수 있습니다.
지금 PowerShellGet에서 NuGet 공급자를 설치하고 가져오시겠습니까?
[Y] 예(Y)  [N] 아니요(N)  [S] 일시 중단(S)  [?] 도움말 (기본값은 "Y"): y

신뢰할 수 없는 리포지토리
신뢰할 수 없는 리포지토리에서 모듈을 설치하는 중입니다. 이 리포지토리를 신뢰하는 경우 Set-PSRepository cmdlet을
실행하여 InstallationPolicy 값을 변경하십시오. 'PSGallery'에서 모듈을 설치하시겠습니까?
[Y] 예(Y)  [A] 모두 예(A)  [N] 아니요(N)  [L] 모두 아니요(L)  [S] 일시 중단(S)  [?] 도움말 (기본값은 "N"): y
PS C:\WINDOWS\system32> Get-Module -ListAvailable -Name SqlServer


    디렉터리: C:\Users\SD1-06\Documents\WindowsPowerShell\Modules


ModuleType Version    Name                                ExportedCommands
---------- -------    ----                                ----------------
Script     22.3.0     SqlServer                           {Add-RoleMember, Add-SqlAvailabilityDatabase, Add-SqlAvail...


PS C:\WINDOWS\system32> sqlcmd -S 127.0.0.1,1433 -U SA -P AKJ1passwd
1> CREATE DATABASE TestDB:
2> go
메시지 102, 수준 15, 상태 1, 서버 sql1, 줄 1
Incorrect syntax near 'TestDB:'.
1> CREATE DATABASE TestDB;
2> go
1> USE TestDB;
2> go
Changed database context to 'TestDB'.
1>
2>
3> CREATE TABLE Users(
4> ID INT PRIMATY KEY IDENTITY(1,1),
5> Username NVARCHAR(50)NOT NULL,
6> Email NVARCHAR(100)NOT NULL
7> );
8> go
메시지 102, 수준 15, 상태 1, 서버 sql1, 줄 4
Incorrect syntax near 'PRIMATY'.
1> CREATE TABLE Users(
2> ID INT PRIMARY KEY IDENTITY(1,1),
3> Username NVARCHAR(50)NOT NULL,
4> Email NVARCHAR(100)NOT NULL
5> );
6> go
1>
2>
3> INSERT INTO Users (Username,Email) VALUES ('ahnkwangjae225','ahnkwangjae225@gmail.com');
4> go

(1개 행 적용됨)
1> SELECT*FROM Users;
2> go
ID          Username                                           Email
----------- -------------------------------------------------- ----------------------------------------------------------------------------------------------------
          1 ahnkwangjae225                                     ahnkwangjae225@gmail.com

(1개 행 적용됨)
1>