6,934 Topics
 | |
| | Dear Sir/ Madam I would like you to help me as below: I want to create a project for manage student information and i have one table store student information in the table have student ID, Student Name, Address, Photo.... and i want to insert student information with photo and … |
| | |
| | Hi there! Ive been working on my relational schema for a while now and just recently managed to implement it. I wanted experiment a little with it so ive decided to produce a report displaying relevant information. At the moment my schema only consists of 3 tables : a 'student' …  |
| | sorry to post it here.. i really need your attention.. thanx hi guys! i am enim, i usually post thread in PHP and i guess its my first time here in mysql.. i have problem regarding the total count of the terminatecause.. i need the count of ANSWERED calls only … |
| | hi guys! i am enim, i usually post thread in PHP and i guess its my first time here in mysql.. i have problem regarding the total count of the terminatecause.. i need the count of ANSWERED calls only and the total count of all calls.. can i do this … |
| | Hi guys. Jerry Davis here. I am a married father of two baby boys, and I have some major motivation to become a master SQL guru. Wife stays home and takes care of our kids, so my income is it. I have a decent technology back ground, but have been … |
| | Dear Members, I found a thread named 'Execute an sql script in jdbc' it was very much useful to me. However i have my routines(ie. stored procedures and functions) also with the backup.sql file. This is the link which i looked for: [url]http://www.daniweb.com/forums/thread153923.html[/url] But i have to execute my script …  |
| | |
| | I am an amateur when it comes to Advanced SQL but here is the situation. I have a Test Table with data such as below: Name(char) Qty(number) Date (char) Location (char) Test1 1 11/14/08 10000 20050 Test1 1 11/14/08 10000 20100 Test1 1 11/14/08 10000 20000 Test1 1 11/15/08 10000 … |
 | Hi all, I have a server in our network contains the database of the project (SQL Server 2005). Suddenly a developer computer couldnot connect to the database which in that server. and now another computer did the same. The strange is the designer computer which still connecting to the server. … |
| | Okay heres the dilemna.... I have a Dataset("LineItems") that Stores information about so many records. To source to this DataSet("LineItems") is not its intended ouput. Meaning I pull this info in from one database and output to another. My problem is i have no idea on how to write an … |
 | I use the tipical conn in ado to connect on sql. MY prob is to find fast a string in a field (have 165.876) record. With this condition: Is the string is found in field then call sub1 else call sub2 end if |
