HooNim

SELECT  *  
FROM sys.dm_os_performance_counters 
WHERE object_name = 'SQLServer:General Statistics'

exec sp_configure 'show advanced options', 1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure


-- 예제 1)
select * from 
OPENROWSET('Microsoft.Jet.OLEDB.4.0','text;Database=절대경로;HDR=NO','select * from 파일명')

-- 예제 2)
select * from
OPENROWSET('MSDASQL','Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=절대경로;','select * from 파일명')
 
 
 
 

9.0 
1
1       SQLCHAR        0       20       "\r\n"   1     Phone_number       "" 

select    COUNT(TXTFILE.Phone_number) AS COUNT 
from       OPENROWSET ( BULK 'c:\temp\a.txt',  
             FORMATFILE='c:\temp\TextFormat.fmt' ) as TXTFILE (Phone_number) 

sp_changeobjectowner 'test.test', 'dbo'

ALTER schema dbo transfer test.test

CREATE trigger [dbo].[Trigger_EX] on [dbo].[TABLE] for update
as

Declare @user_id varchar(20)
Declare @result int
Declare @stat_status int


set @user_id = (select user_id from inserted)
set @result = (select result from inserted)
set @stat_status = (select stat_status from inserted)

-- if UPDATE(컬럼명) 이런식으로도 가능

if @stat_status = 3 and @result <> 2 
	begin
	
	사용 소스 작성
	
	end

DECLARE @PHONE_NUMBER varchar(50)
DECLARE @DEST_INFO varchar(5000)
DECLARE @i int


DECLARE SelectCursor CURSOR FAST_FORWARD GLOBAL FOR

select cast(DEST_INFO as varchar) from send


OPEN SelectCursor

FETCH NEXT FROM SelectCursor INTO @PHONE_NUMBER    -- 위쿼리의 값이 @PHONE_NUMBER에 입력된다.

WHILE @@FETCH_STATUS <> -1  -- record가 존재하지 않을때 까지
	Begin
		If @@FETCH_STATUS <> -2 --record가 없을경우
			Begin

			End

		FETCH NEXT FROM SelectCursor INTO @PHONE_NUMBER

		If @@FETCH_STATUS <> 0 -- record가 존재할때
			Begin

			End

	End

CLOSE SelectCursor;
DEALLOCATE SelectCursor;

CREATE DATABASE KSBoard ON 
	(FILENAME = 'C:\DataBase\backup.MDF'),         ' 경로 지정
	(FILENAME = 'C:\DataBase\backup_Log.LDF')    ' 경로 지정
FOR ATTACH;
GO