6,934 Topics
 | |
| | Dear SIR, I am using sqlserver2005. Table1 has a column named bill_no and its type is text Now I want to change its type "Numeric" When I do this the it displays this error message --------------------------- Microsoft SQL Server Management Studio --------------------------- Conversion from 'text' to 'numeric' is not supported …  |
| | Dear all. I want to store csv file via sql sever and access the csv file for bulk import option,give me some example procedure that very useful to me. somebody help me.. Venkatesan.P  |
| | I purchased a book that included an evaluation version of 2008 enterprise. I had downloaded SQL 2005 express and had tried to download 2008 which said it succeeded and I was left with 2005. I checked the OS list of supported ones. XP professional is on the list. XP home … |
| | Hi, I want to run sql script from patch file I found how to run script file using sqlcmd but I don't want to run it from file I want to put the sql code inside the patch file |
| | Dear Experts I have applied following custom Format to DateTimePicker dd-MM-yyyy So now DateTimePicker is displaying data as 15-01-2010 Sql server 2005, table1 has column named Date with datetime type How to store DateTimePicker text into date column of Table1 I want to save only date not time as 15-01-2010 …  |
| | Hi guys, This is my first post here. Actually wanted to insert record into an sql database (using sql server 2000 and visual studio 2000) I'm using a dataview to see if the user already exists. This, i've been able to retrieve and it works. Now if the user does … |
| | saving all data from data grid view in vb.net 2005 into sql server 2005 database table  |
| | Hi everyone . can you help me in making a log in form for administrator using the accounts from the MySql database .. i want to know the code in connecting database, because i am new in SQl database Programming.. example there are 2 fields in SQL database the Username … |
 | Hi and I have a database with over 32 million entries and whenever I try the below mysql query or simular it crashes the sql server unless I use phpmyadmin. I have 4 columns all indexed and all are the char() type with a fixed length. Below is an example … |
| | hi.. im trying to put my data on a server & work on the same from other machine..im using win2003 as OS of my server & on the other machine's XP is the OS. my problem is, when i try to run my C# applications from the other machines, it … |
| | [code=sql] alter table pets_like_boys drop constraint pets_like; alter table boys_like_girls drop constraint boys_like; alter table girls_like_pets drop constraint girls_like; drop table pets_like_boys; drop table boys_like_girls; drop table girls_like_pets; create table pets_like_boys (pets_name varchar(32), boys_name varchar(32),primary key (pets_name)) ; create table boys_like_girls (boys_name varchar(32), girls_name varchar(32),primary key (boys_name)) ; create table … |
| | Hi there! First off I´m new here, so, I'd say HELLO EVERYONE an thanks for years helping. I have the following problem: I need create a installation of a C# app that uses a SQL SERVER 2008. I am using INNO Installer because I thought it could be the best … |
| | Hi, it's me agian... I was asked to do reasearch on how to upload a txt file's data into a MS SQL Database (corresponding columns etc.) I've searched a bit on the internet but don't find what i'm looking for... I just want to ask does anyone have an idea …  |
| | Hello everyone I've been trying to google this and had no luck with this issue So i have this form where it prints a certain record i search, but im trying to do restaurant form and a print form that it will print the last order done. So I Know …  |
| | Hello, I'd like to get help for a database engine in Python. I know that there are loads of databases out there and I cannot create one which would be even near as good as SQL but I'd like to do it for getting a good understanding of databases and …  |
| | Hi I am learning how to use database. I am using sql server 2005. I would like to know how to make an sql query to the database from vb.net. I have tried some code. what i would like to know is, how to make the sqldataadapter statement with 2 … |
| | hi.. Im trying to install SQL Server 2005 on my server.. but at a certain point it is giving an error which is unknown to me..im attaching a snap of the error.please let me know how to solve this error.. What does that domain account mean??? wher i can create …  |
| | Hello every! I'm having some issues trying to pull data from a table. I need to pull data under the following constraints: The PRINTNAME column can not be NULL and can not be empty, plus the DISABLED field needs to be 0. This is what I have now, but I … |
| | I was wondering if it was possible to this: example [CODE] if exists(Select * From table) select item from table set returnValue = 1 Else set returnValue = 0 [/CODE] Or if there any other way of doing this this |
| | HI Tuning sql for high performance is my project title... can any one explain wat is the exixting system and tell some of the ideas regarding project... <EMAIL SNIPPED> help plz.... |
| | Can anyone please point me towards a good C# SQL tutorial. I've been looking for about 10 minutes, but I can't find a good one that actually works. I would apperciate anyone that helps me! Thanks! Nile |
| | With regards to another thread, [url]http://www.daniweb.com/forums/thread251069.html[/url] on how to compare the current date to retrieve relevant data (Details there), now I have issue on storing this query result on a VB.net variable. It works in this way. It is an academic work to do a ecommerce website, and I need … |
| | Hello there, I am facing a problem for a website i am developing. I have a form with some set of text boxes and dropdown list. When click on submit it transfers the data in the fields and goes to a different website. Now i also want to save the … |
| | In VS 2008, for example I have sql command like SELECT * FROM STUDENTS WHERE STUDENTID = @STUDENTID Then I append value into it, for example 15 How to I catch this sql command SELECT * FROM STUDENTS WHERE STUDENTID = 15 Thx in advance |
| | Dear everybody I have a question! I have a database with a invoice table for storing invoice data. In this table i use the InvoiceID as my invoice number. My problem is that if a user makes a mistake and the invoice is deleted in order to create a new … |
| | I am a beginning programmer and am having a problem with adding a record to a customer table in a Microsoft Access database. I have worked for hours reading my textbook and troubleshooting to no avail. When I execute this code below the record is not added and I do … |
| | Hello guys! I am developing simple desktop application that suppose to connect to SQL DB launched on remote server. Everything going fine, exept that when connecting to DB I get exeption "Login failed for user 'guest'." So, looks like i need to create some user with password and give him … |
| | Hi folks, I have a mysql database and I have written some PHP to view records, add records, delete records and update records. The problem I have is updating checkbox fields of a record. Everyhting was working fine and updating correctly. Then I tried to automatically populate the form fields … |
| | hey everyone need some help again, i have two computers both running in vista ultimate. one is a server and the other is like a terminal. my problem is, how do i connect the terminal to a database which is in the server? please provide me a step by step … |
| | Hello everyone I am quite new here and have a very tricky issue that bothers since days. I posted the question on the PHP forum together with a sample of my embarrassing code. If this is wrong that I raise the issue here in MySQL forum, too, please forgive me, … |
| | |
| | I have SQL Compact installed, and I'm using VS C# 2008 Express. I'm kinda confused though. I try to add: [CODE]using System.Data.SqlServerCe;[/CODE] And get an error. It don't even pop up in intellisense. I've tried adding reference paths to the DLL's (not sure if I'm doing it right) but still … |
| | I am trying to return the value of a column if a condition is met: [CODE] cmd.CommandText = "SELECT plan_entity_id FROM PLANNER_INFO Where plan_id = plan_id"; cmd.Parameters.Add("plan_id", SqlDbType.Int, value); con.Open(); returnValue = Convert.ToInt32(cmd.ExecuteScalar()); [/CODE] for instance, if Plan_id is 1 it returns the entity ID which is equals to 1. … |
| | Please help me to creat advance login form and link to the MySQL database..Im a new software programmer and i don't have much idea on vb.net.. |
| | I've managed to get PHP to work well with SQL, but date and time-related parts of my site are proving difficult to understand. I've created 3 records with these dates: December 26th (2009) - 2:25pm January 5th, 2010 - 3:00pm January 7th, 2010 - 9:00pm I'm trying to get it …  |
| | Dear Experts I use following codes to display image from sql server. On this line of codes [CODE]Dim ms As New IO.MemoryStream(CType(row("user_img"), Byte()))[/CODE] this error messages appears [CODE]Unable to cast object of type 'System.DBNull' to type 'System.Byte[]'.[/CODE] How to get rid of this error message. This message appears because image … |
 | hey, i have a problem regarding the format of the date format. in the form i have the date format in dd/mm/yyyy and when i try to save the date in that format in sql database, it's not accepting in that format. but i need to save the date in … |