| | can any one tell me how to write the query to find out first 6 highest salary from table note: not 6 th highest salary .... |
| | Hi guys.. Please guide me for the database connectivity with sql server express edition 2005 for any website. |
| | can you help me assign sql query to gridview..i am trying like this but it doesnt work. [CODE] Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Dim con As New SqlConnection("Data Source=SPERANZA\SQLEXPRESS;initial catalog=master;integrated security=true") Dim cmd As New SqlCommand Dim dr As SqlDataReader cmd.Connection = con con.Open() cmd.CommandText … |
| | Hello Friends, I'm facing a problem now that is i have some THAI language data in SQL Server 2000. The problem i don't know how to retrieve this data to variable and i don't noe the variable should be what data type? such as string or others? Have any one … |
| | Hi, i have been wasting to much time i don't have trying to figure this thing out and hope somebody can help. I am making a project for school in VB.NET. I have SQL SERVER 2005 installed on my machine. I can access the database just fine thru Visual Studio … |
| | i have set up a mysql db for storing news articles to be displayed within a flash website. i have now been asked if i could add an image upload function to this section. i have created the upload page and i can upload the images to the db fine. … |
| | I have questionnaire that has two radio buttons(one is "Register" and the another one is "Drop") in it and all answers are saved in an SQL database. For Example ,when the user checked "Register" and then by clicking "Sumbit Page" the values stored in the sql database.When the user returns … |
| | Hi all, First poster here - have been reading through many of the posts but need someone to break something down for me. Have been given an assignment in college to create a Login / Register page using sql and jsp. I have done a page like this before but …  |
| | Hello Everyone, I've a problem with java & SQLServer 2005 interface, i installed a SQLServer 2005 and SP2 software bundle to enable SQLServer to run on Windows Vista, i'm using the "Windows Authentication" in SQLServer 2005 which don't need the username or password, and i've the classpath to jar archive … |
| | Hi All I have a select statement: [size=2]Select PERMISSION_BUTTON_ID from ALC_SECURITY_PERMISSION where ROLE_ID = 1 Now I want to store / retrieve the values of the field that I am querying without using dataset. Is this possible? If yes how can I do this? Is it possible that I declare … |
| | hi guys, im using microsoft c# along with sql server 2k8 to build my database software, i have 2 problems.. 1st is i cant seem to make an incrementing primary key that doesnt start with 1? i wanted to make my primary key start from 00001 then increment it by … |
| | can't solve a homework problem for computer class. Any clues?: Given two tables, USERS and LOG, where USERID is a primary key in USERS and a foreign key in LOG, write a SQL statement that will return LOG records (all fields) with corresponding USERIDs in USERS. The report should include … |
| | Hi Guys I need a hand from a kind SQL*Plus guru to create Oracle abstract data types and collections using SQL*Plus I. Using Oracle’s SQLPlus create Abstract Data Type definitions for the Client and Child member entities called Client_Type and Child_Type respectively. Attributes for Client_Type include client number, name, address, … |
| | hi to all, i am a student, 2nd yr.college taking computer science, i want to learn about in coding in SQL except (SELECT, INSERT, UPDATE & DELETE). i just wanted to learn more complex and difficult coding, syntax, command and etc. please help me. thanks!  |
| | Hi all. I am currently developing a CMS for a school project and I wanted to add the function to check, real-time, if a username is already taken. It should be a little bit like what happens when you register for a Gmail or Yahoo! account. Basically, while the user …  |
 | Hi all, Can anybody help me out with the connectionstring for connecting VB6 to a Microsoft SQL Server 2005 Express Edition. I have tried several documented varieties which do not work. My latest attempt was a version from [URL="http://msdn.microsoft.com/en-us/library/bb264566(SQL.90).aspx"]this website[/URL]. I downloaded the application and associated files and changed the … |
| | Hi Everyone! I have to make a forum with MS SQL, and, as I'm Hungarian, we use characters, like áéíőúű, etc. Now, if I insert a text with the letter ő or ű, I get back o and u. How can I solve this problem? The users write posts in … |
| | Hello., i have sql server in my pc and i want to connect my visual basic form to my sql? how can i do that? what is the code i have to write in the modules? please help Thanx in advance... |
| | Hello, I am trying to display SQL query results in a GUI. Right now I am displaying the information in a standard TextBox, but I would like to be able to sort by the different columns and stuff like that, much like if I had a excel spreadsheet open with … |
 | hi. i would like to work on my computer without connecting to server. i installed the ms sql management studio 2005 express. how can i create a local host server to work on ? |
 | Hi I wrote simple query like [code=sql]select Code,CashDeposited,Date from dbo.RDBankingDetails where Code='SE0001' group by Date,Code,CashDeposited[/code] It generate report like below TE0001 12000 2005:03:26 TE0001 49150 2005:03.26 TE0001 209000 2005:03.26 I want to generate the report like below Code Date CashDeposisted1 CashDepostis2 CashDeposists3 TE0001 2005:03:26 120000 49150 209000 In above CashDeoposisted … |
| | |
 | when trying to update a sql database i get the following error message on Update Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information the column UserID is the PrimaryKey any ideas would be appreciated Thanks Peter example code: … |
