6,934 Topics
 | |
| | Assuming it can be done (as I've been told): How do I import ".mdb" (MS Access / OleDb) files (specifically, Northwind sample database files) into SQL Server 2008 (Express with Advanced Features)? |
| | I am trying to select data from a database in the based on a condition....Its just a simple select SQL query [CODE]SELECT playerid FROM player WHERE username = 'John'[/CODE] Therefore, from this I would like to store John's playerid to a variable and then use this variable. Below is my … |
| | I've installed SQL Server 2008 Express with Advanced Features, but I've been having so-far insurmountable problems installing the AdventureWorks sample databases. However, I've successfully installed the Northwind sample databases, and I've downloaded the installer for the Pubs sample databases, so: Can SQL Server 2008 access Northwind or Pubs databases? |
| | Hello, I must modify an application build with MySQL to make it work with other databases. This application works perfectly but use quotes in all the requests even for numeric columns. For example: [code]SELECT * FROM table WHERE id=[COLOR="Red"]'[/COLOR]1[COLOR="Red"]'[/COLOR][/code] (where id is declared as INTEGER) Do you know if this …  |
| | Heya, Not sure this is the best place to post but can't see a better forum :P Not 100% sure I've done this right so looking for some clarification. Thankies Steph -------------------------------------------------------------------------------- CreateTables.SQL [code] DROP TABLE student; DROP SEQUENCE student_counter; CREATE SEQUENCE student_counter INCREMENT BY 1 START WITH 1 NOMAXVALUE … |
| | Dear all I am asking about the MS SQL server certificates type & which of them I need as a web developer & what I need to study for passing MS Exam I wish an perfect answer & recommended tutorial I found a tutorial on for MS SQL server 2008 … |
| | Hi, I hope I am in the right place for this... I am looking for some help with a query. Basically, I am using a shopping cart which has option groups and I have created 2 new option groups. I now need to add these option group id's to all … |
| | I installed SQL Server 2008 Express, basic edition (SQLEXPR32_x86_ENU_Bootstrapper.exe, version 9.0.30729.1) without any problem. Then I attempted to install AdventureWorks Sample Databases for SQL Server 2008 (SQL2008.AdventureWorks_All_Databases.x86.msi). This attempt failed because SQL Server 2008 Express, basic edition doesn’t support Full-text Search, which AdventureWorks requires. So I uninstalled SQL Server 2008 … |
| | hello...hi im using VB.NET...can u guys teach me how to convert an Access database to a SQL server database? i really hope u all can help me.. thank you... |
| | I did a full installation of SQL Server 2008 Express. Looking at Add / Remove Programs, I see the following pertinent programs installed: SQL Server 2008 SQL Server 2008 Browser SQL Server 2008 Management Objects SQL Server 2008 Native Client SQL Server 2008 Setup Support File (English) SQL Server Compact … |
| | I'm working through the lessons at Programmer’s Heaven's "C# School" tutorial ([url]http://www.programmersheaven.com/2/Les_CSharp_0)[/url], and I'm currently on lesson 13, "Data Access in .Net using ADO.Net", so of course I've been trying to connect to Programmer’s Heaven's SQL and MS Access / OleDb databases. Unfortunately, they're now offline. Can anyone please tell … |
| | I'm working through the lessons at Programmer’s Heaven's "C# School" tutorial ([url]http://www.programmersheaven.com/2/Les_CSharp_0)[/url], and I'm currently on lesson 13, "Data Access in .Net using ADO.Net", so of course I've been trying to connect to Programmer’s Heaven's SQL and MS Access / OleDb databases. Unfortunately, they're now offline. Can anyone please tell … |
| | I have a solutin with forms that use table adapters to input data into sql tables and that all works fine. My trouble comes when I have another form that uses a sql stored procedure. When I try to connect to the server I get an error that the login … |
| | I need help in using "[COLOR="red"]between[/COLOR]" sql function. I don't know how to use it. I am comparing two time using [COLOR="red"]dtpicker[/COLOR]. The time should only be acceptable if I input between 6:00am and 6:00pm like 7am, 8am,.........6:00pm. 5am below and 7pm above are not acceptable. In need help. . … |
| | hi i need to know how to query a number of count on a particular table let say i have [B]emp_id[/B] and [B]emp_name[/B] field. on my table their are 2 records. the result looks this: rowcount | emp_id | emp_name 1 1000 albert 2 2000 leah is it possible? thanks, … |
| | i have only one coloumn in a table i want to dispaly all the datas in a row.Name of the table is student which contains only one coloumns slno Student Slno 1 2 3 4 5 I want to display them as slno 1 2 3 4 5 Thanks in … |
| | hi everybody , this is my first post here and my only hope !!! i have to build a website for my vb.net/sql server classes final project , it s a real estate website that has a sql server 2005 database and i have to connect throuhg it with vb.net … |
| | Hi All, I plan to have a website that has database connect to it. On my database, I want to display vietnamese characters (Input and output). How can I add vietnamese collation on my MS SQL Server 2005 developer edition? I am looking forward your help. Thanks. |
| | hi, what is the diffrence between delete and truncate command in sql. plz send me tutorials of oracle also. waiting for your reply. <URL SNIPPED>  |
| | Hi All, I plan to design a website that uses for online news or magazine. I am having MS SQL Server 2005 Developer Edition. Please help me how to design a database. Please let me know where I can obtain information to design it or db diagram. Thanks. |
| | Hello I am upsizing a MS Access database to SQL. I am keeping the MS Access 2003 frontend and using a SQL Server for the Backend. All the MS Access VBA code seems to be working fine except for the code below. I have the same code using different tables … |
| | Dear All, I want to establish a remote connection with sql server 2005 in my Asp.net web service. How to do this in a effective and secured way, Please reply me with sample code, that will be very helpful for me. Thanks in advance, Thanks & Regards, Vasanth  |
| | Hi guys, Im trying to create a console app that will read from a text file and import the file into a sql database. I have completed the following already: Read from a text file and put out to console Read from sql database and put out to console Now … |
| | |
 | HI, I am Using VB 6, how do I sent data over the internet to an SQL DataBase |
 | Sorry been out of commision for a few months. Got a newbe question. What value is returned from an sql query that returns no rows? Example: [code=php] $a = "SELECT * FROM a WHERE b = c"; $b = my_sql_query($a); [/code] Note: Table Name - a Table Field - b … |
| | Hi, In PHP page, Code below always returns TRUE even no record is updated. How can i solve this problem? Thanks [code] $q="UPDATE login SET password=SHA1('$newPassword') WHERE id='$loginID' AND password=SHA1('$oldPassword')"; $run=mysql_query($q); if ($run===TRUE) { echo "SUCCESSFUL"; } else { echo "ERROR: Old password is wrong. Please try again."; } [/code]  |
| | Hi, I have a table above 8.000.000 records. I am running a query like "select * from table where id=1093203". And the query turns in 24 second. This example i tested in SQL Server 2000 v8, Windows 2003 sp2. I am running same query in Windows Xp + Sql server …  |
| | Hello everyone, I am fairly new to java so plese bear with me, here is my question: i made a query to a sql database in a jsp page, what i would like to do is is import the result set into java so i can do some math with …  |
| | Note: I debated whether this should go in ASP forum or SQL Server forum and I think it belongs here. Ok, I have a classic ASP web application, a custom intranet, which has been used in 7-8 different installs, 3-4 different servers with no issues. It uses a SQL Server … |
 | Hi all professionals, I am just an amateur compared to most of you. I am contemplating starting an extremely lengthy program, just for my own purpose, which basically does a holiday reservation to whichever and whatever place in SA, for now. I am just thinking this idea for building up … |
 | Good Day All i have a table that carries a Field that has data like this [CODE] 10101010101010[/CODE] Now the Function that adds this 1's and 0's is working like this. If its selected insert "1" else "0", So if i can interpret the above if will be [CODE] 1 … |
| | Hi, I'm new to SQL Server. I just installed SQL Server 2008 Express. Then I opened Management Studio, right clicked on Database and created a new Database. Then I expanded Database, right clicked on Table and created a new Table. Now, my question is, how do I add data to … |
| | Hi! I want to read a table from Access to Java. This is the table: [url]http://kepfeltoltes.hu/090221/heights_www.kepfeltoltes.hu_.jpg[/url] I tried to do it with HashMap, but I have a problem, and I don't even know what im doing is right, I have no practice in this, altough I've been trying to find … |
| | Hi All, We have a local MS SQL 2000 database which is daily updated by the users. We have a remote MS SQL database under windows based hosting. Now i need to update all existing data from local MS SQL to remote MS SQL database. I also need to find … |
| | Some of the time, we have to run/execute the SQL scripts using command prompt or the sql browser, but i were to replace these actions with just a single click of button, i need to create a functionality with java whereby users can perform these actions with an interface. But … |
| | hi everyone, i just want to ask if it is possible for the SQL INSERT INTO to LOOP? for example, insert new records in TABLE ten times with the same values (colum1,column2,column3,etc..) is there an alternative way instead of typing (INSERT INTO.. 10x) statement repeatedly. thanks. |
| | Hello all, I have been tasked with figuring out a way to automate a form letter process that currently is done mostly by hand with a lot of copy/paste. We have letters that need to get sent out based on our internal system. Someone now looks up the items in … |
 | Hello. I'd like someone to help me figure this out. I have a small database: Country, State, City. Three tables. [B]I have to check that none of the names repeat themselves. Meaning, no two USA's, no two Brazil's, etc. [/B] My professor also gave us the following requirement: [B]You can't … |
| | I want to write an sql statement in c# where I want to pass a "true" or "false" value basing on some condition... can we pass true to sql statements Ex: [CODE]select * from emp where (empid=1234 and true); select * from emp where (empid=1234 and false); [/CODE] This true … |
| | I am new to Oracle and SQL. I need to write a select statement for a student extract at a college. For ex: select ss_id from id_table This will return all id's from this table and they are a length of 9 digits, i need to return just the last … |
| | Hi All I'm new here and have searched high and low for an answer to my problem, and have so far had no joy. I am trying to create a if/else statement depending on the outcome of a SQL command that should be extremely simple and basic, but for some … |
| | My server configuration are . SQL Server in Marchine1 - is setting in Mix Mode(SQL Server and Windows Authentication) . IIS Server in Marchine2 - is setting as following Directory Security - > Authentication and access control .Unchecked "Enable anonymous access" .Checked "Intergrated Windows authentication" .Checked "Disest authentication for Windos … |
 | helllo great programmers please how do i export the data i previously have on excel sheet to my published sql database |
| | I'm new to T-SQL and trying to program a simple query: Table1 Location ID Flag Table2 (many to Table1) Location ID Code Select Table1 Location_IDs where the count of Table2's Code=value is 0 Thanks for your help! |
| | I am using SQL Server Express 2005 as my Database and programming in C# 2005. In one of my Table "Results" I have a field named "ResultDate" of DateTime data type. In my form I have a DateTimePicker. I want to save only one record for a particular date, hence … |
| | Hi, I have saved documents into my SQL Server 2005 database and they have been converted to bytes. My web page is made with VB.NET in Visual Studio 2008 with ASP.NET. The following is exactly what I need to achieve; 1. Allow user select document with a button 2. Select … |
| | Hi all, I was thinking of using Triggers to take care of my history tables. Two questions remain: 1) Transaction Scope I handle complex Operations in my DataAccessLayer (C#,ASP.NET) with Transaction Scopes. For example: [code]private void InsertFamily(FamilyDTO) { using (TransactionScope scope = new TransactionScope()) { try { InsertFather(); InsertMother(); InsertBrother(); … |
| | Good day.! I am having problem with passing the parameter value. I have a page called index.php. This page has a textbox named "username" when the user login and type his/her user name in the textbox named "username" i want the data of that user to be displayed in the … |
| | I want to dynamically update and display Label captions using hidden texbox which read from certain SOL DB table column. Am using label1.caption = text1.text Very New to Vb.net 2005 |
The End.