• Register
search
Log In

Recent questions tagged sql

0 votes
1 answer 5 views
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
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
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
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
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
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
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
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
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
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
Problem: In this logic structure, one program statement follows another?
asked Apr 12 ArifulIslam 5k points
0 votes
2 answers 27 views
Problem: A(n) ____ in a class diagram indicates public access?
asked Apr 12 ArifulIslam 5k points
0 votes
2 answers 58 views
Problem: In what type of attack does the attacker send unauthorized commands directly to a database?
asked Apr 12 ArifulIslam 5k points
0 votes
2 answers 70 views
Problem: A _____ is a simple database program whose records have no relationship to one another? Select one: a.flat file b.schema c.relational system d.user view
asked Apr 12 ArifulIslam 5k points
0 votes
2 answers 16 views
Problem: Data redundancy ensures that the data contained in the database is accurate and reliable? True False
asked Apr 12 ArifulIslam 5k points
0 votes
2 answers 59 views
Problem: Each table _____ represents an attribute? a. column b. row c. dimension d. value
asked Apr 12 ArifulIslam 5k points
0 votes
2 answers 74 views
Problem: What are the valid indexes for the string 'New York'? a. 0 through 7 b. 0 through 8 c. -1 through -8 d. -1 through 6
asked Apr 12 ArifulIslam 5k points
0 votes
2 answers 55 views
Problem: The Navigation Pane contains a list of all the objects in the database? True False
asked Apr 12 ArifulIslam 5k points
0 votes
2 answers 20 views
Problem: Write a String constant consisting of exactly 5 exclamation marks?
asked Apr 12 ArifulIslam 5k points
1 vote
1 answer 15 views
Problem : I am new to SQL. While trying to execute my JOIN query I am facing below strange error. “Conversion failed when converting the varchar value to data type int”. I am unable to figure out why am I getting above error. Can someone help me in fixing the error?
asked Mar 27 morrisBson 3.2k points