DexCore.Net

WITH BOM_CTE(P_ITEM_CD, C_ITEM_CD, LEVEL) AS ( SELECT T.P_ITEM_CD, T.C_ITEM_CD, 1 AS LEVEL FROM bba020t_2 T WHERE T.P_ITEM_CD in ('HU3723-V') UNION ALL SELECT C.P_ITEM_CD, C.C_ITEM_CD, LEVEL+1 FROM bba020t_2 C INNER JOIN BOM_CTE P ON C.P_ITEM_CD = P.C_ITEM_CD --WHERE C.P_ITEM_CD in ('HU3723-V') ) SELECT P_ITEM_CD, C_ITEM_CD, MAX(LEVEL) AS LEVEL FROM BOM_CTE --WHERE P_ITEM_CD in ('HU3723-V') GROU..

DataBase/SQL Server 2008. 4. 1. 10:12

STEP 1. STEP2. STEP3. STEP4. STEP5. STEP6. STEP7. STEP8. STEP9.

DataBase/SQL Server 2008. 4. 1. 10:11

DB에 있는 table사용량 체크 SET NOCOUNT ON CREATE TABLE #TBLSize (Tblname varchar(80), TblRows int, TblReserved varchar(80), TblData varchar(80), TblIndex_Size varchar(80), TblUnused varchar(80)) DECLARE @DBname varchar(80) DECLARE @tablename varchar(80) SELECT @DBname = DB_NAME(DB_ID()) PRINT 'User Table size Report for (Server / Database): ' + @@ServerName + ' / ' + @DBName PRINT '' PRINT 'By Size Desc..

DataBase/SQL Server 2008. 4. 1. 10:10

시스템의 모든 테이블 정보 if exists (select * from sysobjects where id = object_id(N'[dbo].[conv_tables_fields]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[conv_tables_fields] GO CREATE TABLE [dbo].[conv_tables_fields] ( [TABLE_QUALIFIER] [nvarchar] (128) NULL , [TABLE_OWNER] [nvarchar] (128) NULL , [TABLE_NAME] [nvarchar] (128) NULL , [COLUMN_NAME] [nvarchar] (128) NULL , [DATA_TYPE] [..

DataBase/SQL Server 2008. 4. 1. 10:09