/*------------------------------------------------------------------
|
-- COPYRIGHT (C) 2010-2012 PFC
|
-- ALL RIGHTS RESERVED.
|
-- 汉和信息
|
-- CREATE DATE: 2010/07/12
|
-- CREATE MAN: 姜新军
|
-- 常用Sql语句类
|
-- MODIFY HISTORY:
|
-- MODIFY DATE:
|
-- MODIFY MAN:
|
-- MODIFY DESC:
|
-- MODIFY DATE:
|
-- MODIFY MAN:
|
-- MODIFY DESC:
|
---------------------------------------------------------------------*/
|
namespace HW.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})";
|
}
|
}
|
