DBILITY

USE MASTERGOCREATE DATABASE [DB명]GOCREATE LOGIN [LOGIN명] WITH PASSWORD='비밀번호'GOALTER LOGIN [LOGIN명] EnableGOUSE [DB명]GOCREATE USER [USER명] FOR LOGIN [LOGIN명] WITH DEFAULT_SCHEMA = dboGOEXEC sp_addrolemember db_owner, [USER명]GO--GRANT ALL TO [USER명]--GO기억은 못하겠고 적어 두자.

VS2017. Nuget Manager에서 ExcelDataReader, ExcelDataReader.DataSet 버전 3.8.0 을 설치한다.UI는 코드보고 그냥 그리고, 코딩하고 실행해 보면 그리드에 잘 표시된다.using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.IO;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;using ExcelDataReader;namespace CSharpTest{ public..

VS2017에서 Nuget Manager에서 Fody 4.2.1, Costura.Fody 3.3.3를 설치하고 재시작,Build를 해보면 exe의 용량이 늘어나 있음

driver가 필요하니 pymssql installpip install pymssqldb_test.pyimport pymssqlserver = "localhost"user = "사용자"password = "비밀번호"database = "대상 데이터베이스명"try: conn = pymssql.connect(server=server, user=user, password=password, database=database) cursor = conn.cursor() sql = """ SELECT A, B, C, D FROM DUMMY_TABLE """ cursor.execute(sql) rows = cursor.fetchall() for row in rows: ..

pip = package installer for pythoninstallpip install package_nameorpython.exe -m pip install package_nameupgradepip install --upgrade package_nameorpython.exe -m pip install --upgrade package_nameuninstallpip uninstall package_nameC:\Python\Python313>pip listPackage Version------- -------pip 25.2C:\Python\Python313>pip install tensorflowCollecting tensorflow Using cached tensorflow-2.20.0-c..