잡동사니

LEFT OUTER JOIN 표현의 또다른 형태(ORACLE 에서의 표현)LEFT OUTER JOIN ~ ON 을 사용하지 않고 FROM 절에 테이블을 콤마(,) 및 조건절에서 조인될 테이블의 컬럼명 다음에 (+)를 붙여 기술할 수 있습니다. https://playdata.io/tutorials/sql/left-outer-join

public IList<Product> GetProductsByCategoryId(int categoryId) { IList<Product> products; using (var context = new NorthwindData()) { SqlParameter categoryParam = new SqlParameter("@categoryID", categoryId); products = context.Database.SqlQuery<Product>("Products_GetByCategoryID @categoryID", categoryParam).ToList(); } return products; } public Product GetProd..

DECLARE @name VARCHAR(50) -- database name DECLARE @path VARCHAR(256) -- path for backup files DECLARE @fileName VARCHAR(256) -- filename for backup DECLARE @fileDate VARCHAR(20) -- used for file name SET @path = 'C:\Backup\' SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112) DECLARE db_cursor CURSOR FOR SELECT name FROM MASTER.dbo.sysdatabases WHERE name NOT IN ('master','model','msdb','tem..

Create function running following script: CREATE FUNCTION dbo.udf_DayOfWeek(@dtDate DATETIME) RETURNS VARCHAR(10) AS BEGIN DECLARE @rtDayofWeek VARCHAR(10) SELECT @rtDayofWeek = CASE DATEPART(weekday,@dtDate) WHEN 1 THEN 'Sunday' WHEN 2 THEN 'Monday' WHEN 3 THEN 'Tuesday' WHEN 4 THEN 'Wednesday' WHEN 5 THEN 'Thursday' WHEN 6 THEN 'Friday' WHEN 7 THEN 'Saturday' END RETURN (@rtDayofWeek) END GO ..

컴퓨토피아 :: MSSQL 에서 XML 데이터 입력, 출력, 수정하는 방법

http://msdn.microsoft.com/en-us/library/bb308960.aspx?ppud=4#xlinqoverview_topic2h

if (!db.Users.Where( u => u.UserName == "michael" ).Any()) { db.Users.InsertOnSubmit( new User { UserName = "michael" } ); db.SubmitChanges(); }

실행. // 1. create a command object identifying // the stored procedure SqlCommand cmd = new SqlCommand( "Ten Most Expensive Products", conn); // 2. set the command object so it knows // to execute a stored procedure cmd.CommandType = CommandType.StoredProcedure;매개 변수. // 1. create a command object identifying // the stored procedure SqlCommand cmd = new SqlCommand( "CustOrderHist", c..

use master go exec sp_grantdbaccess 'account' go grant exec ON xp_cmdshell To account go

How to Enable xp_cmdshell on a MS SQL Server Instance xp_cmdshell has the power to make modifications on the outer world of SQL Server. So this power has to be controlled in the security concepts and be manageable. In the early versions of Microsoft SQL Server the xp_cmdshell extended procedure was enabled default. This caused some security gaps for SQL Server owners. Although some administrato..