6,934 Topics
 | |
| | Hi, How to get MS SQL database size using API.  |
| | hi,i am new to vb 8 and i am now facing the problem to write sql statement. i want to retrieved data from MS Access by select the date using date time picker. so my problem is how to write the sql statement. My code is as below: sql = … |
| | Hello all, I have sql server 2005 and sql server 2000 installed on my PC. Our server only has sql server 2000. In my test environment (local pc) i need to configure my database (and/or) web.config to use sql server 2000 instead of 2005 for the profile provider. I have … |
| | Dear Friends, I would like to know how to find exact word from a text data available in SQL String. I mean, Suppose I have a string available in Table1; ie , "My latest activities" I want to search the word like test. Currently I am using query [code=sql]select * … |
| | Hi guy, I currently having problem saving my drawing into the sql database. Can I get some help here pls. my current codes: [CODE] Imports System.Data Imports System.Data.SqlClient Imports System.IO Imports System.Drawing Imports System.Drawing.Drawing2D Public Class Page_2 ' for GCS TABLE Private value_GCS As Integer = 0 Dim value_Eyes As … |
| | Can someone please help me with the following problem. I currently have a datagrid linked to an sql database and in the grid I have a ckeckbox column. However, when I check the box in the current cell the checked box disappears when I click on another cell and only … |
| | hey guys/girls i do need some help with my application(console) at the moment, im reading from my SQL DB, into classes for each table...(or to the respective classes) anyway... i cant seem to get the update part right, for instance i'd like to change someones surname... [CODE]public static DataSet ReadClientData(string … |
 | Hi guys here is my working sql query Select MAX(Hits)'Hits', SUM(Hits)'Total', UserID From sf_articles Group By UserID My problem is, when I want to select other columns as well as the current ones. It gives me a lovely error: Server: Msg 8120, Level 16, State 1, Line 1 Column 'sf_articles.ArtID' …  |
| | Dear Friends, I would like to know how to find exact word from a text data available in SQL String. I mean, Suppose I have a string available in Table1; ie , "My latest activities" I want to search the word like test. Currently I am using query select * … |
| | I know mysql but I now have a job where mssql is needed. I am having a problem inerting multiple rows at once. MySQL Query: [code=mysql] INSERT INTO colours (ccode, cdesc) VALUES ('35', 'Green'), ('35', 'Turquoise') [/code] How do I get the same result with MSSQL? Thanks in advance. |
| | I have tried several combinations and just can't get this right. I am getting "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM bookmarks WHERE bid = 11' at line 1" when … |
| | Can anybody recommend good online courses for SQL and/or data controls? (I guess I should master the regular data controls before going on to Silverlight, right?)  |
| | In every asp.net webpage i am using more than one sql commands to get the data and store it in data set. after the execution of the front end asp.net is it possible to go back and open sql server and see in a window which all statements got executed …  |
| | hi i need some help someone please. i tried so many combinations of code with but not getting anywhere. I need a user to enter an id through a form, then the code should retrieve certain fields of the table and display them in a table. here is the code. …  |
| | hi frnds, how can we connect to a sql server database using C++ program.can anyone pls post a code for this ... |
| | I've used strip_tags, is there a better way to secure this query? the value will always be numeric, It's being displayed like this [url]http://www.somesite.com/listing.php?id=5[/url] The id will always be a different number not always 5 depending on the listing [CODE] $sql = "SELECT * FROM listings where id=" . strip_tags($id) …  |
| | I am interning at a company and they have had me build a simple website which basically displays a list of their servers and they update entries, create new entries and so on. I am new to php and mysql and just web design in general. My question is do … |
| | I am looking for something with a gui that is capable of accessing sql database data and then being able to produce simple graphs from that data. Any suggestions for programs or something I could modify to produce that result are appreciated. |
| | Hi all, What is the best method to move data from an access database into sql server database with different table and field names? If possible could you give me an example? Thank you so much! |
 | Hi I already Install the MS Sql server 2005 into my machine,but I want to install the Sql server 2008 into my machine.I want to install the sql server into "D:" Drive, because of few space available in "C:" drive. 1)Can I install sql server 2008 into "D:" drive? 2)If … |
