在MS SQL 實現 Limit 的做法

SELECT * FROM  (SELECT *, ROW_NUMBER() OVER (ORDER BY META_ID) AS ROW FROM UMETADATA) A WHERE ROW > 10 and ROW <= 20 

SqlParameter 遇到 LIKE 寫法

SqlParameter 遇到 LIKE 寫法

 String _sql = @"SELECT TABLE_NAME FROM SDE_LAYERS WHERE OWNER = 'DBO' AND TABLE_NAME LIKE @thisMapName + '%' ORDER BY TABLE_NAME DESC";
                           
DataTable dt = new DataTable();

 //1.SqlConnection
 using (SqlConnection cn = new SqlConnection(_connstr))
{
           cn.Open();
           //2.SqlCommand
           using (SqlCommand cmd = new SqlCommand(_sql, cn))
           {
                      cmd.Parameters.Clear();
                      cmd.Parameters.AddWithValue("@thisMapName", thisMapName);
                      //3.SqlDataAdapter
                      using (SqlDataAdapter da = new SqlDataAdapter(cmd))
                      {
                                 dt.BeginLoadData();
                                 da.Fill(dt);
                      }
            }

            cn.Close();
}