MkFramework
 All Data Structures Functions
sgbd_syntax_mssql.php
1 <?php
2 /*
3 This file is part of Mkframework.
4 
5 Mkframework is free software: you can redistribute it and/or modify
6 it under the terms of the GNU Lesser General Public License as published by
7 the Free Software Foundation, either version 3 of the License.
8 
9 Mkframework is distributed in the hope that it will be useful,
10 but WITHOUT ANY WARRANTY; without even the implied warranty of
11 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 GNU Lesser General Public License for more details.
13 
14 You should have received a copy of the GNU Lesser General Public License
15 along with Mkframework. If not, see <http://www.gnu.org/licenses/>.
16 
17 */
19 
20  public static function getListColumn($sTable){
21  return "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='$sTable' ";
22  }
23  public static function getStructure($sTable){
24  return "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='$sTable' ";
25  }
26  public static function getListTable(){
27  return "SELECT table_name FROM information_schema.tables WHERE table_type='BASE TABLE'";
28  }
29  public static function getLimit($sRequete,$iOffset,$iLimit){
30  return $sRequete.' LIMIT '.$iOffset.','.$iLimit;
31  }
32  public static function getLastInsertId(){
33  return 'SELECT SCOPE_IDENTITY()';
34  }
35 }