8

Вопрос по sql-server, c# – Использовать SQL View или SQL Query?

Error: User Rate Limit Exceeded

string query = "SELECT T1.f1, T1.f2, T2.f3 FROM table1 T1 join table2 T2" +
   "on T1.id = T2.id AND T1.dt = T2.dt ..."
....
cmd.CommandText = query;

Error: User Rate Limit Exceeded

 CREATE VIEW V1 AS
   "SELECT T1.f1, ..."

Error: User Rate Limit Exceeded

 string query = "SELECT f1, f2, f3 FROM V1";
 ....
 cmd.CommandText = query;

Error: User Rate Limit Exceeded

  • Error: User Rate Limit Exceeded

    от
  • Error: User Rate Limit Exceeded

    от
  • Error: User Rate Limit ExceededwellError: User Rate Limit Exceeded

    от
  • Error: User Rate Limit Exceeded

    от
  • sighError: User Rate Limit Exceeded

    от
  • Error: User Rate Limit Exceeded

    от
  • Error: User Rate Limit Exceeded

    от David.Chu.ca
  • Error: User Rate Limit Exceeded

    от
9 ответов
  • 2

    Error: User Rate Limit Exceeded

  • 2

    Error: User Rate Limit Exceeded

  • 0

    Error: User Rate Limit Exceeded

  • 16

    Error: User Rate Limit Exceeded

    AMENDMENT

  • 0

    Error: User Rate Limit Exceeded

  • 0

    Error: User Rate Limit Exceeded

  • 1

    Error: User Rate Limit Exceeded

    good

  • 1

    Error: User Rate Limit ExceededmayError: User Rate Limit Exceeded

    Error: User Rate Limit Exceededreusable.

  • 3

    Error: User Rate Limit Exceeded

    Complex queries can get hard to read in code You can change the view without recompiling Related to that, you can handle changes in the underlying database structure in the view without it touching code as long as the same fields get returned