Recent questions tagged sql

0 votes

1 answer 5 views

Cannot define primary key constraint on nullable column in table.

Problem: I am able to create the table named employee which contains the column empid which is a computed column and empid column is the primary key also. It is the self referencing table and the column managerid references back to itself. But now if I try to save ... error my table is still working perfectly. I am trying to work in a table graphically not coding every time I make the change.

asked 5 days ago Raphael Pacheco 720 points

1 vote

1 answer 23 views

Arithmetic overflow error converting expression to data type int.

Problem: I am having only elementary knowledge about Sql Server and Azure. I have gained basic knowledge about Sql server and Azure from the available online material. I want to write a very basic query that should calculate the average, min, max, and count. ... this part of programming so unable to understand the above error. Kindly guide me in fixing above Sql Server and Azure related error.

asked Jun 6 Martin K 6.6k points

1 vote

1 answer 20 views

Arithmetic overflow error converting varchar to data type numeric.

Problem: I am having good exposure to SQL. Currently I want to insert my data from one table to the another table but because of some unknown reason to me I am facing some sorts of issue it shows me below error: Numeric value out of range: 8115 [Microsoft][ODBC ... ,'') AS [TRIM(IngredCost)] FROM file_5979bd211a3a9` Please help me with this issue. I want to insert all the records in one go.

asked May 23 Martin K 6.6k points

1 vote

1 answer 15 views

Arithmetic overflow error converting numeric to data type varchar.

Problem: I have very basic knowledge in Sql query writing. I have tried to write the below query. SELECT '$' + CONVERT(VARCHAR (6), Cast(Avg(TotalPrice) AS NUMERIC (6, 2))) AS 'Average Price', '$' + CONVERT(VARCHAR (6), Cast(Min( ... converting numeric to data type varchar". I am unable to find the root cause of above error. Kindly help me in fixing my above sql query.

asked May 23 Martin K 6.6k points

1 vote

1 answer 39 views

Display data from database based on dropdown selection using ajax?

Problem : I am very beginner to PHP, Jquery and ajax, and I am really going through very hard time while trying to find a solution on a web based platforms which I could use to solve my problem. Currently I am trying to display the data from my database into ... for me also tried to find for the solution online but unable to find any. So looking for expert programmers help who can fix my problem.

asked May 18 Martin K 6.6k points

1 vote

1 answer 17 views

Procedure expects parameter statement of type ntext nchar nvarchar.

Problem : I am very new to SQL. If I try to use the sp_executesq I am often facing below strange looking error: “Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.” I have spent more than two days on above error but still can not fix above sql related error. Please guide me in fixing above sql error.

asked May 12 Martin K 6.6k points

1 vote

1 answer 50 views

Ora-02449: unique/primary keys in table referenced by foreign keys.

Problem : I am learning Oracle and trying to create and drop tables. If I try to drop my table it is always showing me below error: DROP TABLE SUBURB; DROP TABLE CITY; DROP TABLE STATE; Error at line 1: ORA-02449: unique/primary keys in table referenced ... already used by an existing object. I am unable to understand the above errors. Can someone guide me in fixing above Oracle related errors?

asked May 12 Martin K 6.6k points

1 vote

1 answer 78 views

Arithmetic overflow error converting nvarchar to data type numeric.

Problem : I am very new to sql server. Currently I am dealing with a column in the sql which should be sometimes nvarchar and other cases as number. My column has the datatype as nvarchar. Now I am just interested in some places where it is in ... facing below error: Arithmetic overflow error converting nvarchar to data type numeric . I am looking for expert’s advice in fixing above error.

asked Apr 28 stewart 4k points

0 votes

2 answers 19 views

The six clauses of the select statement must be coded in the following order:?

Problem: The six clauses of the SELECT statement must be coded in the following order:?

asked Apr 18 ArifulIslam 5k points

1 vote

1 answer 30 views

Find the country that has all the vowels and no spaces in its name.

Problem : I am very new to SQL Queries. Recently I have joined new team and I am given below task Find the country that has all the vowels and no spaces in its name? I have written below query SELECT country FROM world WHERE country LIKE '%u' and country LIKE ... of time in writing the correct query but still unable to do it. So I am looking for sql experts help in fixing my above query.

asked Apr 17 stewart 4k points

0 votes

1 answer 12 views

In this logic structure, one program statement follows another?

Problem: In this logic structure, one program statement follows another?