|
I have MYSQL.I need to know how to connect to asp.net.
Or
I know how to connect sql server.
so please hell me
thanks
|
|
|
|
|
Try this link clickety[^]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi, folks!
I've got a major question. How do I set up an SQL Server on my computer if I have 2 things:
1) Installed MS SQL Server 2005
2) an Access DataBase, which I want to port into a SQL Server, so other users/developers could connect to it, log in and perform their actions.
I know, that this is a repeated question, and there have been such messages before. Therefore, any links or info will be appreciated.
Thanks
|
|
|
|
|
Don't quite follow you.
If you already have a SQL Server instance you can use, start with How to Migrate from Access to SQL Server 2000[^] (this applies to 2005 also).
If you don't have the instance or want to add another to your machine, run setup for SQL Server
Mika
|
|
|
|
|
Sorry for being confusing. I'm doing my best, but these are my first efforts in SQL Server and stuff
I have installed an SQL Server (at least I think, that I did, bc I have checked it during the Visual Studio installation process). Then, I have installed a MS SQL Management Studio Express.
You are right: I need to migrate from Access to SQL Server. But on the other hand, I can't find the interface in the Management Studio to allow me to create my own database. Maybe, that is because I use Express edition? Management Studio tells me that I'm not connected to the server, but I don;t want to connect at the first place, I need to set the server, so other people can connect to me and use my database.
|
|
|
|
|
No problem at all
If I remember correctly, you don't have the option for installing SQL Server Express in Visual Studio, only Compact edition (single-user instance).
So briefly the steps you should take:
- download SQL Server 2008 Express Edition with Management tools
- install it by running setup. This will install you a single instance
- configure the instance using Management Studio
- create a database that you will use for application
- migrate your data from Access
You can check if you have a SQL Server instance installed for example by looking at services in Control Panel. If SQL Server is installed, you will have a service called SQL Server (Instance name)
Mika
|
|
|
|
|
I've spent half of the day trying to install SQL Server 2008, but it wouldn't install. At the very end it shows me a table saying that "Database Engine Services Failed", and "Replication Failed"
|
|
|
|
|
hi,
how u loaded sql server.can u tell me the website
thanks
|
|
|
|
|
|
hi,
It's giving warning that
The current system does not meet the recommended hardware requirements for this SQL Server release. For detailed hardware and software requirements, see the readme file or SQL Server Books Online.
My Ram is 256MB.IT's need 512MB.so what should i do.
IF you have any website where i can load sql server 2002.
Thanks
|
|
|
|
|
Hello friends may I know how to activate the SQL Server Agent of SQL Server 2005?
|
|
|
|
|
|
Try a google search[^]
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Hi ...
I have a table for eg called Forms (fid int , Read bit , Add bit , Del bit )
the problem that more than one row with the same Form like that :
fid - Read - Add - Del
2 - True - True - False
2 - True - False - False
2 - True - False - True
you can see that the form takes Add True and False in second row
.. I want to select only one row but if I have Add col has two value True and False in another row then select True to be :
2 - True - True - True
I'm using Sql server 2005 ,, can I create stored procedure do that ...
really thanks ...
jooooo
|
|
|
|
|
kindman_nb wrote: .. I want to select only one row but if I have Add col has two value True and False in another row then select True to be :
2 - True - True - True
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Can you be more descriptive in your question?
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
You can create a stored procedure and handle this inside the procedure. However, your problem is in modelling. You should break the table to at least two table. Separate table for Forms and separate table for allowed operations. This way you can query what operations are allowed and those that are not allowed, are not listed.
Mika
|
|
|
|
|
Not sure what you mean, do you mean something like this?:
select fid,max(cast([read] as int)),max(cast([add] as int)),max(cast([del] as int)) from Forms group by fid
|
|
|
|
|
Thanks my friend ..
what I mean that for eg ..
I have users . every user is subscribe in group and every group has it's permission Read and Add and Del of all forms ...
user A is subscribe in Group M and N
for eg : customer form :
Group M Read true - Add True - Del False
Group N Read true - Add False - Del False
then i want to select the permission of the user a from the table of permestoin ..
you can see that the user has Add is true in group M and the same user has Add is false in group N
i want to select True if i hase true or false of the same permissoin ..
i hope if you see what mean
jooooo
|
|
|
|
|
Ah, OK, well what I posted should help.
|
|
|
|
|
Hi,
I have paradox database files which I need to migrate to SQL server database.I used the DTS and DataSources(ODBC) but I find the first selection :copy data from one or more tables disabled so I must use a sql query.But I don't know the tables names in the Paradox database files so What kind of query could I use?
I am too late but i will never give up
|
|
|
|
|
|
Hi,
I am using sql server 2005.
When I am finding difference between two date I am getting one day less
For example
select datediff(d , '2008-09-01' , '2008-09-05')
I am getting 4 days I want it to be five day as 1,2,3,4,5 that is it should start from date to todate
How can I do it
Please help
Thank you
imran khan
|
|
|
|
|
Add 1 to the result.
DateDiff gives you the interval between the two dates.
|
|
|
|
|
imranafsari wrote: select datediff(d , '2008-09-01' , '2008-09-05')
5 - 1 = 4
Seems ok to me...add 1 to get your desired result.
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|