| | i have created a database and populated it with information but i have to run queries on it without using a query builder and am quite rusty on SQL. Below are the tables for the database! Staff : Man no, SName,LName, Address, Tel Mobile. Students: Driver No, Group, Exp Date, … |
| | hi, i m fetching the record from the given xml but not success full please help [code]DECLARE @XMLString xml set @XMLString ='<timetable> <day1 id="DY101"> <lecture1 id="LECT101"> <subject>SUB101</subject> <faculty>FAC101</faculty> <room>ROOM101</room> </lecture1> <lecture2 id="LECT102"> <subject>SUB102</subject> <faculty>FAC102</faculty> <room>ROOM102</room> </lecture2> <lecture3 id="LECT103"> <subject>SUB103</subject> <faculty>FAC103</faculty> <room>ROOM103</room> </lecture3> <lecture4 id="LECT104"> <subject>SUB104</subject> <faculty>FAC104</faculty> <room>ROOM104</room> </lecture4> <lecture5 id="LECT105"> … |
| | Friends please help LoginName Prop_code Visitdate scorpio84 RS32650 10/23/08 12:14 PM scorpio84 RS29589 10/23/08 12:14 PM fatima17124 RS47255 10/23/08 6:32 AM vinit32831 RS33019 10/22/08 2:31 AM vinit32831 RS33019 10/22/08 2:31 AM vinit32831 RS39680 10/22/08 2:30 AM vinit32831 RS47246 10/22/08 2:26 AM sashi133 RS46091 10/20/08 4:38 AM sashi133 RS46091 10/20/08 4:38 … |
| | i have a page in which i m using grid control to display data from sql server. i have two fields in my table.name,image in which image datatype is image.i m using an sqldatasoure for data binding.when i run my page image not displayed in my page.only name field is … |
| | Hello everyone I have a problem with the connection of MS sql with the windows application problem. All i need to do is to insert something to the database table. However i'm not sure how to connect the ms sql with it. I have some codes written out, but i … |
| | I have SQL code in my VB6 project for select, insert, and truncate. For example: [code=VB] strSQL = "SELECT CASE_IDENTIFIER" & vbCrLf _ & " ,DOCUMENT_TYPE" & vbCrLf _ & " ,DOCUMENT_NUMBER" & vbCrLf _ & " ,CASE_LINE_NUMBER" & vbCrLf _ & " ,DELETION_INDICATOR" & vbCrLf _ & " ,MASL" … |
| | I work at a college and we have a file that looks like this: ID DEGREE 0001 BA 0002 BS 0002 BA 0003 BA 0003 BA 0004 BS 0005 BS 0005 BA 0006 BA 0006 BA 0007 BS 0007 AA 0007 BA Each student has a unique ID and could … |
| | I want to access an MS Access database using IP Address on internet using a desktop application. Please let me know as to what has to be done using VB.net Please reply in this or email me the solution at [email]abatechcal@yahoo.co.in[/email]. Thanks. |
| | So... I have 3 textboxes and a Submit button. Here's the code behind: [CODE] public void Submit1_onClick(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(); DateTime laiks = new DateTime(); conn.ConnectionString = "data source=.;initial catalog=ForumDataBase;integrated security=true;"; SqlCommand cmd = new SqlCommand(); cmd.CommandText = "INSERT INTO PostTable(ThreadTitle,PostMessage,UserName) values('" & ThreadTextbox.Value … |
| | hi all pls help Input string is not in a correct format. string selectsql = ("select title,convert(varchar,date,106)as date,description,cast(status as bit)as status from event_tbl where i_eid=" + Convert.ToInt32(id2) + ""); Regards |
| | how do you add data to sql database using c# variables and an sql command? I have a class of employes that i use which has values identical to my sql database tables here is the basic code of what i want to do... [ICODE] SDC.DbCommand dbCmd; //database command string … |
| | |
| | hi i am creating stored procedure using cursors, i am using two cursors in my procedure, i takes the two fields in one table that fields are stored first cursor, and second table fields are stored in second cursor, and i check the condition for first table one field is … |
| | Hi all, I am developing an application which reads an excel file which has the following records and inserts into a table in SQL SERVER 2005 database [Enterprise Edition]. Data: Product Version CustType ------------- ------------- -------------- Norton SystemWorks Basic Edition 2009 CS Norton 360 2 CS Norton 360 2 CS … |
| | If I execute this query in VS2008, data is returned OK: SELECT DESCRIPTION FROM AZTECA.REQUEST WHERE (DATETIMEINIT > TO_DATE('09/03/2008', 'MM/DD/YYYY')) AND (DATETIMECLOSED < TO_DATE('09/04/2008', 'MM/DD/YYYY')) If I execute the same query with a parameter: SELECT DESCRIPTION FROM AZTECA.REQUEST WHERE (DATETIMEINIT > TO_DATE('09/03/2008', 'MM/DD/YYYY')) AND (DATETIMECLOSED < TO_DATE(:CLOSEDDATE, 'MM/DD/YYYY')) and enter … |
The End.