|
Hi I am having a bit of trouble trying to display my times in 24hr format, at the moment it is displaying the times with am and pm im just wondering if anyone has any ideas of how to do this
Tim
select ID, SUBSTRING(CAST(Date as nVarChar), 13,20) as Date from Session where (SquadId = 5) and CONVERT(smalldatetime, CONVERT(varchar(8), Date, 112)) = '01/10/2006'
|
|
|
|
|
Use CONVERT[^] to convert the date into just a time. For example: CONVERT(varchar(5), Date, 108)
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
yes indeed thats exactly what i needed thanks alot man i appreciate it
|
|
|
|
|
hi all,
this is my query.
I have 3tables(a,b,c).
i am connecting table a with table b using columns
pinnumber(in a table) with Usernumber(in table b).
if this query is correct then only i have to compare
third table column (menuid)with second table column(accessid)
pls help me out of this problem.
Regards
sharmi
rs_net
|
|
|
|
|
Your description isn't very easy to understand. What are the primary keys of each table? What are their foreign key counterparts in other tables?
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
When I run the setup.exe in Windows 2000 sp4, there is a dialog which said 'Could not find the main class.Program will exit.'
Then caption of the dialog is 'Java Virtural Machine Laucher'.
Then the program exit.
I tried many computer, some of them is good , and some of them like this.
The OS is Windows 2000 sp4, database is Oracle9i, .net framework is 2.0 beta 2.
Why?
Thanks!
|
|
|
|
|
Hi,
I'm hoping someone can help me with this (hopefully very simple) problem I am experiencing as a newbie to SQL Server and ASP.NET. I have created a database in SQL Server 2000, and am attempting to show the records from one of the tables in a Visual C# program using Visual Studio.NET 2002.
I am following an online tutorial and have successfully added an SqlConnection in Visual Studio, and can see all relevant tables and columns in my Server Explorer. When I then try to add a SqlDataAdapter to my form, the wizard takes me through the configuration step by step. The final step is to build a query which I have completed successfully (a simple SELECT which I have tested previously using Query Analyser), until I click 'Next' and get the following error message:
Generated SELECT Statement.
Exception from HRESULT: 0x800700C1.
I'm sure there is something simple that I am doing wrong here, as it seems such a straightforward thing to do. Any advice would be much appreciated!
Many Thanks!
|
|
|
|
|
Hai
My system is already installed with SQL server 2000 . Is it possible for me to install SQL server 2005 BETA CTP in the same machine and run both side by side.
Regards
|
|
|
|
|
Yes, but I wouldn't recommend using the beta any more. The beta period is over why don't you use the final version?
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
Thanks for ur reply.
i installed 2005. The Server Mangaement Studio still connect to version 8.0. SQL server express instance is not running . how can i manually run the instance or please suggest any other alernative.
In 2000 we had service manager, is anything similar in 2005
Regards
|
|
|
|
|
anig1234 wrote: how can i manually run the instance
Use the SQL Server Configuation manager.
anig1234 wrote: In 2000 we had service manager, is anything similar in 2005
The SQL Server Configuration manager is similar, but much expanded as you can do a lot more than jist start and stop services.
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
Thanks For the reply.
Woruld you please tell me the steps to follow and make Server management studio use SQL server version 9.0
Is there any way to Switch between version 8.0 and 9.0 in SMS.
Regards
|
|
|
|
|
anig1234 wrote: Woruld you please tell me the steps to follow and make Server management studio use SQL server version 9.0
It is installed with SQL Server 2005 (version 9.0 as you put it) and will automatically pick up on any SQL Servers on the local machine - At least mine did - you should not have to do any additional work.
anig1234 wrote: Is there any way to Switch between version 8.0 and 9.0 in SMS.
You can have multiple SQL Servers running on a physical machine simultaneously. There is no need to "switch" between them.
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
Hallo,
Most of the utilities won't work with the beta. At least I never got them running on my server. The latest version is ok. No problem with the server management studio.
I run sql server 2000 (msde) and sql server 2005 (express) since half a year already side by side. My only problem was. I could only use osql. Everything else was not working.
Now I again installed side by side on another server using the latest express version. Everything is working with little problems.
Sincerely
Chris
|
|
|
|
|
I have a small query regarding SQL server 2000. I want to create a database whose mdf and ldf files will reside on a different computer. Now this computer is a Linux Server. My criteria is that, the mdf and ldf files will reside on a Linux server and I should be able to access those files from the SQL server installed on my system. Is this possible? If so, how do I go about doing it?
Thanks...
---
With best regards,
A Manchester United Fan
The Genius of a true fool is that he can mess up a foolproof plan!
|
|
|
|
|
Save My Soul - (SMS) wrote: My criteria is that, the mdf and ldf files will reside on a Linux server and I should be able to access those files from the SQL server installed on my system. Is this possible?
No. The files used by SQL Server must reside on the same physical machine that the SQL Server service is running on.
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
Hi, everyone. Need help here. Let's straight to question:
I have 2 tables:
tb1 -- productID, productDescription
tb2 -- productID, itemID, itemDescription......blabla
In my tb1:
productID | productDescription
-------------------------------
HAD | Hardware
TOY | Toy
CAR | Car
STA | Stationary
and in my tb 2:
productID | itemID | itemDescription ......blabla
-------------------------------------------------
HAD | mou1 | mouse1
HAD | mou2 | mouse2
HAD | mou3 | mouse3
...
..
TOY | scar1 | small car1
TOY | scar2 | small car2
...
..
.
Assume that
there got 7 items under TOY, 18 under HAD, 18 under CAR,
and ___No Item Under STA___ <--- I have problem with this. keep reading.
--------------------------------------------------------------
i'm using MSSQL,
this is the sql command i worked so far:
select tb1.productID, count (tb2.itemID) as CountedProducts
from tb1, tb2 where
tb1.productID=tb2.productID
group by tb1.productID
/*result*/
TOY 7
HAD 18
CAR 18
/********************/
but the expected result i want is suppose to be like this
STA 0
TOY 7
HAD 18
CAR 18
anyone please help. thx.
|
|
|
|
|
You have used INNER JOIN query. Please use LEFT OUTER JOIN
|
|
|
|
|
hi nguyenvhn
thx a lot of very many uncounted muchesss.
ref: article about the LEFT OUTER JOIN
http://www.devx.com/dbzone/Article/17403/0/page/4
hopefully this help those who has similar case as mine.
|
|
|
|
|
i don't know username/password that connection as SYSDBA
how can i do. please somebody let me know
thank a lot
Best Regrad
Tatee
|
|
|
|
|
If you don't know a username and password with enough rights to stop the database, let alone connect to it, your question is pointless. There is nothing that will tell you what any username or password is. You'll have to get this from the database administrators.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I'm using a smart device which run Win CE witn SQL CE 2.0. Would like to know what is the best way to export a table in the device with 50,000 records to a text file.
Should i use a SQL SELECT statement like "SELECT * FROM TABLE" into a data set and later loop the DataTable in the DataSet and export write it to a text file ?
Or select in it into a DataReader and loop the DataReader? Which one will provide a better performance ?
I try to to use method 1 (loop the DataTable in DataSet, but the proble is it take a long time to select all the record into the dataset, and it look like hang over there to the user  , because i can't update the status and show to the user.
However method 2 (loop DataReader) seen like bit better at least i was able to update the status to the user and let user know the program is running.
Please kindly advise. Thank in advance.
|
|
|
|
|
kakarato wrote: into a data set and later loop the DataTable in the DataSet and export write it to a text file ?
Or select in it into a DataReader and loop the DataReader? Which one will provide a better performance ?
If you use a DataAdapter to fill a DataSet then the entire contents are read with a DataReader (that is how a DataAdapter gets the information from the database) and the DataTable is populated with the data, you have to wait for this operation to complete before you can access even one row. Then you can write it to your file.
With a DataReader you can write the rows directly to the file as you get them. You do not have to wait for a DataTable object to be filled and you do not waste that memory either.
As you have discovered already that the user is left hanging around for a long time while the DataSet is filled, while the DataReader allows you to give feedback on progress immediately.
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
Thanks Colin.
|
|
|
|
|
Hi All,
In my project database is SQL server.
The LDF file size is increasing considerably(now it is 16 gb).
It may be due to unCommited transactions.
My question is that if I close the connection after each query execution will it commit the transaction so that the file size will be small.?
or is there any other solution to decrease the file size?
Thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
