• Log In then Output the Data of the Logged Person C# SQL 2005

    I have a program that requires a user to input his/her IDNumber. If it doesnt exist the program will prompt to go to the NewRecord section. When the user input his IDNumber and he will be logged on to the real program. After doing the program and pressing the DONE Button. A messagebox will appear...

    C1a4h15 pointsBadges:
  • Change the size of a column and then reorganize the rows in SQL tables

    I think this one will be tricky. What I have is a table like: CREATE TABLE PHOTO_DETAIL   (     "PHOTO"        VARCHAR2(25 BYTE) NOT NULL ENABLE,     "NUM_LINE"   NUMBER(20,0) NOT NULL ENABLE,     "PHOTO_LINE"  VARCHAR2(180 BYTE)   )   what I am going to have is: CREATE TABLE...

    Hispi25 pointsBadges:
  • How to display values in one table by referring and checking values in another table?

    how to display values in one table by refering and checking values in another table

    Sqldb5 pointsBadges:
  • sql 2008 export to txt for backup and incremental backup

    Hi i have one db that i want to back up, so thought id export to txt file/flat file then back that up and then daily increments into that file? cant find the steps to do it..have the wizard..

    Jordaan5 pointsBadges:
  • How do I restore my SQL .bak file over the existing database?

    How do I restore my SQL .bak file over the existing database? Do I need to delete what is there already? On a new Windows installation I need to restore our production SQL database from a .bak file. What steps do I need to take? Can I overwrite data or do I need to restore to a fresh database?

    ITKE352,565 pointsBadges:
  • How to keep date format when creating Index on a Table

    I have used CREATE TABLE to create a PF which contain a DATE field. And then use CREATE INDEX to create a LF with data selections. However, when I check the DATE field, I find that, in the PF, its Date Format is *ISO; but in the LF, its Date Format has been changed to *DMY. How could I keep the...

    MacroJ20 pointsBadges:
  • SQL Server 2008 query To Find Columns with incorrect information

    This is difficult to expalain so i will try and give you an example Record                  Surname               Age            Town 1                          Smith                   ...

    Davewaltonuk20 pointsBadges:
  • How can I write a SQL query to get the database name ?

    How can I write a SQL query to get the DB name ? Usually we use SELECT DB_NAME() AS DataBaseName, but at that time teh DB is in use. If we didn;t write use [dbname][/dbname], is there any way to get the DB name ?

    KulkarniMandar5 pointsBadges:
  • surf control reports will not work after I enabled drill downs

    reports will not work after I enabled drill downs (v.2.6) Followed directions and enabled drill downs.  Now, reports and drill downs will not work after the day I reset the drill down.  Checked directions and no indication of making changes anywhere other that the configuration menu in...

    Jvidal5 pointsBadges:
  • SQL server query to search for table and column data in database

    I want to find the data in a table,but i dont know the table name and column name.All I know is the data and the database name .Is there a query to find the table and column

    Linu438910 pointsBadges:
  • Import data file into SQL database

    I need to import tis .dat file into sql database table having four column client-007092~WITCO clname-CORPORATION ,matter-0005,mattername-LAZY OIL V. WITCO

    Anamika8315 pointsBadges:
  • File access restriction for users in Logmein

    Hi, Please let me know whether logmein has a feature to restrict access of certain type of files for users. For example we have sql database having customer,account details etc.We need to restrict user who connects remotely to not to access account related files.

    Knw5 pointsBadges:
  • How to use Insert command between two servers to speed up performance

    We need to take data from a table on one server and write it to another in the fastest way possible. We tried Insert command and it worked perfectly as long as it was running on the same computer. When we tried to use it to update another computer/server on our network, none of the data got there....

    Studentofsql5 pointsBadges:
  • Forum data transfer – SQL

    Hi, my question is: we're developing a new forum so want to learn how can we transfer the data in one or two tables in old forum’s SQL database to the SQL database of this new forum? that means we hope some posts in old forum to be moved to the new ones. Please give the steps to do it. Thank you...

    Bmblog20 pointsBadges:
  • Accessing MS SQL Server database from the iSeries

    How to set up TCP/ IP on both ends( SQL server and AS/400)? I keep geting "host name not found" on as400. Thanks, Lan

    Lan1230 pointsBadges:
  • Multiple databases on a server – SQL

    My queries Can PostgreSQL(as database for a Jboss application) and MS SQL(as database for a tomcat application).Are there any known conflicts/issues ? Best regards

    Rajg5 pointsBadges:
  • Linking Visual Basics and SQL database

    I wish to know a code that can enable me to link visual basis and SQL database in an organisation.

    131113115 pointsBadges:
  • SQL saving off data created to copy into new database

    Data is created in one SQL DB for testing and then a new DB is created. Is there a way to save the data you need for testing in the new DB, so you don't have to create it each and everytime for testing?? Any suggestions would bew appreciated.  Thanks...

    Flyershockey25 pointsBadges:
  • MySQL database size

    Is there a limit on database size for MySQL? my database is getting on the large zise will this effect proformance?

    Worktopm5 pointsBadges:
  • Pulling data from tables on different servers

    I have a join between a table on my local database and a table on a different database on the same server. I reference the non-local database with DatabaseName.TableName. Now I find that the non-local database might be on a different server. I tried ServerName.DatabaseName.TableName, but I got this...

    CO Bill120 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following