반응형
[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..
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)에 맞게 사용
SELECT DB_NAME(dbid) as DBName, COUNT(dbid) as NumberOfConnections, loginame as LoginName FROM sys.sysprocesses WHERE dbid > 0 GROUP BY dbid, loginame;
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'
테이블 생성 (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..
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 비밀번호는 소문자, 대문자, 특수문자 포함해야 함