6,934 Topics
 | |
| | Hi All i have problem in insert statement in which one string returning me value as g's and because of that s is gets separated. and its giving me eroor as Incorrect syntax at s. [code]strSQL = "Insert into HeaderInfo(yAxisLabel , xAxisLabel , zAxisLabel , yAxisUnit , xAxisUnit , zAxisUnit)" …  |
| | Hi I have two tables that I want to use to build a third. They have a many-to-one relationship for one of the columns. Table A has the "one" side of the many-to-one relationship. Table B has many rows that have foreign keys referencing Table A. I want to write … |
| | Hi guys, I need some help please. I am new to SSIS. I created a SSIS in BI and when I run it it works fine (All it does is to run a select statement to get data and save it into a flatfile. The server I'm accessing is on … |
| | I can't figure out how to email the password from a sql database I have a formview on my webpage can I pull it from there? or can I pull it directly on my backend code? Using C# I tried + passwordlabel + I tried using findcontrol.formview I can seem …  |
 | We have a Windows 2003 Server Standard with SQL 2000 installed in a workgroup called "SUNDANCE". My question is can I somehow have that Windows Server communicate with AD on another Windows 2003 server that is part of a separate domain? I would like to have all connections to the … |
| | I have an SQL2005 table loaded with ICON (image) BLOBs. I need to dynamically add ToolStripMenuItems to my Windows form including the same row Icon from the database table. This is a Plugin system where I pull the plugin file (assembly) names from the database according to the operator's rights … |
| | Hi all. I have just started using Qt, and i can't find any primer on how to connect my Sql Server2008 database. What are the steps that i need to make, so my database is connected with Qt. Additional info: I'm using Qt 4.4.3 open source on Windows XP and … |
| | I just finished a job interview/exam and I failed. I really don’t know how to implement this problem using an MS SQL. You could check the exact question/problem below: [I] There are two tables, NAMES (ID INT IDENTITY (1,1), NAME VARCHAR(255) ) and RELATIONSHIPS (NAMEID INT, PARENT_NAMEID INT) linked via … |
| | So, I've got a bit of a conundrum that I cannot for the life of me figure out. Here's what I need to do : In column PO_I, look for column ITEM with lowest # in column Seq_I. If column Ship_Q < Qty_Ordered, look for Ship_Qty within ITEM with next … |
| | I am currently using MS SQL 2000 server as backend database for web site (written in php), now plan to switch DB to MS SQL 2008 Express, I have questions about this conversion: 1) Will MSSQL2008 support all sql statement that was written in MSSQL 2000? 2) I know SQL2008 … |
| | How to move (or Duplicate) a Microsoft SQL Server Database from One Physical Server to another server (like backup) in vb.net 2.0 ?  |
| | i m using visual studio .net 2003 vc++ mfc i cannot connect to sql server SQLSetEnvAttr() is returning null value everytime i hv used retcode = SQLSetEnvAttr(env, SQL_ATTR_ODBC_VERSION, (void *) SQL_OV_ODBC3, 0); pls help !! |
| | Hi, I am wondering if code below is right. Is there any unnecessary line? Thanks [code] <% on error resume next ad=request.form("name") Set RcSet = Server.CreateObject("ADODB.RecordSet") sql = "Insert Into veriler (name) Values ('"&name&"')" 'ADD sql = "Update veriler Set name='"&name&"' Where id=1" 'UPDATE sql = "Delete From veriler Where … |
| | I have a large backup database file and I am having trouble opening it. I tried renaming it from database.BAK to database.MDF. I hope that this did not permanently destroy my hopes of ever recovering the database by changing the format. Does anyone out there know how I can open … |
 | hi i have an existing table . i'm working with sql management studio. how can i change columns properties ? set column as idenity true. set column as indexable. |
