9,022 Topics
hii i wanted to insert questions, options and correct answer in the database(Multiple choice questions). I have around 8000 questions to be inserted. I tried with copying entire content from word into notepad and provided delimiters for questions and answers but the entire question appears in a single line(it is …
"Two or more people uses this site at this time" while running in ASP with sqlserver2000. How to rectify the errors?..
Hello all, I'm having a problem with converting a script from MySQL to MSSQL .. the problem is within this query: [CODE]select * from data where name LIKE '$name' AND spot LIKE '$line' AND piret LIKE '$piret' [B]AND timestamp >= '$before' AND timestamp <= '$after' ORDER BY timestamp DESC[/B][/CODE] the …
Hi. I am using Visual Studio 2008, and Sql Server 2000, and I have the following code: [CODE] 'Load connection module connection() cmd = con.CreateCommand cmd.CommandText = "SELECT * FROM tblUser WHERE username = 'xxx' " da.SelectCommand = cmd da.Fill(ds, "tblUser") dt = ds.Tables("tblUser") MsgBox(dt.Rows.Count) [/CODE] I don't know why …
Hai, I am a VB programmer and i had developed an ERP software using VB and MSSQL as Backend.On that software i am facing some problems with its speed and data storage capacity.So iam [B][COLOR="Red"]seeking a best language and databse for developing strong high speed software that can use in …
Hi, my names are Samuel Ikumoinein, i am writing my final year project on Database Management System for Healthcare Solutions. I am now in the system design stage and i have no idea on what software i am going to use or a concrete structural design even though i already …
I am new to MS SQL. I would like to create a table variable and insert some and and get the data from a java file. I am able to declare and table variable and insert the data into the table. But when i try to get "Must declare table …
Hello, Before posing question I have googled on pivot query,pivot sql query but none of the sites explained the syntax abut making a new table from a pivot query .And that's the reason I asked the question .I know the pivot query but how make a table of the results …
Hi I have 4 comboboxes..and any value that I choose.. I get a whole set of fields displayed in my datagrid view.. I want to make a difference..the value that I choose in the combobox, has to appear green in color in my datagridview. How do I do this ? …
I'm working on what i consider to be one of the hardest DB designs i've ever had to do in my 10+ years of programming/design/architecture. I really need to bounce my ideas off on other experts but i'm having trouble finding the right forums. 1) is this a good forum? …
Hi, I want to select the part no(part_no), transaction date (curr_date), and in stock qty (cost_layer_qty) from table inv_tran where the product first goes into negative quantity. Do I use a group by for curr_date, or how do I do this? Thanks in advance
I got a table that looks like this: ACCOUNT---------NAME------------BROUTE------------BACCOUNT-----------VALUE ---[COLOR="Red"]NEED[/COLOR] 111111................BILL...............77777777...............88888888...............345.34-- 222222................BOB...............77777777...............88888888...............0.0-------- 111111................BILL...............77777777...............88888888...............454.34------[COLOR="Red"]2225.67[/COLOR] 111111................BILL...............77777777...............88888888...............657.67---- 222222................BOB...............77777777...............88888888...............768.32-- 444444................JIM...............55555555...............66666666...............23.12---- 333333................TIM...............55555555...............66666666...............36.58-------[COLOR="Red"]685.02[/COLOR] 333333................TIM...............55555555...............66666666...............625.32--- There are over 62 thousand entries with different values for columns listed above. I want to use (BROUTE + BACCOUNT) as a primary key for this query. "Bank account + bank routing …
Hi. I have previously designed an ASP.NET system that interacted with SQL Server 2005. I now want to design a desktop application using Visual Studio 2008 that interacts with an SQL database. I had planned to use the same sort of coding to implement this new system. For example - …
Hi there, I am new to this site and a little lost, so to speak. My name is Jaco and I am from South Africa. New to computer technology and used to work for a company dealing with SQL and reporting. I used to write the company reporting from SQL. …
Is there any way to know that there was an 'insert' into SQL Server's database without checking it like every minute (in C# / VB.NET)? Thanks in advance.
hi im pretty new to software development. i was wondering if theres a way to pass a parameter to a javascript or c# timer from an sql database. i want the timer to be a countdown timer. i only know how to hard code the time limit but is there …
Hi: I am writing code in VB but SQL is the major role here.. I am checking if MFG="DELL" in table1 and if that is there I need a msg box saying "DELL is supported" [QUOTE] Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Dim con …
Can a stored procedure be written with a column name? For Table1 with ColA, ColB, ColC, I want a query like: EXEC sp_Mine 'ColA', '100%' I want the results to be like: SELECT ColA, ColB, ColC FROM Table1 WHERE ColA Like '100%' I tried setting up this stored procedure, but …
Hi, I have the following data in a table called staging, and it is in the format. C1,C2 and C3 are column Headers. C1 C2 C3 41 te cc 51 te cc 42 te cc 41 te cc 51 te cc 42 te cc 41 te cc 51 te cc …
Hey guys I've got the following code drawn up. But it doesnt work has I wanted it to and can't figure out why. If the user doesn't exist or if that username has been disabled then the query should return -1 otherwise it returns 0. Now that doesn't happen. It …
I'm working on a project that just needs to know that its 08:00 or 14:01. I dont need or want to store anything about date. When I store the time and then try to check it against the current time I'm runnig into problems. where (timeofevent = Convert(char(19),current_timestamp)) this doesnt …
. Nice forums here, I've been browsing 1/2 the day! My name is Bill Burke, and I'm with a startup company... I've just put the finishing SEO touches to our website. I'd love to hear from anyone who can point me at good people to know re: SQL Server, and …
Hi All, I want to make a SQL parser in Java which will give the names of view ,column names in select clause,and table names in 3 different arrays. This is the SQL Query which is there in text file. create view NAME1 as select a.col1 as alpha, b.col2 as …
Im having trouble trying to pass a parameter to a SQL query that I am trying to run on a DataTable, that Im using to Dynamically populate a treeview. Im not having any trouble filling the first nodes, but to fill the second nodes, I have to use a query …
I try to access a same database using two different system, a) a window based system and b) a web based system. Both are using VB.NET. But it seem like the there is either one of them can access the database at a time. When one of them running, the …
Hey guys I was curious to see how ADO.net and SQL server could rank against each other. I have read into it and from what I understand is that SQL server is a medium for retrieving data and ADO.net is for storing data. Am I right in believing this? Does …
Hi all, I m a newbie to sel server. I want to read transaction logs in SQL Server 2000 for doing some processing on them. I asked many persons reagrding this one told me that it can be doone by creating replication of database. so if anybody having any idea …
Hi, I am not getting any results from stored procedure ,passing a parameter to the stored procedure . My code is [code=asp]<%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SqlClient" %> <%@ Import Namespace="System.Web.UI" %> <script language="VB" runat="server"> Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load Trace.Write("This msg is …
Hi, Im running MSFT SQL Server Mgmt Studio 2005 and would like to export all the tables in a DB where the # of rows > 0. I would like to export all tables to individual XLS files. I've gone through BCP documentation to no avail. [B]Is there a simple …
i was just doing a simple thing in C#, just trying to put the values feeded in the text boxes in sql database. i am giving the code below the code executed perfectly but when i went to look into the table data there was no data inserted...... pls HELP...!!! …
i created a sql database with table land. columns; LandID int PK LandCodeID int LandName nvarchar(100) LandFlag image Allow Nulls ive created a dataset in my solution. from my Data Sources i can drag & drop the table Land to my Form1 as DataGridView. it puts all the columns above …
Hello, I'm newer to programming and trying to do something that has me stumped. I need to read files from a directory on a server and compare those file names to a field in a database. When I find the file names that are the same, grab a different field …
I have a table which counts messages sent to a particular department. the important structure is basically ID Department Message DateSent I want to be able to retrieve a resultset where that looks like this: Department MessageCount something like a SELECT COUNT(ID) Where Department=XXX but collect each individual department count …
[code]strSQL= "SELECT ShowsPictures.ID, ShowsPictures.Show, ShowsPictures.LinkToWork, Works.*, Artists.ID, Artists.Surname, Artists.Name FROM Artists INNER JOIN (ShowsPictures [B]RIGHT JOIN [/B]Works ON ShowsPictures.LinkToWork=Works.ID) ON Artists.ID=Works.Artist WHERE ShowsPictures.Show='"&intShowID&"' AND ShowsPictures.PicOnShowsList=True"[/code] I wrote this SQL instruction and it does work with a RIGHT JOIN or a INNER JOIN as second Join (in bold), but doesn't with …
First of all this is an example of soemthing i am trying to do, but the idea is the same as what i want to acheive. Ok my problem is, i am filling a listbox control with data from two tables. eg. Table A [LIST] A_Id desc total [/LIST] Table …
when i want to execute the following expression [code=sql]INSERT INTO Birim ('erol', 'serbest', 'asfsda')[/code] it gives an error like that: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near ')'. where is my mistake?
hello friends, how to import .MDB file to sql server please tell in detail please Rakesh Nagekar
Below is my code in which c1.menu() gives my values from database in Rmenu. but when compilation proceeds downwards, there is another line ResultSet Rmenu1 = c1.menu1(); which gives me another result set Rmenu1 which have values from database through menu1(); function. But after execution of its while(Rmenu1.next()) when the …
Hello Friends, Good day to you all I have been using Access as a base for all my vb projects. I am told SQL is more secure and can handle a wide range of data. I have therefore decided to give it a try, but I don't have any Idea …
Can anyone help? I have been fumbling around with a SQL statement for days trying to make this work. I am looking for a Statement that will output a table based on an incremented number. Example Table1: Value1.......Value2.......Incremented Number 14...............null.............1 12..............15...............2 12...............98..............3 15...............14..............4 17...............15..............5 1.................14..............6 5.................98..............7 Example Table2: Value1.........Value2 X030............1 …
I have a problem inserting record into the database collecting the data from textbox and combobox and inserting it to the database but i have been getting error for the past few hou that i have been trying to deug it but the error it giving me is Private Sub …
Dim strSql As String strSql = " set quoted_identifier off " strSql &= " declare @strSql varchar(150) " strSql &= " set @strSql = ""BackUp database SWAMC to disk = 'D:\SWAMC"" + Convert(varchar, getdate(), 112) + Replace(Convert(varchar, getdate(), 108), "":"", """") + "".dbb' with init,skip""" strSql &= " print @strSql" …
Hi I have table2 and table1. I want to check if table2 values exist in table1. If they do, I want them to be displayed on datagridview in a form. The table1 and table2 have same fields except that the primary key in each table is the serial number. Even …
I have an Access database that I use to keep track of account and inventory information for my job. I am currently writing a C# app to allow me to search through and pull up the information from a couple different tables and display them. How can I access the …
I'm having a strange problem. I have an array of strings that I need to separate into separate data members and insert into a SQL database. It all works fine, except for where I convert a string to a decimal and insert that. It works if the decimal has no …
I want a button click event to do this: can i use "UNMATCHED" keyword in the same SQL Statment using a UNION ? pls help me with this!! table1 is my master Db and table2 is my work DB.. both have same columns expect that primary key in both tables …
I am facing a problem in Borland C++ code. There is a database in SQL server 2005. Merge publication is done on the database. the borland c++ application connects to that database. There is one table in the database named DBTable which we are trying to open in the following …
the code worked perfect on Friday and when I come back today and try.. the RAM alone works fine in the T-SQL but the Mfg, Make, GraphicsCard and GraphicsVersion do not work atall.. they dont give me any queries atall in the data grid view o/p.. why am i stuck …
Or should I say just making sure all columns are created and proper. I have 6 databases I need to keep maintained to a similar level, all standalone. What is the best way to keep the schemas up to date without resorting to manually updating...? Obviously I cannot use DROP …
Hey everyone, I am on a month long project on a coldfusion script I have to work on. Bare with my noobness here :P Basically here is the jist of it. -- I have a huge sql database filled with various random people information, such as their phone #"s, email …
The End.