|
|
[한글컬럼값 들어있는 것만 지우기]
|
|
select * from tbl where field like '%[가-힣]%' delete from tbl where field like '%[가-힣]%' |
[영문컬럼값 들어있는 것만 지우기]
|
|
select * from tbl where field like '%[A-Za-z]%' delete from tbl where field like '%[A-Za-z]%' |
|
|
SqlConnection conn = new SqlConnection(conStr); SqlCommand cmd = new SqlCommand("sp_getdata", conn); cmd.Parameters.Add("@userIndex", SqlDbType.Int).Value = MemberNo; cmd.CommandType = CommandType.StoredProcedure; conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { Fee = Convert.ToInt32(reader["Fee"].ToString()); } conn.Close(); |
|
|
@Html.TextBoxFor( model => model.m_modelAccout.m_strExpenseMoney, new { @class = "typeahead", autocomplete = "off", data_provide = "typeahead", data_items = "4", data_source = Model.a } ) |
|
|
var listevents = new List<string>(); listevents.Add("1111"); listevents.Add("1222"); listevents.Add("1333"); listevents.Add("1234"); listevents.Add("1555"); var events = listevents.ToArray(); var strJson = JsonConvert.SerializeObject(listevents); |
|
링크
|