| | We are working on a project & finding an issue while accessing the data from SQL Server. Problem: Display of record in search console of application on number of times it has been processed. Consider we have a record which needs to be displayed 5 times a day in search … |
| | Hello i am trying to generate mysql reports. I have them working but my problem is: i want to happen is when u click an option value e.g. list customer details, i want it to generate the report automatically. Here is my code below it is all correct i just … |
| | Hi guys, I want to select records from the database, i need to pass start index and end index, then the result set will include those records. Let say my database table has 100 records, i want to get the records between 30-50. How can i do that? |
| | Hello everybody, i am trying to import an mysql table to sql server both has the same attribute and with the same datatype. and here is what i did : 1- i export the mysql table to excel sheet. 2-then i went to the sql server and import this sheet … |
| | Help Please! I am trying to create a maintenance plan in sql 2005 server. I am getting an error Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'. (Microsoft.SqlServer.MaintenancePlanTasksUI) I am unable to create maintenance plan. I am on sp2, and applied a critical hotfix from the microsoft website. I thought maybe it was client tools, but isn't … |
| | |
| | hello everyone i am currently working on a php script on my website. I wanted to make a script for registering users. So that they may log in, log out, register, and access member only functions. I found a good tutorial online but since im fairly new to php and … |
| | hello, this is may first project in vb and i really need to finish it fast. but i cannot insert records into my sql db. can you help me please? pls pls thanks |
 | Hello Everyone, Few days ago, There was active thread on creating own DBMS in Java. Its not an easy task so i decided to create Object-Relational Mapping Framework and i have done so. I have tested all methods and its working perfectly. Now i have decided to make it available … |
