SQL SELECT Kill FROM problem

Question

$sql = "SELECT Kill FROM tbl_pvporderview";

Problem is that il lend up with : Incorrect syntax near the keyword 'Kill'.

Cuz kill is a TSQL command... any way to bypass it?

I cant change the column name cuz its used by the software a lot and i cant change the software that's using the database.

so it simply fails if i use sqlserv to select data from that column. '' or "" wont help.

The complete statement would be:

$sql = "SELECT serial,Kill FROM tbl_pvporderview WHERE Kill > (?) ORDER BY Kill DESC ";

Answer 1

Wrap the column name in square brackets:

$sql = "SELECT [Kill] FROM tbl_pvporderview"; 

Answer 2

If you want to use reserved words as table or column names, you have 2 options:

use brackets (the SQL-Server's way): SELECT [Kill]

or double-quotes (the ANSI/ISO standard): SELECT "Kill"

Your whole statement would become:

SELECT [serial], [Kill] 
FROM tbl_pvporderview 
WHERE [Kill] > (?) 
ORDER BY [Kill] DESC ;