2,736 Topics
| |
Hi everyone, This is the error i am getting when i try to do SqlCommand.ExecuteNonQuery(). My application runs on multiple threads and constantly opens, executes and close connection. This error i am getting after running the application for some time. Error: System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results … | |
Hello, I'm using Windows 7 Ultimate 64bit. I'm on admin account and all I want is to develop my ASP.NET pages on my main system - not only on virtual machine with XP istalled. The problem is that I cannot access the database on Win 7. IIS is working, ASP.NET … | |
Hi, Hello all. I installed SQL Server 2005 on Windows 7 together with SP3. I set the surface area configuration to allow TCP/IP and named pipes. When i try to connect the machines running SQL, i fail, i cant access it. Neither can i change any settings in the surface … | |
How do I prompt the user to enter an 8 character code that I will use in an MS SQL query script? | |
Dear all, I have this query to generate sql row to XML Mode. [CODE]SELECT CurrencyID, CurrencyName FROM MasterCurrency ORDER BY CurrencyID FOR XML RAW ('Currency') , ELEMENTS;[/CODE] the result is : [CODE]<Currency> <CurrencyID>AUD</CurrencyID> <CurrencyName>AUSTRALIAN DOLLAR</CurrencyName> </Currency> <Currency> <CurrencyID>CHF</CurrencyID> <CurrencyName>SWISS FRANC</CurrencyName> </Currency> <Currency> <CurrencyID>EUR</CurrencyID> <CurrencyName>EUROPEAN EURO</CurrencyName> </Currency> [/CODE] I want the … | |
Newbie SQL programmer. Here is my issue. I have a field, memid, varchar 30. I want to look at positions 1-9. If all are 9 positions are numeric , move those to memssn int field. Can anyone assist me? thanks | |
I Have Created Following tables 1.Test_Student(Master) table which will contain StudentId(primary key), StudentName and StudentAddress as columns. 2. Test_Subject(Master) table which will contain SubjectId(primary key) and SubjectName as columns. 3. Test_StudentSubjectTrans (Transaction) table. This will be a transaction table between Test_Student and Test_Subject. This table will contain StudentId and SubjectId … | |
I have Column named 'Price' in a table.I want to update the 'Price' Column by adding 5 .But i have some Null values in 'Price' Column.Whenever i update the 'Price' Column.All Values Updated Except the Null Values Column.So how can i update the null Column.Pls Help Alok | |
Hello All i have a query on (Union all) clause i want to create a table through union clause. the code i am trying to execute is: [CODE] select * into table1 from (select * from partmst union all select * from importexcel) as mytemp [/CODE] but it shows error … | |
hello all, i want to save the web page content into a database. how can i fetch data from that website and save into a sql database. im using c# as front end. need help. expecting reply soon since it needed for my project. thanks. | |
Hello I want to compare an inserted date against two stored dates in order to validate an entry. The date entered is being stored in a separate table from the stored dates. I am not sure how to go about this. So far I have this: [CODE]create PROCEDURE sp_GetTime @FullName … | |
I've created an SSIS package where I have an FTP Task inside a ForEach Loop container. I am trying to loop through each file in the particular folder and send it to the FTP site. I am sure that I got the For Each Loop working, as the error message … | |
i want to insert multiple int values selected from dropdown in to a single column seperated by a delimiter(,) along with this values there are some other rows too in which some other values are inserted a table has Booking id which contain values like 1 and roomid which contain … | |
Our employees have an interface to enter their vacation days. The vacation dates are stored in the database as one row per day, minus the weekend days. I'm trying to create a report that will show the starting and ending dates for each employee. Note: Each employee can have muliple … | |
In my MS SQL 2005 i have given "[B]Windows Authentication[/B]". Now how to connect with NETBEANS?? I means wat to give in User Name and Password fields?? I tried to give my User name and password while login into Windows. But not working. I am getting this error [COLOR="Red"]"the user … | |
Hi , can anyone help me. I tried to start an SQL Server instance from command line with sqlservr.exe. But on the last line it said "a significant part of sql server process memory has been paged out. this may result in performance degradation". And my instance didn't start. But … | |
Our server growth is too fast from 30GB from last month now it reaches into 50GB. Is their a problem in our database? Can this be possible to shrink this database into a minimal Size? Our server is MS SQL server 2000. | |
Hello, I have a little issue getting what I want displayed from a single table. Basically, here is what I am trying to accomplish. I have the following type of table: Place Action B/S Qty Type City Full B 1 View City Partial B 1 View City Partial B 1 … | |
Hello, I'm having problem with a query which is based on fixed-part and all I do is that I'm modifying part after WHERE something.value='... . This whole text is a string which I need to be connected to my query. '113') AND (reklamace.kod_reklamace = '932' ' Error message: Conversion failed … | |
hello all, im a student and doing a project to automate a process. For which i ve to download files from clients site.. my doubt is can zip files be stored in sql database. if its possible means how can i achieve this.. need help! good day. | |
Hi guys , I am creating a timekeeping application to keep track of users. In my database I have a table which stores the time a user starts their break and finishes their break. I want to return the total time that the user is on break in minutes to … | |
I am New TO Programming Am HAving 2 Table One Table Having Coloum ID and NAmeOf Eventt And Other Table Having Coloumn ID and Imagepath I want To Retrive Id related the NAme Of Event and Want To Insert That ID into other Table at the same time i want … | |
Hello! I'm hoping that you can help me Alter a SQL table to provide a unique constraint over 2 columns. For instance let's say I have a departments table called Dpt_tbl with two columns that I want to be unique Name Location So I want to make sure that you … | |
Hi, Not sure if this is right place to post this, please move if needed. I set up a web form so that the text from a set of text boxes was inserted into a database when you 'submitted' the form Since then I have added some validation to the … | |
General Question, no code: I have the daunting task of automating the import of mysql, ms sql and ms access into a central location. I've nailed the microsoft crap using ms sql DTS but even with mysql odbc drivers, cant seem to nail that one. The optional is that I … | |
DOH spelt thread name wrong... should be query! This is surely simple... this is the end of my query [CODE]where CCM0300.dbo.Device.tkModel= '72' AND CCM0300.dbo.NumPlan.DNOrPattern like '31455' OR CCM0300.dbo.NumPlan.DNOrPattern like '38600' OR CCM0300.dbo.NumPlan.DNOrPattern like '36305' OR CCM0300.dbo.NumPlan.DNOrPattern like '36805' OR CCM0300.dbo.NumPlan.DNOrPattern like '38285'[/CODE] what this is meant to do is return … | |
Hi I need to create an SQL to retrieve the max date for each change in stock code. can anyone assist please? I am extremely new to SQl. I used access to get external data but it drags down 60,000 odd lines. i only have 5000 line items so with … | |
Dear all, I am very new at SQL programming and are using the Microsoft Query to avoid alot of SQL programming, but I am stuck on one thing when I try to filter some data from the database... I want to show all delayed deliveries to our customers... Our Policy … | |
hi i have a query and i want to use it in remote server when i try to run it in my machine it executes ok. but in remote server it cannot be executed. im connected to the remote server and i can view all the records in the table. … |
The End.