dual-table

What is the equivalent of the Oracle “Dual” table in MS SqlServer?

by

In sql-server, there is no dual you can simply do SELECT pCliente, ‘xxx.x.xxx.xx’ AS Servidor, xxxx AS Extension, xxxx AS Grupo, xxxx AS Puerto However, if your problem is because you transfered some code from Oracle which reference to dual you can re-create the table : CREATE TABLE DUAL ( DUMMY VARCHAR(1) ) GO INSERT … Read more

What is the dual table in Oracle?

by

It’s a sort of dummy table with a single record used for selecting when you’re not actually interested in the data, but instead want the results of some system function in a select statement: e.g. select sysdate from dual; See http://www.adp-gmbh.ch/ora/misc/dual.html

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)