| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | |||
| 5 | 6 | 7 | 8 | 9 | 10 | 11 |
| 12 | 13 | 14 | 15 | 16 | 17 | 18 |
| 19 | 20 | 21 | 22 | 23 | 24 | 25 |
| 26 | 27 | 28 | 29 | 30 | 31 |
- NPM
- xPlatform
- 보조정렬
- window
- SSL
- GIT
- vaadin
- Python
- R
- Java
- Spring
- tomcat
- mybatis
- JavaScript
- SPC
- react
- 공정능력
- Eclipse
- hadoop
- MSSQL
- Sqoop
- table
- SQL
- Android
- Kotlin
- Express
- plugin
- IntelliJ
- mapreduce
- es6
- Today
- Total
목록전체 글 (672)
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..