| | Hi everyone. I'm relatively new to MS SQL but one of my clients has a site based entirely around it so I am having to get to know it a bit better. While trying to clean out some of the fake emails from the mail list table they all got …  |
| | Hi there, I'm working on an application for a lab project and I'm making it in C#. It's supposed to import results from a text file that is exported from the application we use to run the tests and right now, I've hit a road block. I've gotten the program … |
| | good eveninh sir/madam, error is :- An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll Additional information: System error. code is : - Dim a, b As Date a = Date.Now.Date b = a.Now.AddDays(-7) Dim dataset2 As New DataSet Dim myconn As SqlConnection = New _ SqlConnection("server=;database=project3;uid=;pwd=") Dim obj_deletecommand As … |
| | hi,i have a problem in installing sql server 2005 express,and even 2008.Ive searched the net for possible solutions but Ive not seen an error the same with me so ive decided to ask now. I hope someone can help me. this is the error Ive received when i install sql …  |
| | Hello, everyone. Can someone explain to me on how to read a .mdf file (the SQL Server 2005 Express kind)? I have a Java IDE (JCreator) and the JDBC (SQL Server 2005 Express compatible) installed into this computer. Right now, I'm using this: [CODE]Connection c = java.sql.DriverManager.getConnection("jdbc:sqlserver://localhost\\SQLEXPRESS;DatabaseName=qsscsdb;IntegratedSecurity=True");[/CODE] to read the … |
| | Posted - 08/08/2009 : 20:48:04 Hello, I hope someone may have some suggestions for a SELECT statement I am trying to create. I have a primary table like: Field1 Field2 Field3 1_____AAA____BBB 2_____BBB____AAA 1_____CCC____DDD 5_____DDD____KKK Secondary table like: Field1 Field2 Field3 Field4 1__________________X 2____BBB____AAA____Y 1____CCC___________Z ___________________J Desired Result: Field1 Field2 … |
| | Hello, the first question is, how do iknow if the SQLEXPRESS server that in my machine is work well? i have sqlExpress and i also have the sql studio management, i am creating database and tables and all works fine. but when im tryin to call to a database from … |
| | Private Sub cmdLogin_Click() Dim comSave As New ADODB.Command Dim sqlAdd As String Set RS = New ADODB.Recordset With comSave [COLOR="red"].ActiveConnection = ConnDB[/COLOR] .CommandType = adCmdText End With ConnDB.BeginTrans sqlAdd = "INSERT INTO UserName (FullName,IDCard,CustomerID,Office,Address,Telephone,UserId,UserPwd)" sqlAdd = sqlAdd & "VALUES('''& txtFullName.Text & ''', ''' & txtIDCard.Text & ''', ''' & txtCustomerID.Text …  |
| | Hello, I have two issues and I hope someone can help me with it. I have been on this problem for 3 days now, And I can't resolve it. #1 Issue I have a database in access 2003 that is the front-end and the backend on sql server 2005. I … |
| | Hello Friends,:) I want to compare each row in the excel sheet with mysql database table fields in order to eliminate the duplicate entry while inserting data from excel sheet into that particular mysql database table. Can anybody provide me the logic ? I have added my code here. Please … |
| | I have a web application for recording time, bonuses and commissions for employees. I am having a hard time joining three tables together. Here are the tables: employee - provides employee information including the primary key emp_id emp_timecard - provides recorded time from employees tc_bon_com - provides bonuses and commissions … |
| | I am trying to design a Query in SQL that will enable the user to enter a customer code. However being new to SQL I do not know the language. I have selected the data from the tables, however I want to add criteria. In Access I used [] and … |
| | Hi:) I have a problem about DB navigator usage in SQl with borland c++ builder ? How can I use C++ codes with sql?  |
| | hi friends We are connecting to sql server with Java and jsp as front end for our application. We are almost 10 people connecting to same machine regularly. earlier, we were just 4 or 5 connecting to one machine, now all are connecting to same machine, coz of some policy … |
| | Hey guys. I have a program that does a SQL query and parses the info into a text file. The problem is it misses the first row every time it loops. I know the root cause here is my double use of the read function. I'm hoping to gain some … |
| | I am a newbie with sql and need some help. Question Details: ARTIST.Name Artist.Nationality Transaction.purchaseDate Transaction.SalesPrice... Customer.Name Customer.Phone.AreaCose Customer.Phone.LocalNumber Customer.Name... (The Ellipses(...) refer to the structures that can repeat. Code SQL statements to update this view as follows: a. Change the spelling of Mark Tobey (ArtistName) to Mark Toby. I … |
| | Can anyone help me out with this? SalesPerson Name Age PercentOfQuota Salary Abel 24 63 120,000 Baker 56 38 42,000 Jones 34 26 36,000 Murphy 64 42 50,000 Zenith 45 59 118,000 Kobad 43 27 36,000 Order Number CustName SalespersonName Amount 100 Abernathy Construction Zenith 560 200 Abernathy Construction … |
| | Hi! :)))) I have to use sql connection to take queries from user by using textbox structure .How can I provide this .I don't find it anywhere . especially how can I connect sql and textbox structure together I do not know anything about this subject. I know c and …  |
 | This is a very important issue to consider when you're using form/url variables in databases. A user can cleverly put in SQL statements and manipulate your db server as he sees fit if you don't take the necessary precautions. I get the feeling that there are several people that aren't … |
