Diff for "MSSqlWorkBook" UserPreferences
 
Help Info Print View Search Diffs Edit
 À妽º   Ã£±â   Freeboard   Subjectless   Images   ÃÖ±Ù±Û 

Differences between version dated 2004-09-14 14:26:16 and 2004-09-14 16:53:59 (spanning 3 versions)
Deletions are marked like this.
Additions are marked like this.

 
 EXEC sp_xml_removedocument @hdoc
 

sp_rename 'customers.contacttitle', 'title', 'COLUMN' ; Ä÷³ À̸§ º¯°æ

 

ÀúÀå ÇÁ·Î½ÃÀú - ½Ã½ºÅÛ ÀúÀå ÇÁ·Î½ÃÀú, ·ÎÄà ÀúÀå ÇÁ·Î½ÃÀú, Àӽà ÀúÀå ÇÁ·Î½ÃÀú, È®Àå ÀúÀå ÇÁ·Î½ÃÀú, ¿ø°Ý ÀúÀå ÇÁ·Î½ÃÀú

 OBJECTPROPERTY ÇÔ¼ö¸¦ »ç¿ë, isextendedproc ¼Ó¼ºÀ¸·Î È®ÀåspÀÎÁö ½Ã½ºÅÛspÀÎÁö ÆǺ° °¡´É

 

ÇØ´ç °³Ã¼ÀÇ ½ºÅ©¸³Æ® ¿­¶÷

 sp_helptext master.dbo.sp_who

 select text from master.dbo.sp_who s inner join master.dbo.sp_who c on s.id = c.id

 where s.name = 'sp_who'

 

ÇÁ·Î½ÃÀúÀÇ À̸§ ¾Õ¿¡ #¸¦ Ç¥½ÃÇÔÀ¸·Î½á tempdb¿¡ »ý¼ºÇÏ´Â Àӽà ÀúÀå ÇÁ·Î½ÃÀú¸¦ ¸¸µç´Ù.

##ÀÏ °æ¿ì ±Û·Î¹ú Àӽà ÀúÀå ÇÁ·Î½ÃÀú°¡ µÈ´Ù

 

 CREATE PROCEDURE up_temptb

 AS

 SELECT * From testtb2

 

WITH RECOMPILE - ½ÇÇà½Ã¸¶´Ù ÄÄÆÄÀÏÇÑ´Ù.

WITH ENCRYPTION - ½ºÅ©¸³Æ® ³»¿ëÀ» ¾ÏȣȭÇÑ´Ù.

 OBJECTPROPERTY ÇÔ¼öÀÇ isencrypt ¼Ó¼ºÀ¸·Î ¾ÏȣȭµÇ¾ú´ÂÁö ÆǺ° °¡´É

 

autostart ÇÁ·Î½ÃÀú°¡ ÀÚµ¿À¸·Î ½ÃÀ۵ǵµ·Ï ±¸¼º(dbo ¼ÒÀ¯À̸ç master db¿¡ ÀÖ¾î¾ß ÇÔ) ;

 sp_procoption

 @procname = autostart,

 @optioname = startup,

 @optionvalue = true

 OBJECTPROPERTY ÇÔ¼öÀÇ execisstartup ¼Ó¼ºÀ¸·Î ÀÚµ¿ ½ÃÀÛ ÆǺ°

 

sql server°¡ ´ÙÀ½¹ø¿¡ ½ÃÀÛÇÒ ¶§ ÀÚµ¿ ½ÃÀÛ ±¸¼ºÀ» ÇÏÁö ¾Êµµ·Ï ÇÔ ;

 EXECUTE sp_configure

 @configname = 'scan for startup procs', @configvalue = 0

 RECONFIGURE

 GO

 

ALTER PROCEDURE ±¸¹® »ç¿ë½Ã, WITH ¼Ó¼ºÀº À¯ÁöµÇÁö ¾ÊÀ¸¹Ç·Î ´Ù½Ã ¸í½ÃÇØ¾ß ÇÔ.

 

sp_rename @objname = 'up_test', @newname = 'up_testnew', @objtype = 'object' ; sp À̸§ ¼öÁ¤

sp_depends ; ÀÇÁ¸ °ü°è °Ë»ç

 

DROP PROCEDURE¸¦ ½ÇÇàÇϸé ÇöÀç db¿¡¼­ ÇØ´ç sp¸¦ ã°í, ¾øÀ¸¸é master db¸¦ °Ë»öÇÑ´Ù.

 
 
===== ¿ÀÈÄ 12:00 2004-09-13, p.280 =====

PythonPowered ShowText of this page
EditText of this page
FindPage by browsing, searching, or an index
Or try one of these actions: DeletePage, DeleteUploadedFile, LikePages, SpellCheck, UploadFile