[MS-SQL] CentOS 7에 sqlcmd, bcp 설치

[root@nas ~]# curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/msprod.repo % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 192 100 192 0 0 442 0 --:--:-- --:--:-- --:--:-- 443 yum microsoft repository 설치 [root@nas ~]# yum -y install mssql-tools unixODBC-devel Loaded plugins: fastestmirror, langpacks Loading mir..

  • format_list_bulleted MS-SQL
  • · 2023. 6. 21.
  • textsms

[MS-SQL] 권한 부여 쿼리 생성

USE Database; SELECT 'GRANT SELECT, UPDATE, INSERT, DELETE ON "' + TABLE_SCHEMA + '"."' + TABLE_NAME + '" TO "username"' AS query FROM information_schema.tables ORDER BY query; 원하는 권한 (SELECT, UPDATE, INSERT, DELETE)에 맞게 사용

  • format_list_bulleted MS-SQL
  • · 2023. 6. 21.
  • textsms

[MS-SQL] Database별 커넥션 개수 확인

SELECT DB_NAME(dbid) as DBName, COUNT(dbid) as NumberOfConnections, loginame as LoginName FROM sys.sysprocesses WHERE dbid > 0 GROUP BY dbid, loginame;

  • format_list_bulleted MS-SQL
  • · 2023. 6. 21.
  • textsms

[MS-SQL] 프로시저 안에서 특정 컬럼을 SELECT하는 프로시저명 찾기

SELECT obj.Name SPName, sc.TEXT SPText FROM sys.syscomments sc INNER JOIN sys.objects obj ON sc.Id = obj.OBJECT_ID WHERE sc.TEXT LIKE '%' + '컬럼명' + '%' AND TYPE = 'P'

  • format_list_bulleted MS-SQL
  • · 2023. 6. 20.
  • textsms

[MS-SQL] 필수 쿼리

테이블 생성 (PK와 같이) CREATE TABLE Person ( Id INT NOT NULL, LastName VARCHAR(255) NOT NULL, FirstName VARCHAR(255), Age INT CONSTRAINT DF_Person_Age DEFAULT 0, CONSTRAINT PK_Persons PRIMARY KEY (Id, LastName) ); 테이블 생성 (PK 없이) CREATE TABLE Person ( Id INT NOT NULL, LastName VARCHAR(255) NOT NULL, FirstName VARCHAR(255), Age INT ); PK 추가 ALTER TABLE Person ADD CONSTRAINT PK_Person PRIMARY KEY (Id); PK..

  • format_list_bulleted MS-SQL
  • · 2023. 6. 10.
  • textsms

[MS-SQL] Docker Container 설치

docker run \ -d \ --name sql-server \ --restart=unless-stopped \ -e "ACCEPT_EULA=Y" \ -e "MSSQL_SA_PASSWORD=Mssql_Password" \ -p 1433:1433 \ -d \ mcr.microsoft.com/mssql/server:2022-latest username: sa password: Mssql_Password 비밀번호는 소문자, 대문자, 특수문자 포함해야 함

  • format_list_bulleted MS-SQL
  • · 2023. 6. 10.
  • textsms
반응형