랩제이

CREATE DATABASE spring DEFAULT CHARACTER SET euckr COLLATE euckr_korean_ci; CREATE DATABASE mysample DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

GRANT ALL PRIVILEGES ON *.* TO 'javajigi'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO 'javajigi'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

select serverproperty('edition'); Express Edition with Advanced Services

http://msdn.microsoft.com/ko-kr/library/ms180047.aspx

--**************************** --* Example 1 --* Import all users into new table --*****************************/ SELECT * INTO dbo.Users_Import FROM OPENQUERY(remotelinkedservername, 'SELECT * FROM dbo.Users' ) --**************************** --* Example 2 --* Insert users that do not exist --* into existing table --*****************************/ INSERT INTO dbo.Users ( UserID, UserName, FirstNa..

select b.name + ', ', c.name +' (' + cast(b.length as varchar) + ')', 'Rs.Fields(' + cast((b.colid - 1) as varchar) + ')' from dbo.sysobjects a, dbo.syscolumns b, dbo.systypes c where a.id = b.id and a.name = 'Email게시판' and b.xtype = c.xtype order by colid

MSSQL 2005 Express 외부 접속

연결할 서버 : HNAMJU\SQLEXPRESS