|
Hi,
Try this query ....
<br />
SELECT emp_no,name<br />
FROM Employee<br />
WHERE name IN<br />
(<br />
SELECT name FROM Employee<br />
GROUP BY name Having Count(*)>1<br />
)
I hope this will help u.........
Regards,
Ritesh
|
|
|
|
|
|
Is there a way to append to a column in MySQL, or if you know how to in SQL I might be able to find the way. I am trying to use budders to write to the database slowly.
Thanks for the help!
|
|
|
|
|
I Have Made On Project in VB.Net That Converts Oracle Database to An XML File.I have Had DOne it But what i am doin that I Provide My Database Name In TextBox and Then Click CreateXML button and that database XML is created.
Now I want That Instead Of Writing Manually the Name Of My Database Should be Visible On My Windows Form.Means All The Databases With Their Particular Tables Should Be Visible on my windows Form So that i can Select any and then can create its XML.
The Project is ALready Delayed so pls Reply Fast.Thank you.
Kamran Aslam Bhatti
Engineer Kamran Aslam Bhatti
From Hyderabad-Sindh-Pakistan
|
|
|
|
|
Maybe you can read in all the tables from the database, display them in a listbox, combobox etc. When it comes time to write the XML files only write the data from those tables.
|
|
|
|
|
i load datatable into a grid, the grid is added, edited. Now i put into the grid a new row with the same key as another row. I have used Rowchanged and Columnchanged Events. But after it messaged the error as i gave, it message a error message from System.
I want to turn of it. How can i do that? Please help me!
superdragon
|
|
|
|
|
Don't cross-post. It's considered very rude.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi,
I just want to install the visual studio 2005 in my machine in home and it's working but when i install SQLserver 2005 developer edition i cant get a hold of Enterprise manager nor SQL Server managment Studio .
guys can any one just tell me what is miising or required
I have WindowsXP SP2 and i dont get any errors while installing and i've installed many times with differnt setting but neither of them will give me :start-->all programs-->Microsoft SQL Server 2005-->(only configuration tools and no SQL Server Managment Studio).
Thanks for your Help,(in adv.)
|
|
|
|
|
SQL doesn't fully support Windows XP SP2. Read the installation guide, it is clearly stated.
|
|
|
|
|
ExpertComing wrote: SQL doesn't fully support Windows XP SP2
Well Mr. I have 3 Computers with XP SP2 installed and I can Install it in my Laptop which runns on XP SP2 and also in my old P4 computer it is installed and running perfectly but with this new computer P4 3.4Ghz with Hyper Threading I cant Install it (only client and connectivity tools) So i really have no idea why is this happenning.
Thanks
|
|
|
|
|
XP Home Edition SP2 will work with SQL Server 2005 Developer Edition, only.
XP Pro SP2 will work with SQL Server 2005 Developer, Standard, Workgroup, Express, and Evaluation Editions. It will NOT work with the Enterprise Edition.
For anything further, you'll have to read the RequirementsSQL2005.htm file that comes on the installation disk.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hello all,
In our office we are using a single SQL server for database and it is installed on separate system. We are using ASP.Net as the front-end. Almost 10-15 systems are accessing the database server at a time, and very frequently we are getting "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. " Is there any problem with our ASP.Net code or else is this problem from the database end? We are closong all the Data Readers and data base connections immediately. even the we are getting this kind problem very often.
Please help me out to solve this problem
thanks in advance
Naga Raju Epuri
|
|
|
|
|
Hello,
I am just trying to get some familiartity with ASP.NET website
Administration Tool and set up few users and roles. I launched the tool
and clicked on provider configuration link and it goes to the page that
has the link "Select a single provider for all site management data "
and then I clicke on it and it takes me to the page that has
AspNetSqlProvider radio button checked. I clicked on the link, test to
test the connection but its taking long to connect and finally it
couldn't connect to the database. I am not sure what credentials its
using to connect to the database.
This is the link I just copy and pasted thinking it might give any
inside of it.
http://localhost:1472/asp.netwebadminfiles/providers/ManageConsolidat...
When I used windows authentication to connect to the Managment Studio I
had no problem connecting to it. But I am not sure if the above process
trying to connect to the SQL Express by default. If it was then it
makes it sense. Becauase I have deleted SQL Express on my machine
before installing Sql Server 2005 Developer Edition.
If thats the case how do I can connect to the SQL Server 2005 from
the tool? Do I need to setup any think on my machine to have it
connected to the SQL Server 2005?
Any input is greatly appriciated.
Thanks
-L
|
|
|
|
|
This is the error Its throwing after a while trying to connecting to the database
****************************
Internet Explorer cannot display the webpage
Most likely causes:
You are not connected to the Internet.
The website is encountering problems.
There might be a typing error in the address.
What you can try:
Check your Internet connection. Try visiting another website to make sure you are connected.
Retype the address.
Go back to the previous page.
More information
This problem can be caused by a variety of issues, including:
Internet connectivity has been lost.
The website is temporarily unavailable.
The Domain Name Server is not reachable.
The Domain Name Server does not have a listing for the website's domain.
If this is an HTTPS (secure) address, click tools, click Internet Options, click Advanced, and check to be sure the SSL and TLS protocols are enabled under the security section.
****************************
|
|
|
|
|
Hello.
I'm trying to insert a record into Oracle table via Command.Execute"Insert
Into..Values" query. The table has several DATE fields and some of them have
to have NULL value.
The problem is that when I specify NULL in my insert query, the DATE fields
are getting value of "30-DEC-99" instead of NULL. CHAR fields are getting
NULL value without any issues.
I've tried both Microsoft and Oracle providers with the same result.
Please, let me know what I'm missing or should I use different ways to
achieve what I need (stored procedures or queries w/o values NULL fields).
Thanks
Valeriy Raygorodetskyy
|
|
|
|
|
Hi all,
I'm wondering if there's a limit/recommendation in the number of records
that it can be inserted in an Access 2003 table before the performance is
affected considerably. I know that in Access 2000 the limit was around 100,000 records but I'd like to know it for Access 2003.
thanks in advance,
Marc Soleda
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
In my opinion, performance in Access is more dependent on whether or not tables are properly indexed, and whether or not the database is being used as a desktop/single-user database or in multi-user situations.
I've seen Access tables with a million rows perform very well. I've seen much smaller tables, improperly indexed, perform very poorly.
Keep in mind too - Because of Access' easy-to-use datagrid views, it is tempting to always have forms based on complete table recordsets, which can often kill performance. Again, I've seen well-designed Access applications which force the user to limit the number of records being displayed; even with million-row tables, this can perform very well.
As for a strict limit - in Access 2003, I think 2 Gigs (minus space for system tables) is the largest a table can be.
|
|
|
|
|
Hi all
Using ADO & SQL Server & VB6
Assume that some changes on different tables are made within a BeginTrans-CommitTrans pair. Like below:
Dim Con As ADODB.Connection
'...
With Con
.BeginTrans
.Execute("Insert Into table1 (field1, field2) Values (1,2)")
.Execute("Update table2 Set field1 = 3")
'...
.Execute("Delete From tableX Where fieldY = Z")
'...
.CommitTrans
End With
I'm looking for a way for getting the names of the changed tables right after the CommitTrans?
Thanks
Good Day
|
|
|
|
|
hi,
i have a datagrid which is filled from database with edit, delete options. i have used inline coding. how to write a stored procedure for filling a datagrid. can anyone help me with the code
regards,
boon
|
|
|
|
|
david boon wrote: how to write a stored procedure for filling a datagrid
A stored procedure won't exactly fill a datagrid for you. You would write a stored procedure to execute database code and optionally return a result set; if you do return data from the stored procedure, then you can use the .Fill() method of a DataAdapter object (OleDbDataAdapter, SqlDataAdapter, etc. depending on the brand of database you are working with) to populate a DataSet object. The DataSet object could then serve as the source for your DataGrid.
If your database system supports stored procedures, you can likely use the CREATE PROCEDURE statement - here's a very simple example:
CREATE PROCEDURE GetEmployees
(
@startOfLast varchar(128)
)
AS
BEGIN
SELECT EmployeeID, LastName, FirstName, Department
FROM MyEmployeesTable
WHERE LastName LIKE @startOfLast + '%'
END Specific syntax will still depend on your brand of database system.
|
|
|
|
|
How can i determine all the currently logged users of my SQL Server dabase using ADO.NET
|
|
|
|
|
I think you can query master.dbo.sysprocesses to derive who is logged in at any given moment in Sql Server. With that, you could create a class kind of like this:
using System.Data;
using System.Data.SqlClient;
public class SqlServerUsers
{
private static SqlConnection GetConnection()
{
string sCon = "Server=(local);Database=master;Trusted_Connection=True;";
SqlConnection con = new SqlConnection(sCon);
con.Open();
return con;
}
public static DataSet GetLoggedInUsers()
{
string sql = "SELECT hostname, loginame, cmd, program_name "
+ " FROM master.dbo.sysprocesses "
+ " WHERE hostname != ''";
using (SqlConnection con = GetConnection())
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = sql;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}
}
}
|
|
|
|
|
Hello all. I need to know if that's possible.
I have a database with many tables, but other person is updating it, so there are tables that have changes: new fields, new relationships...
I have the backup with the new version and I have to update my database, but I don't want to lose the tables information. Is it possible to do that automatically? There are many tables to do it manually.
Regards,
Diego F.
|
|
|
|
|
Diego F. wrote: I have a database with many tables, but other person is updating it, so there are tables that have changes: new fields, new relationships...
I have the backup with the new version and I have to update my database, but I don't want to lose the tables information. Is it possible to do that automatically? There are many tables to do it manually.
Don't quite follow you. What are you updating? This other person should be working with you in synchronization so you both are on the same page.
PC
|
|
|
|
|
The thing is that I'm working with a large database with about 300 tables. Other person is working updating that db, adding fields and relationships to some tables. The problem is that I only have a backup with the new version and not the scripts with the changes.
So I need a way to "upgrade" my database with the new version without losing data.
I think it must be something like creating a new database restoring the backup and moving the data from the old database, but I don't know how to move that data.
Regards,
Diego F.
|
|
|
|