|
Hi
Northwind database is not installed in my Database Server. I have installed this database from Microsoft's Site.
Anybody can tell me how to include this database in my SQL SERVER 2005.
Replay ASAP
Thanks
CARE CARRER
|
|
|
|
|
Have you tried attaching the database?
|
|
|
|
|
Most examples for SQL Server 2005 involve a sales table that you split based on date, i.e. sales records prior to 2000 go to this partition, and the ones after that go to another one. Nice and simple.
Say I have a sales table:
id.....Amount....Date
1......10........1/1/1999
2......9.99......1/1/2007
Now then, I put all the records prior to 2000 in it's own partition.
So when I do something like this: SELECT * FROM Sales WHERE DATE = 1/1/1999
the SQL server will know which partition to look at. Very nice.
Now then, if I do this: SELECT * FROM Sales WHERE id = 1
How will the SQL server know which partition to look at?
Thank You!
|
|
|
|
|
It will look in both partitions. However, you probably have a unique index on "id" so the cost will be minimal.
|
|
|
|
|
when more than one user connect to the database in server with application, they have very low return!
is there any settings for connection that more than one user could connect in same time without low spead?
|
|
|
|
|
What's the database ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
|
hamid_m wrote: MS Access
There's your problem. Upgrade to a real database.
|
|
|
|
|
what's your mean? your talking about sql server?
i have to do this project by ms access
|
|
|
|
|
Why? You can get free versions of SQL Server that should satisfy your needs.
If you want to get true Database Server performance, then you should really use a database that was designed from the ground up to be a database server.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
There is no way to make MS Access deliver reasonable performance in a multi-user environment. If you want performance in a multi-user scenario, use a server, not a file-system based database. There is a free version of SQL server, if cost is the issue.
|
|
|
|
|
Hi!
I have installed MS SQL Server 2005 on my Company's server (c drive) and I want to create my databases so that the Data is on another hard drive (N:\) is is possible to do that.
Thank you
phokojoe
|
|
|
|
|
You can Attach the .mdf file
|
|
|
|
|
I do not understand. I know how to attach the database. My question is, when you install ms sql server, the default directory is c:\ whatver the name of the hard drive it is. And the .mdf file is located at c:\program files\microsoft sql\mssql\data\databasename.mdf. Now I want this database to be in the other drive not the default drive. Is it possible?
phokojoe
|
|
|
|
|
" CREATE Database Mydb
ON (Name = mydbdat. FILENAME = 'N:\Mydbdir\mydb.mdf', SIZE = 5MB, MAXSIZE = 10MB FILEGROWTH = 1MB)
Log On (NAME= MydbLog, FILNAME = 'N:\Mydbdir\MyDb.ldf', SIZE =1MB, MAX SIZE = 5MB, FILEGROWTH = 1MB)"
TO move an existing database:
"sp_detach_db Mydb;
GO
--Physically move the full-text catalog to the new location.
--Attach the myDbdatabase and specify the new location
CREATE DATABASE Mydb ON
(FILENAME = 'N:\Mydbdir\MyDb.mdf'),
(FILENAME = 'N:\Mydbdir\MyDb.ldf'),
FOR ATTACH;
GO
|
|
|
|
|
Hello!
I have a table in SQL Server 2000 named ORDERS.
This table have only one record with orderdate 27/03/2007
when i run this query Select * from orders where
(Orders.OrderDate >= '26/03/2007' AND Orders.OrderDate <= '26/04/2007')
no rows are selected. But when i use: Select * from orders where
(Orders.OrderDate >= '26/03/2007' AND Orders.OrderDate <= '27/04/2007')
it returns a row with orderdate 27/03/2007.
What i have noticed that if day part of Orders.OrderDate <= '27/04/2007'
is greater than day part of '26/03/2007' it works otherwise not.
Important: Data type of ORDER DATE is nvarchar.
Anybody please guide me how to handle this if i keep datatype as NVARCHAR(10). Its a big project and for me changing its datatype is like going straight into Hell...
Thanks
colgate
|
|
|
|
|
Dates as strings....
You could CONVERT the varchar types into date types for the query.
|
|
|
|
|
AAH!
Let me try this...
Hopefuly, it should work!
colgateas900197
|
|
|
|
|
No Bro!
i have tried this(Orders.OrderDate >= (CONVERT(varchar,'26/03/2007',101)) AND Orders.OrderDate <= (CONVERT(varchar,'26/04/2007',101))) but facing same problem.
colgateas900197
|
|
|
|
|
Yes, that's cause you're converting your nvarchar fields to varchar, rather than datetime...
|
|
|
|
|
OH, oooooooo OH,OH
Thanks dear!
Its working.... OH,
Thanks.
For others it happens sometimes but for me it happens most of the times that brain dosnt work.
Thanks for your kind help
colgateas900197
|
|
|
|
|
can u send me ur proper quary.
i have tried this as below...but it does not returns any row:
Select * from tablea where
OrderDate >= (CONVERT(datetime,'26/03/2007',120)) AND OrderDate <= (CONVERT(datetime,'26/04/2007',120))
|
|
|
|
|
I have DataSet containing a table. I want to change the datatype of 2nd column of the table to varchar before binding the dataset to my datagrid.
Please help me out
|
|
|
|
|
If this is what you want to do then you should change it inside the query to the database.
CAST(Column1 AS varchar(50))
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
Also, if you only have a single table you should look at using DataTable instead of dataset. This will reduce the overhead of using datasets when you don't need the overhead of a dataset.
_____________________________________________________________________
Our developers never release
code. Rather, it tends to escape, pillaging the countryside all around.
The Enlightenment Project (paraphrased comment)
Visit Me at GISDevCafe
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
