9,022 Topics
Hi, I am not sure if my question sounds silly. I have a [B][I]table[/I][/B] that has a few columns like [B]date[/B],[B]source[/B],[B]race[/B] and [B]state[/B]. I need to generate a report. The table stores the details of callers including name,age,sex. But the report need to display in this format counting the number …
I'm trying to display only rows where the identity column is divisible by 5. Could someone help with this?
Hi - this may seem like quite a simple query but i'm new to the SQL world... I have a column in my database (DB_Users) called Email - how would i go about extracting all of the email addresses in the column? I am using SQL Server 2005 and i …
I have it all set up for my satock control, I have the primary keys and foreign keys too, so in SQL how is it to update my stock control when I sell item so I could have products deleted from stock and inserted to sold_product tables please. [COLOR=sienna]tbl_Stock[/COLOR] ( …
Hi, I have an access database that I use for recording the sickness of my employees. One of the tables holds the dates, Start Date, End Date and Count of Days etc. I need to produce a query that will show me a count of all of these dates between …
Hi All, My name is Marc and I live in Halifax, NS Canada. I have 2 great kids and my wife is OK as well. I own a small web site / hosting company and I had a hard drive failure and my back-ups didn't work perfectly. I have a …
Hi, I want to edit the sql server regestration. I want to change the Connection property from Windows authentication to Sql server authentication. But when I edit the sql server authentication with sa username and password, it gives error message saying that the [B]registration has failed for user sa, not …
Hi All, I am writing this just to even know if this is possible. What I would like to do is a UnGroup. Crap this is so hard to explain...okay I have a table in sql that is five columns long. The first Column is, ohh never mind. Copy and …
Greetings Earthlings :mrgreen: I am C# & SQL computer programmer. I have a BS in cs from the University of Houston. I use to be a TPF assembler programmer with SABRE in Ft Worth Texas. Currently, I am raising a german shepherd puppy. I am doing SQL and some Web …
Hello, I'm inheriting a half-built web-site that has runs on IIS over an MS SQL database. The web pages are written in ASP and they are mostly a mess. Is it possible to use Perl scripts in an MS SQL and IIS environment? Thanks for any input or feedback. Silentiopk4
hi, iam having 2 listboxes.In one listbox i am populating products from Msacess.Then after clicking any of the product it should populate corresponding schedules in the other listbox.Below is my code Kindly reply me as soon as possible.. [CODE] [COLOR=#0000ff]Dim[/COLOR][COLOR=#000000] sql [/COLOR][COLOR=#0000ff]As[/COLOR][COLOR=#000000] [/COLOR][COLOR=#0000ff]String [/COLOR]con = [COLOR=#0000ff]New[/COLOR] OleDbConnection("Provider=Microsoft.jet.oledb.4.0;Data Source=D:\Inetpub\wwwroot\WebApplication12\WRMdatabase.mdb") sql = …
I got a problem , can you help me out. Recently started learning how to program in asp.net using Web Matrix. I downloaded and installed all necccessary software as instructed (i.e. the Web Matrix software, MSDE software and SQL Server 2005 Express software. Strangely, in Web Matrix, when it comes …
Hello. I'm seeking some advice from anyone currently working in IT. A few years back I was laid off from my IT job (nothing fancy; tech support for a global company). My youngest kid was having some problems so I took some time away. About six months later I tried …
How do I find, alter, create, edit, etc. the stored procedures, triggers, and foreign keys on an MS SQL 2000 database? I'm trying to figure out how a given database maintains its referential integrity but I can't get behind the scenes on those things. I'm using SQL Server Enterprise Manager …
Hi,I'm new to daniweb forum. I hope someone could help. I have a table called [I][B]Caller[/B][/I] which has a field called [I][B]Area[/B][/I]. I need to select the value of the record in this field that [B]repeats the most[/B]. For example [B]Area[/B] Sel KL Sel Sel Pen KL which means i …
I have a DB which have three types of users: students, admins, and volunteers. I am trying to use SQL Server Enterprise Manager 8.0 to set up those roles such that students can (where appropriate) select, insert, update, or delete from given tables/rows; similarly for admins and for volunteers. (The …
Hi i try to sum two column in Sql, but don't get it.... this way is not working.... [COLOR=#ff00ff]sum[/COLOR][COLOR=#808080]([/COLOR][COLOR=#ff00ff]SUM[/COLOR][COLOR=#808080]([/COLOR][COLOR=#0000ff]DISTINCT[/COLOR][COLOR=#ff00ff]DATEDIFF[/COLOR][COLOR=#808080]([/COLOR][COLOR=#000000]mi[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000] dbo[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_HISTORY[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_BEGIN_TIME[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000] dbo[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_HISTORY[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_END_TIME[/COLOR][COLOR=#808080]))[/COLOR][COLOR=#808080]+ [/COLOR][COLOR=#ff00ff]sum[/COLOR][COLOR=#808080]([/COLOR][COLOR=#0000ff]distinct[/COLOR] [COLOR=#ff00ff]datediff[/COLOR][COLOR=#808080]([/COLOR]mi[COLOR=#808080],[/COLOR] dbo[COLOR=#808080].[/COLOR]work_history[COLOR=#808080].[/COLOR]work_begin_date[COLOR=#808080],[/COLOR] dbo[COLOR=#808080].[/COLOR]work_history[COLOR=#808080].[/COLOR]work_end_date[COLOR=#808080])))[/COLOR] [COLOR=#808080],[/COLOR] and with that is not working to [COLOR=#ff00ff]SUM[/COLOR][COLOR=#808080]([/COLOR][COLOR=#0000ff]DISTINCT[/COLOR][COLOR=#ff00ff]DATEDIFF[/COLOR][COLOR=#808080]([/COLOR][COLOR=#000000]mi[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000] dbo[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_HISTORY[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_BEGIN_TIME[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000] dbo[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_HISTORY[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_END_TIME[/COLOR][COLOR=#808080]))[/COLOR][COLOR=#000000] as A ,[/COLOR][COLOR=#808080] [/COLOR][COLOR=#ff00ff]sum[/COLOR][COLOR=#808080]([/COLOR][COLOR=#0000ff]distinct[/COLOR] [COLOR=#ff00ff]datediff[/COLOR][COLOR=#808080]([/COLOR]mi[COLOR=#808080],[/COLOR] dbo[COLOR=#808080].[/COLOR]work_history[COLOR=#808080].[/COLOR]work_begin_date[COLOR=#808080],[/COLOR] dbo[COLOR=#808080].[/COLOR]work_history[COLOR=#808080].[/COLOR]work_end_date[COLOR=#808080])) as B[/COLOR][COLOR=#808080],[/COLOR] sum(A+B) as Result can someone …
hi...is there anybody who has the right software for converting MSSQL to MYSQL?maybe u can share with me? please help coz im still very new to these fields.
Hi Gurus, I have little bit idea to Create a DTS Package to copy any 5 tables from Pubs to Northwind. but how can i do the following ..? Create a log table to store the package start time, end time, execution duration, records affected. When any transaction inserts/updates/deletes any …
How can i connect Sql server 2000 through c++
I am trying to Edit a Sql Row with the values of my textboxes. This is what I have. Can someone point me in the right direction? conn.Open(); SqlCommand command = [COLOR=#0000ff]new[/COLOR] SqlCommand(sqlString,conn); SqlDataReader myDataReader = command.ExecuteReader(); [COLOR=#0000ff]if[/COLOR](myDataReader.HasRows) { [COLOR=#0000ff]while[/COLOR] (myDataReader.Read()) { MarketName.Text=myDataReader["FileName"].ToString(); [COLOR=#008000]//HopName.Text=myDataReader["HopName"].ToString(); [/COLOR]SiteA.Text=myDataReader["SiteAName"].ToString(); SiteB.Text=myDataReader["SiteBName"].ToString(); ASRA.Text=myDataReader["ASRa"].ToString(); ASRB.Text=myDataReader["ASRb"].ToString(); GElevationA.Text=myDataReader["GroundElevA"].ToString(); GElevationB.Text=myDataReader["GroundElevB"].ToString(); …
Hi all, I am having a wee bit trouble with with the SQL Command Builder. It does not build anything but frustration. From all the books I have read and everything this is how you go about updating changes from dataset or datatable without writing your own updating logic. Build …
hi, how can i find out that what number of record(row) my cursor focused on in database? thanks label1.text= active row`s number ????? example : [code] [COLOR=#0000ff]Dim[/COLOR][COLOR=#000000] baglanti [/COLOR][COLOR=#0000ff]As[/COLOR][COLOR=#0000ff]New[/COLOR][COLOR=#000000] SqlClient.SqlConnection()[/COLOR] [COLOR=#0000ff]Dim[/COLOR] command [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]New[/COLOR] SqlClient.SqlCommand() [COLOR=#0000ff]Dim[/COLOR] kisiler [COLOR=#0000ff]As[/COLOR] SqlClient.SqlDataReader baglanti.ConnectionString = [COLOR=#800000]"data source=instance2000;"[/COLOR] & [COLOR=#800000]"initial catalog=dbf;"[/COLOR] & [COLOR=#800000]"integrated security= SSPI" …
hello I am new to sql and database design. I am looking for to learn diffrent ways of designing them and making them efficent. any tips or hints will be appreciated. Thank You All.
Hi... How can i export one or more SQL tables to MS Access from VB .NET?
Hi friends, As title refers, my problem is related with connection to the sql server. I use MSSQL Express 2005. My program, that is written in php, tries to connect to the server but the connection is failure.I didn't create an account from login under root and my connection type …
hi I am Abhishek Ranjan.I have just joined this group.Currently i am working in a project which uses PHP and SQL Server.It uses Smarty template as presentation Layer. i hope my association with this group will bring good fortune for me and others.i am open for any suggestion and i …
How can I connect to SQL Server database using VB.I have received some errors during connection.Plz give me a replay as soon as possible
Latley we're having some strange behavior in some large databases. Sometimes the queries just takes a long time to run. They've run fine earlier. Is there a limit in rows/data that one should stribe to not exceed? It's on a fast machine with almost 12Gb free space. One table e.g …
I have 2 MS SQL Servers running on 2 machines that are identical. I am working with 2 databases - one from each machine. The structures of these databases are also identical however, the number of records are different.. SQL Server A has over 1.5 million records through which I …
I am trying to display a database into textboxes without using Datagrids. How do you give a value to a text box that corresponds with a Sql row. Thanks.
[code] sql = "SELECT * FROM tblcsvdump" set rs = connection.execute(sql) records = rs.Fields.Count dim heading(100) dim pulled(100) dim i dim count dim VAL dim VEL i=0 count = 0 for i=0 to records heading(count) = rs.Fields(count) response.write(heading(count)) header = heading(count) '**** THIS ROW HAS ERROR pulled(count) = Request.Form(header) count=count+1 …
hi... i create a new table with this code Dim SQLCreate As New SqlCommand Dim Conn As New SqlConnection Dim DA As New SqlDataAdapter Dim DS As New Data.DataSet 'Create DB SQLCreate.CommandText = "CREATE TABLE test (ID integer NOT NULL)" SQLCreate.Connection = Conn Conn.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\RBD.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" …
Hi! I'm currently auditing a MSSQL database in my company. Is anybody know how to ensure that a particular MSSQL database did not use 'Alias'? Thanks!
hi i want to insert the current date and time in the sql server database... but i dont know how or what is the formulla exactly..i tried several time but all failed... basicly what i want is when someone log in the site with the membership the session("Date") will be …
hi everyone! Nell here ...im actually quite new to the IT world :) so ... well, i just hope that anybody out there that can advice me on converting the mssql to mysql...maybe u got some useful software for this that u can share with me? :) thanx!!
I'm not sure if this is a Server 2003 issue or an MSSQL issue, so pardon the cross-post. I have created a local user called "sql-daemon" to run MSSQL 2005. At the onset, everything works fine: I can reboot the server and all SQL processes start as expected. Then, one …
How to debug a stored procedure in c#.NET IDE
Hi! What I am trying to do is to send and recive messages throuh users. The sending part works oks, but I am having troubles reciving em. I want a label to display "Hi, you Have X new messages". The way I have to know that it is a new …
hi all i write this code Protected Sub btnCreate_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnCreate.Click Dim SQLCreate As New SqlCommand Dim Conn As New SqlConnection Dim DA As New SqlDataAdapter Dim DS As New Data.DataSet 'Create DB SQLCreate.CommandText = "CREATE TABLE test " SQLCreate.Connection = Conn Conn.ConnectionString …
Hello, I installed PHP 5 on my Server 2003 machine with IIS and got that working properly. I want to connect to my school's MS-SQL student database, but PHP balks when it hits "mssql_connect" (or whatever the statement is). How can I set this up so I can actually connect …
I'd like to know if I have to change security settings or something on my SQL Server in order to applications like ASP or VB to return a recordset. When my applications in VB or ASP return a recordset from a VIEW, I have not problems at all, but when …
Hi, to all I know this was ask before, but in the Post you say search in Google, I did and I didn't found what I'm looking for. How to connect to SQL Server from C++ code? I found the tutorial: [URL="http://www.codeproject.com/database/sqlconnect.asp"]http://www.codeproject.com/database/sqlconnect.asp[/URL], and is working and is very good, but …
Hi, I 'm new to using Hijackthis and I believe I have something wrong with my server. I'm getting a DCOM error logging in the system log and it points to Quicksilver class entry in the registry, is it bad? Any help would be greatly appreciated. Logfile of HijackThis v1.99.1 …
[COLOR=#0000ff]well thanks expert team it solve some of my prob but tell me how can i pick up reports on sql query basis bcz it works in sql but doesnt shows any result there would be a single command plz tell me that or if just ignore the sql query …
how to generate monthly basis reports and there sum plz give me complete code i know SQL query but how to use it in vb.net plz give complete refrence with code.....thanks
Hi, I have a general question about MS SQL SERVER. We had sql 2005 express and got to the limit of 4GB. We then installed MS SQL SERVER 2000 and obviously have now a problem with transfering the database from 2005 express to 2000. Any advice? Thanks.
Upon startup I get a message saying "bridge.dll cannot be found" I know it is spyware, but im not sure on how to fix it. Here is my Hijack this log: Logfile of HijackThis v1.99.1 Scan saved at 3:32:55 PM, on 6/6/2006 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet …
Good afternoon all, does anyone know how to connect to a SQL database, using Javascript? I only know how to do it in VBScript, and not Javascript, can anyone help, thanks... Have a nice day...
How to transfer data from Ms access to Ms sql plz guide me
The End.