Yes, I can.

데이터베이스가 존재하는 쿼리 SELECT name FROM master.dbo.sysdatabases WHERE name = 'Arch_ESales_' + @search_year 응용 DECLARE @SQL NVARCHAR(MAX) --Check V_CA_PURCHASEORDERS Exists DECLARE @PurchaseOrders NVARCHAR(30) DECLARE @FnGetOrderStatusWithFraud NVARCHAR(40) SET @SQL = N'SELECT @PurchaseOrders = TABLE_NAME FROM Arch_ESales_'+ @search_year + N'.INFORMATION_SCHEMA.TABLES         WHERE TABLE_SCHEMA = ''dbo'' AND TABLE_NAME = ''V_CA_PURCHASEORDERS''' EXECUTE sp_executesql @SQL, N'@PurchaseOrders NVARCHAR(30) OUTPUT', @PurchaseOrders OUTPUT     IF @PurchaseOrders IS NULL BEGIN SET @FnGetOrderStatusWithFraud = N'fnGetOrderStatusWithFraud' SET @PurchaseOrders = N'PurchaseOrders'   END ELSE BEGIN SET @FnGetOrderStatusWithFraud = N'fnGetOrderStatusWithFraud_CA' END

1. Create Certification file makecert [options] outputCertificateFile C:\Program Files (x86)\Microsoft Visual Studio 10.0\VC>makecert -sv Fulfillment_ US.pvk -n CN=forever21 Fulfillment_US.cer -r Option Description -sv   pvkFile Specifies the subject's .pvk private key file. The file is created if none exists. -n   x509name Specifies the subject's certificate name. This name must conform to the X.500 standard. The simplest method is to specify the name in double quotes, preceded by  CN= ; for example, "CN= myName ". -r Creates a self-signed certificate. 2. Create pfx file pvk2pfx /pvk pvkfilename.pvk [/pi pvkpassword] /spc spcfilename.ext [/pfx pfxfilename.pfx [/po pfxpassword] [/f]] C:\Program Files (x86)\Microsoft Visual Studio 10.0\VC>pvk2pfx -pvk Fulfillment_ US.pvk -spc Fulfillment_US.cer -pfx Fulfillment_US.pfx /pvk  pvkfilename.pvk Specifies the name of a .pvk file. /spc  spcfilename.ext Specifies the ...