I have a function that calls a SQL query, the function is type fetch_user Now i get an Undefined Index error when I call my query, The error message is Undefined index: uid in profile.php on line 3 But the thing is that i cant find the error, This is my user.inc.php that have the function And this is my
Tag: sql
Need help converting date in format 20120130 to Date data type oracle sql
Could you please help me in converting date from the format “20120101” to DATE format in Orcle Sql. I looked at this link but it does not mention if the date format is custom.. EDIT: Is it possible …
Formatting column in SQL
I would like to insert the pipe character | in a column to separate two sections of the output. Is there a way to put one in every row of a column as long as there is data in that row? Answer
Determine ROW that caused “unexpected end of file” error in BULK INSERT?
i am doing a bulk insert: DECLARE @row_terminator CHAR; SET @row_terminator = CHAR(10); — or char(10) DECLARE @stmt NVARCHAR(2000); SET @stmt = ‘ BULK INSERT accn_errors FROM ”F:FullUnzipped…
In a currency exchange rate what is the maximum number of decimal places used?
I need to store currency exchange rate data in the SQL 2008 database. I would like to keep rate as a decimal data type in the database. One thing I am not sure about, is how many decimal places to give (e.g. decimal(18, ?)). Since, I will be using this service as a source: http://openexchangerates.org/latest.json. There, it seems that the
How to use regular expression in T-SQL?
For example: where strword match with {%{J{GC * GC}J} or strword={%{J{GC * GC}J}
SQL – Blank default namespaces
I have a relation which has an XML column storing data in the following structure
Optimize a SQL query : call a function or do a join?
What is the fastest in an ORACLE database ? Call a function inside a select statement to retrive a single value for each row SELECT field1, field2, F_GET_LIBELLE_STATUT( field2 ) FROM table1 WHERE …..
Using group by on two fields and count in SQL
I have a table in my mysql db that has two columns: group and subgroup. See below. group, subGroup grp-A, sub-A grp-A, sub-A grp-A, sub-B grp-B, sub-A grp-B, sub-B grp-B, sub-B I am …
Finding rows with consecutive increase in the values of a column
I have a sql table that stores the daily prices of stocks. New records are inserted every day after the market closes. I want to find the stocks that have consecutive increases in price. The table has lots of columns, but this is the relevant subset: The quoteid column is a primary key. In the table, the closing price of