3,481 Topics
 | |
| | hi, what i need to do is to get information from 2 tables and show it to the listview. for example, i want to get the surname, first name and middle name from the student_info table and the Payment_Status from the accounting_system. i don't want to show the information that …  |
| | Hi Guys , i have faced a sql command problem. That is currently i have 2 different table [ICODE]a) Select ID, Name from Table1 where ID >=1 and ID ID <=3 ID | Name 1 | Alan 2 | Amy 3 | Andrew [/ICODE] [ICODE]b) Select ID,Sum(Points) as [Total] from … |
| | I need to store data to isolated storage with simple entry form,currently using class to load data but what i need to insert data and load it after emulator is restarted.I'v seen you can use sql ce database and xml file to store data,but which method will be best?Tried to … |
 | i want to create a stored procedure that can return the initial character of two string inside the description field. ex. Computer Security -> in one data only if i use this statement select left(description) from table1 i want to return only CS when i run my script. is there … |
| | I have a form where a user can search for properties from a database. Everything is working except for the suburb search. I would like the user to be able to search for more then one suburb. At the moment I have the information from the textbox being separated into …  |
 | Hello Every One ! I m working on a software , i have one field name expiry_Date , now i want to make an query which subtract the current date from the expiry_date and give answer in no.of days , i use getdate() for current date , can any one … |