| | Currently using ASP.net 2005 I am havin an errot in update statement my code is: Dim myConnection As OleDbConnection Dim myCommand As OleDbCommand Dim ssql As String = "UPDATE passwrd SET password ='" + TextBox1.Text + "'where username='" + TextBox2.Text + "'" myConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " _ & "Data … |
| | Hi i just have problem in my software i just want to apply more then one condition in my quary which is joined "and" operator plese helpe me by given an example(coding) it is very urgent |
 | i'm a beginner in vb.net i just want to know if it is possible to store the formatting of a text to ms sql so that the next time i retrieve a record that i've already formatted, it will display the format that i did for that record. if possible, … |
| | could u please explain me d difference between 'not exists' , 'not in', 'not all' in detail. Thank You. |
| | HI folks, pardon my ingorance, but is there a possible way to connect to ms sql express directly to the server or you have to copy the .mdf file to your project and then connect to? another question how do you connect to the ms sql express? (I come from … |
| | I have a T-SQL function (transact SQL is SQL server 2005 programming language, with many limitations compared to say C# or Java). It currently works but has severe limitations. Its input is string (formula) that has ternary operators used in it. The function converts it into CASE statement and returns … |
| | This code demonstrates how age might be calculated and filtered using the DateDiff method in SQL. Also, note that both the parameters are set to NULL by default, hence making them 'optional' to a certain limit. |
| | The title is pretty self-explanatory. I'm working on a PHP engine, and I'm trying to implement a SQL query generator. The hardest part of this will be designing the system for using the SELECT command. Are there any practices that I should try to follow when designing this, or any …  |
 | I am working in VS2008. I use vb.net and asp.net. MS SQL2005 as database server. Occasionally when two sets of data are inserted at nearly the same time, I find that one has "stomped" on the other, over-writing it's data. The inserts are done via a stored proc using SCOPE_IDENTITY() …  |
| | hi.. How can i add a database in my website using asp.net. its a student project and i hav to create an online flight reservation system. in which i am using SQL Database? Kindly tell me by some example that how can i add record using some form ? but … |
| | Hello, can anyone help me find a document explaining a general way to design "Live" tables in SQL? i have an application linked to a db that contains live tables in it (tables that have records always updated, inserted, deleted and many applications read/write in it) my biggest worry is … |
 | File under FAIL: social network widget maker RockYou has fallen victim to a SQL injection flaw and as a result some 32.6 million users are being urged to change their passwords as a matter of urgency. Security specialists Imperva discovered the problem at social networking development site Rockyou.com and issued …  |
| | Hi am working on a project and am using sql server 2005 express as my database server, the problem is i can;t connect to the sql server from any machine on my local network (windows). Below is my connection string [CODE]con.ConnectionString = "Data Source=webserver1\SQLEXPRESS;AttachDbFilename='C:\POSM_DB.mdf';Integrated Security=True;Connect Timeout=30;User Instance=True;" [/CODE] It works … |
The End.