SQL Server for python - goddes4/python-study-wiki GitHub Wiki

Command line

> sqlcmd -S tykim-dev\sqlexpress

μ„œλ²„ 이름 및 μΈμŠ€ν„΄μŠ€ 이름

> select @@servername

λ³΄μ•ˆ 인증 λͺ¨λ“œλ₯Ό λ³€κ²½

  1. SQL Server Management Studio 개체 νƒμƒ‰κΈ°μ—μ„œ μ„œλ²„λ₯Ό 마우슀 였λ₯Έμͺ½ λ‹¨μΆ”λ‘œ ν΄λ¦­ν•œ λ‹€μŒ 속성을 ν΄λ¦­ν•©λ‹ˆλ‹€.
  2. λ³΄μ•ˆ νŽ˜μ΄μ§€μ˜ Server μΈμ¦μ—μ„œ μƒˆ μ„œλ²„ 인증 λͺ¨λ“œλ₯Ό μ„ νƒν•œ 후에 확인을 ν΄λ¦­ν•©λ‹ˆλ‹€.
  3. SQL Serverλ₯Ό λ‹€μ‹œ μ‹œμž‘ν•©λ‹ˆλ‹€.

sa ν™œμ„±ν™”

Transact-SQL을 μ‚¬μš©ν•˜μ—¬ sa λ‘œκ·ΈμΈμ„ μ„€μ •ν•˜λ €λ©΄ λ‹€μŒ 문을 μ‹€ν–‰ν•˜μ—¬ sa μ•”ν˜Έλ₯Ό μ„€μ •ν•˜κ³  μ•”ν˜Έλ₯Ό ν• λ‹Ήν•©λ‹ˆλ‹€.

ALTER LOGIN sa ENABLE ;
GO
ALTER LOGIN sa WITH PASSWORD = '<password>' ;
GO

ν˜„μž¬ λ‚ μ§œ

select getdate()

λ†ν˜‘ ν…Œμ΄λΈ” μ •μ˜

USE [naisdb]
GO

/****** Object:  Table [dbo].[TB_NA_FD_GM_GOOD]    Script Date: 2016-07-26 μ˜€μ „ 11:26:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[TB_NA_FD_GM_GOOD](
	[NA_BZPLC] [numeric](13, 0) NOT NULL,
	[NA_WRS_C] [numeric](13, 0) NOT NULL,
	[SHRT_WRSNM] [varchar](50) NOT NULL,
	[WRS_STDNM] [varchar](50) NOT NULL,
	[SEL_UPR] [numeric](12, 2) NOT NULL,
	[LSCHG_DTM] [datetime] NOT NULL
) ON [PRIMARY]

GO

SQL Server 접속

import pymssql
conn = pymssql.connect(server='localhost', user='sa', password='1234', database='dbname')
cursor = conn.cursor()  
cursor.execute("SELECT * FROM dbo.TB_NA_FD_GM_GOOD")
row = cursor.fetchone()  
while row:  
    print(row[0], row[1], row[2])     
    row = cursor.fetchone()
Add a custom footer
⚠️ **GitHub.com Fallback** ⚠️