|
SELECT TOP 2 Salary FROM TableName ORDER BY Salary DESC
|
|
|
|
|
use
SELECT TOP 2* Salary FROM TableName ORDER BY Salary DESC
Sathiya
|
|
|
|
|
Hi,
There is sqlserver 2005 installed in my machine. but i am not able to find the northwind database in the management studio . Can anybody help me to find this database. should i install any addiotional files to get northwind database.
Thanks in advance
Sebastian
|
|
|
|
|
You need to download them from microsoft's site.
Northwind is for 2000 and whilst it works on 2005 AdventureWorks is the sample designed from 2005 and is the recommended sample.
Northwind[^]
AdventureWorks[^]
|
|
|
|
|
Thank you very much .
sebastian
|
|
|
|
|
no problem 
|
|
|
|
|
Hi All,
I have two datatables, one datatable named "dtRecords1" gets filled from excel sheet, having column name "Name","Category", and on run time i have added a Identity column to "dtRecords1".
Second Column gets filled from sql server database having three columsn "ID as Identity","Name","Category".
Now i want to merge these two tables, i want this result from merge.
If there are some changes in first datatable, depending upon all columns (comparing all column values) and ID Is same,it should be overwrited, and if there are some new rows these also should be added to the resulted database.
Example:
Datatable1 from excel
ID,Name,Categoey
1,adnan,SE
2,ali,SSE
3,Imran,JSE
Datatable2 From SQL Server DB
ID,Name,Category
1,adnan,SSE
2,ali,SSE
Resulted Datatable
ID,Name,Category
1,adnan,SE -Changed ROw
2,ali,SSE -Unchanged Row
3,Imran,JSE - Newly added Row
Many THanks & Best Regards,
adnan
Many Thanks,
Adnan Rafiq
muhammadadnanrafiq@gmail.com
|
|
|
|
|
I don't think there is a merge method in the DataTable class, there is in DataSet though if all else fails.
I'm sure you could use importrow though like so:
for (int x = 0; x < datatable2.Rows.Count; x++)
{
datatable1.ImportRow(datatable2.Rows[x])
}
There are 10 types of people in the world, those who understand binary and those who dont.
|
|
|
|
|
I am 100% sure there is method merge in datatable, when i create instance of datatable, press dot, you will also see, merge method.
Will you please help to fullfill the requirment that i have asked in question or explain what you have in this loop.
Many Thanks,
adnna
Many Thanks,
Adnan Rafiq
muhammadadnanrafiq@gmail.com
|
|
|
|
|
Sorry, I didn't check.
Google datatable.merge
There are 10 types of people in the world, those who understand binary and those who dont.
|
|
|
|
|
I have search many newsgroup on the world. No one know is there are any driver availible. My ASP.Net 2 project now cannot run properly on x64 system on exporting data to Excel format.
Is it no way to use OLEDB in the future? No solution to fix my problem?
|
|
|
|
|
The Microsoft Jet database engine has not been ported to x64 and will not be in future. The 'Excel' provider was actually part of Jet.
As I recall you had to go through the ODBC driver in any case. The MSDA provider is no longer supported on x64 either, IIRC. You should really use OdbcConnection etc rather than OleDbConnection if you're using an ODBC driver.
Your only option, I think, is to use a 32-bit worker process. See here[^] for information.
|
|
|
|
|
i want to retrieve 10th or 20th like Nth maximum record in a table
Sathiya
|
|
|
|
|
I want people to do a quick search before posting ... but I guess we don't always get what we want :P
nth row[^]
|
|
|
|
|
DECLARE @nth as bigint
SET @nth = 10
SELECT * FROM TblA AS a WHERE @nth = (SELECT COUNT(ColA) FROM
TblB AS b WHERE b.ColA >= a.ColA)
This will return 10th Max.
change value of the variable @nth to get the required Max.
Regards
KP
|
|
|
|
|
i'm using MS SQL SERVER 2005 and this is my connection string to sqldb.
<add name="MSSQL"
="" providername="System.Data.SqlClient" connectionstring="server=xx.xxx.xx.xx;database=HR;uid=xxxxx;pwd=xxxxxx">
and now i need to connect to DB2 and i don't know how..
what should i use for providerName?
and do i need more information(e,g port) ??
please help~~~
|
|
|
|
|
You need a DB2 provider. IBM make one, which you can download from their website somewhere. We needed to connect to DB2 on an AS/400, for which the security setup in IBM's provider didn't work, so we're using a third-party one from DataDirect named DataDirect Connect for ADO.NET[^].
|
|
|
|
|
I have the following query and I am calling UDF defined function. But when i runuit it gives me following error message
Msg 229, Level 14, State 5, Line 1
EXECUTE permission denied on object 'TimeDifference', database 'twcsan', owner 'dbo'.
SELECT
tck.tcktreceived,
tck.ticketid,
tckmsg.tcktmessage,
dbo.TimeDifference(tck.tcktreceived, GETDATE())
FROM tbtickets AS tck
INNER JOIN tbticketsmessages AS tckmsg ON tck.ticketid = tckmsg.ticketid
seema
|
|
|
|
|
What User name you have used to login to DataBase...
If U Get Errors U Will Learn
If U Don't Get Errors U Have Learnt
|
|
|
|
|
Check for the owner database of the function you are referring!
Gautham
|
|
|
|
|
Hi all. A few days ago i installed mcafee total protection 2007 and that disabled my internet connection totally!! I couldn't fix it so i had to uninstall it. After uninstalling mcafee total protection 2007 still i couldn't join Internet!!
So i got mad and went and made repair installation of windows xp pro. After repair installation i couldn't activate it since Internet connection was still not working!! So i went and installed another copy of xp pro on different folder and named it WINDOWS (old one was WINDOWS2).Thanks god now i could join Internet but all my shortcuts and menu items are not visible.
Unfortunately I can't even start sql server 2000 either!! could any one tell me what should i do in order to get access to all database tables and data that i had in sql server and make a back up. I didn't install any new sql server yet. I be happy if an expert tell me what should i do. The installation folder of old windows(WINDOWS2) is still available along with sql server installation folder.Thank and looking forward for reply.
|
|
|
|
|
Somewhere in the Sql Server folders (normally under Program Files on your root drive unless you installed it somewhere else) there should be some files YourDatabaseName.MDF and YourDatabaseName.LDF.
You can take these files and from the enterprise manager 'Attach' them.
EDIT: Oh and if you hadn't guessed, stay away from mcafee products :P
|
|
|
|
|
Thanks for your reply. could you tell me the steps to attach them to new installation? I hate mcafee it created too many problems for me!!
|
|
|
|
|
Hi, im using application settings in a class library which implements a data tier. I then have a main application which references this class library. This is more of a query than a big problem, its just that when i access the settings via the ConfigurationManager in the data tier class i have to use the fully qualified class name:
i.e. it only works by typing the following:
ConfigurationManager.ConnectionStrings["AppDatabase.Properties.Settings.dbConnectionString"].ConnectionString;
why can i not just use:
ConfigurationManager.ConnectionStrings["dbConnectionString"].ConnectionString;
even though dbConnectionString exists in the settings file, it only works when it is fully qualified. I have seen many example using only dbConnectionString. Is it because i have multiple references to other class libaries in my main application?
Thanks,
Chris
|
|
|
|
|
I am very new to sql and databases.....
I am currently using Access and I have a database with about 1000 rows. I am trying to select 50 RANDOM rows at a time, how do you write an access sql statement for that? So far I have this....
SELECT*
FROM Computer
ORDER BY RND();
It returns all the results, but I just want to set it up so I can have it return as many as I want.
Please Help!
Steve Vondras
Red Lake Nation
MIS Tech
svondras@redlakenation.org
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