| | I have a problem. I hope that someone can help me. I have to do an analysis of an student course registration database. The Case is that I have an database application of a student registration system. Students can enrolll for one or more courses, When they enroll, there will … |
| | Hi, We have schedule a job through SQL agent in which We want to access the data of a specific field from SQL table For example we have a field named interviewDate, we have to compare it with current date. now we have to write a stored procedure to read … |
| | Hi All Ok this is a bit of a doozy for me. Work related question, I have been tasked with sorting out this issue at work, but don't really have much background in this field, but theres no one else in my team that can do it. Bit of a … |
| | hello, i would like to retrieve data on which the endDate < date.now....something like that.. thanks |
| | Hi! I have to use sql connection to take queries from user by using textbox structure .How can I provide this .I don't find it anywhere . especially how can I connect sql and textbox structure together I do not know anything about this subject. |
 | hi How to Upload PDF, Zip, etc into a MS SQL Server Varbinary(max) then how do I get it back out un corrupt? I have some code which works for jpeg, doc, xls files. However if I upload Zip, mpeg or PDF it does not work. It looks like the … |
| | Hi, I need to compare MySQL, MS SQL 2008 and Oracle. Do you know of any link where this comparison takes place? I found a few comparign MySQL and MS SQL 2000 but not with MS SQL 2008 and Oracle too. Can you please help? Thanks Josh |
| | Good day! I am having problem inserting records to sql server. I have ten records to be inserted in database that is stored in an arrays(). When it reach to a value that has a quote or double quotes in returns error. Please help. What will be the best solution … |
 | Well I am a PHP fan, (HAIL OPENSOURCE) Its just so happen I will have a ASP.NET PROJECT, In short I need to run MS VISUAL STUDIO and MS SQL SERVER in my machine together with XAMPP. I just want to confirm first If I will have a problem installing … |
| | I was trying to install sql server 2008, and came across a problem. After testing the setup files, I got this result: passed 10; Failed 0 and Warning:1. The warning is for the windows Firewall image. Can someone please quickly tell me how to handle this an continue with my … |
 | In a data environment I write code like: select ([exam fee]*[other fee]) as total from table1 then it work, but when I write like below it not work: select sum[exam fee] as total from table1 what problem with it? |
The End.