/////////////////////////////////////////////////////////////////////////////
|
// File Description : 常用Sql语句
|
// Copyright : joyin
|
// -------------------------------------------------------------------------
|
// Date Created : Mar 26, 2010
|
// Author : jiangxinjun
|
/////////////////////////////////////////////////////////////////////////////
|
|
namespace HH.WMS.DAL
|
{
|
/// <summary>
|
/// 常用Sql语句
|
/// </summary>
|
internal class CommonUseSqlFormat
|
{
|
/// <summary>
|
/// 获取执行完Insert以后的自增长值。
|
/// </summary>
|
internal static readonly string RETRIEVE_NEWID = "SELECT SCOPE_IDENTITY();";
|
|
/// <summary>
|
/// Insert into 格式
|
/// </summary>
|
/// <remarks>
|
/// {0}:表名
|
/// {1}:字段
|
/// {2}:值
|
/// </remarks>
|
internal static readonly string INSERT_SQL = @"INSERT INTO {0} ({1}) VALUES ({2})";
|
}
|
}
|
