• Register
search
Log In

Recent questions tagged sql-server

0 votes
1 answer 3 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 3 days ago Raphael Pacheco 640 points
1 vote
1 answer 22 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 18 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 14 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 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 18 views
Problem : I am very beginner to SQL Server. Currently I am trying to execute my SQL Server SUBSTRING query written by me but I am facing error. Please find below my query for your reference: select     substring(mytestcasename, 2, 5) val1,     substring(mytestcasename, ... 16, State 5, Line 1 Invalid length parameter passed to the LEFT or SUBSTRING function. Please guide me in fixing above error.
asked May 9 stewart 4k points
1 vote
1 answer 20 views
Problem : My task is to send email with the file attachments also this attachment must come from the image type data field. If I try to run the below code in both the query window and the stored procedure but my email was not sent and in the query window I can only see ... = 1,     @query_no_truncate = 1; I need to send email but still unable to do so. I am looking for help in fixing the issue.
asked May 6 stewart 4k points
1 vote
1 answer 75 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
1 vote
1 answer 15 views
Problem : I am very new to the Sql Server. Currently I want to add the new foreign key to the already existing table in this table there is existing data in a column where I want to make the change. I tried this approach on a table for a ... the error message. “The alter table statement conflicted with the foreign key constraint”. Can someone guide me in fixing this foreign key error?
asked Apr 1 morrisBson 3.2k points
2 votes
1 answer 22 views
Problem : I am very new to SQL Server 2008 Management Studio. I have recently connected my SQL Server 2008 Management Studio with Windows authentication. After that I am facing below error "The request failed or the service did not respond in a timely fashion. Consult the event ... to fix above error from past couple of days but I am unable to fix it. Can somebody guide me in fixing above error ?
asked Mar 25 morrisBson 3.2k points
0 votes
2 answers 30 views
Problem: I am new, I need help, can anyone help me? Which of the following is not true about a server? a. stores data and software that can be accessed by the client. b. may be a personal computer or a mainframe on the network. c. in client/server ... the business application. d. can only perform one function on a network. e. stores documents and graphics that can be accessed from any Web browser.
asked Feb 23 maddi86 5.4k points
0 votes
1 answer 17 views
Problem: I am learning databse, and need to know basic busness database, can any one tell me? The most basic business database is comprised of?
asked Feb 20 maddi86 5.4k points
0 votes
2 answers 23 views
Problem: I am new, I need help, can anyone help me by filling in the blanks? ________ is used to ensure that data is organized most efficiently in a database?
asked Feb 19 maddi86 5.4k points
0 votes
1 answer 32 views
Problem: I am little bit confused, which statement is true? In sql server, execute the sp_columns command to list all the columns in a table? True False
asked Feb 19 maddi86 5.4k points
0 votes
2 answers 44 views
Problem: I need to do dataentry in database, may i know the best tool to input data into database? What is a data entry tool you use to input data into a database?
asked Feb 19 maddi86 5.4k points
0 votes
1 answer 25 views
Problem: I am new, I need help, can anyone help me by filling in the blanks?? ​The acronym ____________ refers to software that manages data stored in a database.​​ A) ​ERP B) SQL​ C) ​OLAP D) ​DBMS
asked Feb 19 maddi86 5.4k points
0 votes
1 answer 21 views
Problem: Can anyone guide me with the right solution? If you define a column with a default value, that value is used whenever a row? a. with a zero value for that column is added to the table b. is added to the table c. in the table is updated d. that doesn't include a value for that column is added to the table
asked Feb 17 maddi86 5.4k points
0 votes
1 answer 12 views
Problem: I am new to SQL, I need help, can anyone help me? When you identify the data elements in a new database, you typically subdivide data elements into? a. The largest practical components. b. The smallest practical components. c. Components that can be easily parsed each time you use them.
asked Feb 17 maddi86 5.4k points
0 votes
1 answer 93 views
Problem : When I am attempting to connect to MSSQL database via ASP.NET online, I will often get the below error when two or more people try to connect simultaneously: ExecuteReader requires an open and available Connection. The connection's current state is Connecting. My site works fine on the localhost server. May I know what might have gone wrong with my site and how can I fix the error?
asked Jan 31 jwilliam 3.9k points
0 votes
1 answer 12 views
Problem : I want to do below query INSERT INTO dbo.tbl_A_archive  SELECT * FROM SERVERxyz.DB.dbo.tbl_A However even after I ran below code set identity_insert dbo.tbl_A_archive on I am facing below error message “Can only be specified when a column list is used and IDENTITY_INSERT ... a huge number of columns. I can not type all of the columns out manually. How can I get this to be fixed?
asked Jan 29 jwilliam 3.9k points