| | I want to have an alternative way to increment my student no. the current way I'm doing to is in my database, mssql. there's a property called Identity Seed(201200001 - my studentid format) and Identity Increment (1 - no. of increments). The 2012-is the school year, while the 00001- is …  |
| | i have four computers connected to broadband ADSL router MS SQL Server is installed in all computers while i have done steps given here [url]http://support.microsoft.com/kb/914277[/url] it had worked on local networking some time ago but now its not accessing remotely. i m confused its just because of broadband ADSL. if … |
| | Guys, When i run this sscript i got an error in Where clause? Where should be place this where clause? [CODE] SELECT p.ESN, p.ReturnDate,s.Receiptdate,e.Shipdate FROM USProductRecovery p with (nolock) OUTER APPLY((SELECT TOP 1 Receiptdate FROM ESNSalvReceipts s with (nolock) WHERE ESN = p.ESN AND Receiptdate > p.Returndate ORDER BY Receiptdate …  |
| | Hi, I want to get Indian Standard Time (IST) in Sql Server 2005. How can I achieve this? Note: SELECT 'SYSDATETIMEOFFSET', SYSDATETIMEOFFSET() this query works fine in Sql server 2008. Is there any option in Sql Server 2005? Thanks in Advance |
| | Hello everybody and thank you in advance for any suggestions and help I hope to receive. I have Mysql experience but now I am working on my first M$sql database project, and I am getting frustrated. I am using php and would like to export a query. It is quite … |
| | Hi.... I am trying to connect sql server with vb.net in Visual Studio 2008 with foll. code.... but it is having problem....what is the problem? Please tell me.... 1. I created "publication" databse. In table i took 2 columns...fname and lname and fill the records... 2. I took DataGridView onto … |
| | Hello, I would like to create a small procedure that fetches the names of the columns of a table and uses them as a variable name. Let me explain. TableA Ref, FullName, FirstName, Age, ... 1, Jones, Charles, 32 2, Bridge, Dom, 26 3, Goodtime, Jack, 46 ... And I … |
| | hi, i have a project written in visual studio 2008. and i copied the folder to the network drive. and from another pc when i run the exe file of the application an error occurs because the connection string is different, how can i make the application which is in … |
| | Hello again! So now i can save the picture in the database, now i have to retrieve it. this is my code for the saving of the picture, [CODE]Dim ms As New MemoryStream() studentpic.Image.Save(ms, studentpic.Image.RawFormat) Dim arrImage() As Byte = ms.GetBuffer ms.Close() Dim strFilename As String = lblfilePath.Text.Substring(lblfilePath.Text.LastIndexOf("\")) Dim cnn … |
| | HI, Am having a table named "test" in the server A -> running Sql Server 2000. [CODE] synchronized in server B (Insert,update and delete in the server A)[/CODE] Am having the same table named "test" in the server B -> running Sql Server 2005. I don't know, how to carry … |
 | can anyone please help me with my update statement, i am trying to update a row within a access 2007 database here is my code. [CODE] Dim con As New OleDb.OleDbConnection Dim cmd As New OleDb.OleDbCommand Try con.ConnectionString = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=" & Database & ";Persist Security Info=False" con.Open() cmd.Connection = …  |
| | Hi, I am trying to add up the quantity of various items found in a table, that is controlled by a second/third joined table using the IN search criteria. However I am unable to work out getting the SUM of all the items. The tables are as below: [ICODE]Table One: … |
| | Guyz i need changes in this stored procedure "between" or anything like ven i enter a start date and end date on as 26 dec twice i get error set @Result = (select COUNT(*) from Employee_Leave where Employee_Id = @Employee_Id and Leave_Date = @start_Date AND ) and does not duplicate … |
| | I am trying to display the result from a query in to a table. I can do this pretty easily when doing queries from mysql, but cannot get it to work with mssql. Below is the code I used to actually make sure I could get the data (and it … |
 | Hi friends, can you guys help me to find the best way to track information changes in sql server 2000, like a free utility. The problem is that i need to track every single table because i want to figure something out. we have an ERP System and there is … |
| | i have two column in table select Col1 + ' ' + Col2 from test It gives output as Arun Kumar But i want output as Arun Kumar Can anyone help me out |
| | I want to connect mobile and server for my project help me the way to do that That is sending and receiving sms to server ..and storing it according to its field name im using asp.net (c#) and mssql |
| | Hi, I need to use query to check if a person has made a purchase during the month of his / her birthday. If yes, I have to give the person 10% discount. So, I have my database as such (Some of the tables are omitted due to its relavancy): … |
 | Hi Guys I want to crete the SQL Tigger.There is table called Fruits.In fruits table it contain ITEM_CODE,ITEM_NAME and PRICE.So there is application that used to insert the values into fruits table. So I want once ITEM_Name or ITEM_CODE is update then sql trigger execute and It insert the update … |
 | I have suddenly deleted a sql server databse file from Sql server management studio. and recovered it using a data recovery software. but now unable to open this database. the error is "aaa.mdf is not a primary database file error 5171". i need urgent solution plz. help me to solve … |
| | what are the diffrences between CREATE INDEX [WITH IGNORE_DUPLICATE_KEY OFF] and CREATE UNIQUE INDEX it sounds the same! and if anyone knows when creating a plain INDEX just CREATE INDEX whether it creates a clustered or nonclustered index couldnt find an anshwer to that thanks in advance  |
| | Hi, i want to write a query for employee's who's name start with "a" and end with "b". Thnks in advance :)  |
| | Hello guys i am little bit confuse here with the code can any one help me out .. i want max customer paid in shopping and their name i dont know that i am using right way or not but guide me here [CODE]Select sum(od.unitprice * od.quantity) as Amount, (Select … |
| | I am planing to outsource a project to create a business application, a CRM like system. Few says C++ and MSSQL while other .net and MSSQL. I would like to know what is the advantage going with C++ The system is going to be a web based platform.  |
| | [CODE]Sub retrievepic() Dim conn As New SqlConnection("data source=.\sqlexpress; integrated security=true; attachdbfilename=|datadirectory|\WAIS.mdf; user instance=true;") Dim cmd As New SqlCommand("select ImageData from ImagesStore where ImageId=@ImageId", conn) cmd.Parameters.AddWithValue("@ImageId", 3) Try conn.Open() PictureBox1.Image = Image.FromStream(New IO.MemoryStream(CType(cmd.ExecuteScalar, Byte()))) Catch ex As Exception MsgBox(ex.Message) Finally conn.Close() End Try End Sub [/CODE] This is my code for … |
 | Sir, I am currently doing a project on "Pharmacy Management System". My question is "Can I used DataGridView to show the items that i have searched and the rest won't be visible??" If yes then can anyone give me the code for search button?? I have used the following code …  |
 | Hello, I have one more question. I am connectinag to SQL Server 2008, not express, and I keep getting the "login failed for user "..."" The connection string I am using is: [CODE] Dim connStrg As String = "Data Source=" _ & ServerAdressTextBox.Text & _ ";Initial Catalog=" & _ DatabaseNameTextBox.Text … |
| | I need to save pictures in my database, my database is MSSQL as of now, my code for getting the picture is this: Private Sub browsepic_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles browsepic.Click With dialogpic 'Open File Dialog sa toolbox .InitialDirectory = "C:\Users\CAMILLE\Pictures" .Filter = "JPG Files|*.jpg|PNG Files|*.png|GIF … |
| | Hello, I am creating a web server which lets me insert into a table. The user invokes the specific ID and its meant to append to the table with that ID, startdate and an enddate. [CODE] <WebMethod()> _ Public Function reserveVehicle1(ByVal vID As Integer) As Boolean Dim strInsert As String … |
 | Good day people please i need your clearification here: i want to go for mcdba certification. i do not understand these category exam stuff of 70-431, 70-293, 70-290, 70-291 etc. please let someone explain for me. thank you. |
| | Hey Everyone hope all well. I have this code that works perfectly on a mysql database [CODE]<?php // visit http://php.net/pdo for more details // start error handling try { // connect $pdo = new PDO('mysql:host=localhost;dbname=name', 'name', 'password'); // enable error handling through exceptions $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // create safe query $query … |
| | I am facing the problem when i m attaching the ms sql 2005 database file in win7... MICROSOFT SQL SERVER ERROR 5120 |
| | I am unable to restore .bak file in sql server 2005 ,Although i took back up from sql server 2005 and restore in the same version,its giving me an error ... does any one thing think that .bak is corrupted or whatever... please give me any remedy in that case … |
| | We have an error on time of database attachment error 948 in ms sql server management studio 2008 what is solution of it |
| | Dear community, On a quite regular basis, the screen of one of the laptops I use [COLOR="red"]blinks for a fraction of a second[/COLOR]. It does it like with some screen capture softwares when they are triggered. Besides, I'm observing from time to time some strange behaviour: [COLOR="red"]Command windows that open …  |
| | Here is the link to download my database with sample data (Management Inventory): [url]http://www.mediafire.com/?9o5ycrqot2risa8[/url] I am making a query to access redundant or missing quatity of material. [B]Report[/B] MatId CusMatName TDK NTK XTK ... . . . . . . . . with: TDK: [CODE]select detail.MatId as ID_Nhap, SUM(Quantity) as … |
| | Hi, I am actually an HR consultant with minor experience in SQL, have asked our developers for help and received the query below, but it is not working - Please help!!! My Client records training for employees, these employees need to be recertified at certain dates. I need a report … |
 | I want to write a program in C# that will populate the fields in a database that I have created, for example... I have fields in the database such as TotalWins, Name and TotalCredits. In the C# program, I want to have users enter these values into textboxes and when …  |
| | I have a foreach loop package that parses through some flatfiles and imports them into a database. Instead of using a batch script to grab files only with todays date I would like the the ssis package to only parse files with some sort of getdate() function. SSIS 2005 sorry … |
| | I am making a DBMS using C#.Net and MS SQL. i want to display the data using crystal reports. In the Database Fields when the Database Expert wizard opens after choosing OLE DB (ADO) and then OLE DB for SQL provider, i have to give the Server, user & password … |
| | How do i insert multiple rows in database. for example: I have 3 list: list1: a1,a2,a3,a4 list2: b1,b2,b3,b4 list3: c1,c2,c3,c4 I want to insert a1,b1,c1 in 1st row. a2,b2,c2 in 2nd row,... How do I write one sql insert statement to do that? |
 | Hey guys, not sure what thread to put this in, please direct me to the correct one if this one isn't it. I'm struggling with a sub report in iReports. I have a report that selects from a MSSQL database, and uses a sub report to do a select from …  |
 | Hello everybody. How do you do? I have a really odd problem. I am using an application which is running on MS OS-es. (MS Windows XP SP3, MS Server 2003) This application connects to a remote SQL server (MS Server 2003). The version of MS SQL was 2000 (previous free … |
| | Hi everyone, we have constructed a content management system that gets updated quite frequently and is used by many clients for their day to day opperations for their websites. We have decided to build a section of the CMS with additional modules that we will host on our cloud and … |
The End.