| | Hi All, I am trying to build an SQL statement that will pull data from a parent table and count rows in a child table. Parent table - event: [CODE] eventid, title 1 'Metallica is coming' 2 'Elvis is in town' [/CODE] Child table - eventattendance: [CODE] eventid, userid, response … |
| | So I have a sql query [code] SELECT * FROM `database` ORDER BY `database`.`Name` DESC [/code] Is there anyway to index this so it uses a lot less Handler_read_rnd_next |
| | I have a program that uses a Stored Procedure to create a report. Unfortunatly the SP has a problem in the VB6 code. The program could pull the information perfectly until 2 days ago. Now the program times out after 60 seconds after sending the params to the sp. I … |
| | Hello everyone, Im back, with a new problem. LOL! I need to change Java datatypes to SQL types. I have sql queries as String object. like this one : [CODE=sql]create table MyTable ( id bigint, name String , city String , state String ) OR create table MyTable ( id … |
| | Hello, I hope my question falls in the right forum. I have a content web 2.0 website with ms sql database. As most content websites, every file has Title, description and tags added by uploaders. I would like to know if there is any standard algorithm for SQL search based … |
| | I cannot get mysql working. This is a Fedora Core 2 installation, I tried installing mysql with yum (it installed the 3.23 version, I dont want that). I tried upgrading, that did not go so well. I tried installing from the binaries, well, that didnt go to well either. So … |
| | Hi, I don't know why the server I recently get to manage, has the SQL Server 2005 installed but with the Management Studio Express!... I need to upgrade it with the Dev version, but when I put the DVD of the SQL Server installer, It won't show my actual installation … |
| | Hi, I have 2 instances of SQL Server running on one machine (One 2K -default- and one 2K5), I have no problem connecting from a PC on LAN to the 2K5 instance, but when I try to connect to the 2K instance, it fails (it gives me an error: "Named … |
| | I have a SP (sp_test_procedure) created from a SQL Server Project in my SQL Server 2005 database, inside this SP I have a call to another SP which inside calls to a SP in another Database Server (SQL 2000) through a cross-linked connection. When I execute it from the Management … |
| | Hi everybody, I've got a big pb, and I need help..... I have to use MS SQL Server 2005 SP2 Enterprise Edition instead of MSSQL Server 2000 Enterprise Edution and I don't know how to use the old SQL 2000 db. Any sugestions? Thanks for your time. Eddysonys |
| | Hi, I have created a local SQL database using Visual Studio 2005 ([I]not by SQL Server Management Studio[/I]), and located it in the same VB project folder: "E:\MyProject\MyDB.mdf". Now I'm trying to design reports using Crystal Reports 2008, but for SQL Server, it doesn't browse this DB created by visual … |
| | Hello everyone, I am querying an MS Access database to find duplicate records and list the results in descending order. I am using a 'while' loop to read through the records but I'm finding it difficult to store the results in separate variables, i.e. the query finds three results where … |
| | I have to implement session management in an asp.net application and with mode as sql server. Any inputs on how to implement and test this? I was trying for instructions on the following web site, but i am lost [url]http://idunno.org/articles/277.aspx[/url] |
| | i have employee table with 3 coloums emp name companyname experience 1 1 3.5 2 2 4.0 1 1 2.6 2 2 3.0 3 3 5.0 i want the result table like this emp name comany name experience 1 1 6.1 2 2 7.0 3 3 5.0 anyone tell me … |
| | Hi..I am fairly new to SQL and need some help writing a script. I have 2 tables table 1 is the student data and table 2 is the student schedule data. In table 2 the students have a student id number that is teh same as the student id in … |
| | I’m using Visual Studio 2005, ASP.Net 2.0 and SQLServer 2005. I can save .doc files into a binary column in the database. I can open .doc files from the database and view/edit them in Word. I want my customers to have free access to their Word documents. If they want …  |
| | I am attempting to use a sql query to update a record using the following: cmd.CommandText = "UPDATE ScannerData Set DateReceived = " & Date.Now & " WHERE ScanNumber = " + TheReaderData.Text + "" I receive a parse error at the Date.Now portion of the statement. Is there a …  |
| | Hi Friends, I'm a web developer bit a new to asp.net. I want to access my remote Ms Sql database through [B]Visual Web Developer[/B] or [B]Sql management studio[/B] but despite of spending so much time and googling I'm not able to do that. My [B]database( [url]www.peclive.com)[/url][/B] is on a server … |
 | Didn't know where to put this, sorry Do any of you loverly people know of a proggy that will allow me to view an SQL database file ( .sql ) Its a wordpress database and I would like to extract the posts and comments. I have searched on the google …  |
| | Hi all, I am just trying to get the information i collect from the pc's hostname and pass it into a db. All the db passwords, location etc are correct but i am getting nothing. [CODE]Imports System Imports Microsoft.Win32 Imports System.Data Imports System.Data.SqlClient Public Class Form1 Private Sub DB() 'Your … |
| | Hi (First time user) I am developing a team unit leader page. On my page I have a table with one column and multiple rows with each row having a department name. I would like to do two things but i'll focus on one for now. When i click on … |
| | Hi Friends, I am trying to Call a exe or DLL from sql server trigger using xp_cmdshell. Trigger is for an external application and for inserting a record. exe is executed successfully but trigger is not completed succefully and my external application is also not complted and it sows some … |
| | I wonder if someone can point me in the right direction for securing my site more effectively. Having experienced problems with Google warning pages being placed on my site relating to potential malware, I've been looking into "beefing up" security, but am find the tutorials relating to safeguarding against sql … |
| | Hello I try pass data from a table in Firebird to SQL server Mobile. I'm using c# in vs2005, and I have problems with transactions. At the end, if I want to rollback transaction, I would like to undo changes, but in the code I show you, Changes allways saves … |
| | Hi I am using custom database to store data. I have two tables :Customer(CustID,Fname,Lname,Fullname) and User(UserId,Emailid,Pwd,CustID(FK)) I want to retrieve the Fullname from Customer table based on logged user's Emailid. How to collect the EmailId and pass to sql query. Any help appreciated. Thanks in advance ben  |
| | hi all.... this is another thread on datareports... i need to know how to work if i have an sql and i wish to give it in my front end and run the report from the front end... please help!! thanking in advance!! |
The End.