但有的地方只想讓它顯示成語系, 不希望跟著系統設置變動怎麼辦?
可以用以下語法
$t('keyName', 'ZH_CN');語言名稱需與 message 設定相同
若翻譯需傳入變數, 可如此使用
test: 'Hi {name}',
$t("test", 'EN', {name:'Lily'})
string str = "a";
str += "bac";
System.Text.StringBuilder sb = new StringBuilder();
for (int i = 0; i < 10; i++)
{
sb.Append(i.ToString());
}
var str = sb.ToString();
IF EXISTS(SELECT 1 FROM Sales.StoreContact WHERE CustomerID = 24)
UPDATE table1 SET (...) WHERE Column1='SomeValue'
ELSE
INSERT INTO table1 VALUES (...)
IF 判斷式的 SELECT 只是要確認是否有值,因此建議使用 'SELECT 1' 取代 'SELECT *'IF NOT EXISTS(SELECT 1 FROM Employee WHERE Id = @Id)
INSERT INTO table1 VALUES (...)
ELSE
SELECT -1
string scmdst = "UPDATE Department " +
"SET Name = @Name " +
"WHERE Id = @Id";
string scmdst = @"UPDATE Department
SET Name = @Name
WHERE Id = @Id";
string queryString = "insert into mytable (myregion,myname) values(N' " + region + "',N'" + name + "' )";
using System.Data.SqlClient ;
string queryString = "insert into mytable (myregion,myname) values(@myregion,@myname)";
SqlConnection cn = new SqlConnection(cs);
SqlCommand cmd = new SqlCommand(queryString, cn);
cmd.Parameters.AddWithValue("@myregion", region);
cmd.Parameters.AddWithValue("@myname", name);
cmd.ExecuteNonQuery();
引入方式有多種
1.
cmd.Parameters.Add("@myregion", SqlDbType.NVarChar);
cmd.Parameters["@myregion"].Value = region;
2.
cmd.Parameters.AddWithValue("@myregion", region);
3.
cmd.Parameters.Add(new SqlParameter("@myregion", region));
SELECT sum(amt) FROM NLEdiTax WITH(NOLOCK) WHERE IDATE>='2013.03.01' and IDATE <='2013.03.15'
SELECT COUNT(UserID)
FROM EMPLOYEE WITH (NOLOCK)
JOIN WORKING_GROUP WITH (NOLOCK) ON
EMPLOYEE.UserID = WORKING_GROUP.UserID