database Archives - anydragon

MSSQL 한글 영문 구분

[한글컬럼값 들어있는 것만 지우기]

select *  from tbl where field like '%[가-힣]%'
delete  from tbl where field like '%[가-힣]%'

1 2	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]%'

1 2	select * from tbl where field like '%[A-Za-z]%' delete from tbl where field like '%[A-Za-z]%'

storedprocedure call

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();

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();

anydragon

참고자료

최신 글

보관함

MSSQL 한글 영문 구분

storedprocedure call

태그

링크

메타

anydragon

참고자료

최신 글

보관함

Database Index 타지 않는 경우

MSSQL 한글 영문 구분

storedprocedure call

태그

링크

메타