|
SELECT b.n, a.c, b.c AS c1
FROM a RIGHT OUTER JOIN
b ON a.n = b.n
UNION ALL
SELECT a.n, a.c, b.c AS Expr1
FROM a LEFT OUTER JOIN
b ON a.n = b.n
Venky
|
|
|
|
|
Hello
I want to fetch record in a pair of 100. First time I want Records from 1 to 100 then 101 to 200 and so on.
Is there any way to solve this problem.
Thanks
Syed Shahid Hussain
|
|
|
|
|
|
When i installed i got this error.so what should i do
The error i found:
sql server failed to start sqlserver books online:"how to view sql server 2005 setup Logfiles and starting sql server manually
|
|
|
|
|
To get back your sql 2005 help / documentation, you need to re-install the sql server client tools
Venky
|
|
|
|
|
When display MA lines, does it need to save the MA values into the database after the first calculation of these values?
I'm not sure whether the performance is a problem. If not, the software will be more agile by not saving the intermediate data.
system
|
|
|
|
|
Do you think anyone knows what you are talking about? What is MA?
Bob
Ashfield Consultants Ltd
|
|
|
|
|
MA = Moving Average
For example, I have 5 numbers as below
1 2 3 4 5
now MA2 means the average of every 2 numbers, it all like this
original: 1 2 3 4 5 6
ma2: - 1.5 2.5 3.5 4.5 5.5
MA2(n) = (ORG(n)+ORG(n-1))/2;
system
|
|
|
|
|
do you need to retreive the interim values from the database EVER. This is your answer.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi,
can i use excel "almost" like a database?
i thinks on using a sheet like table and workbook like database,validations fine (don´t need key: i don´t get many errors from there)
My problem is the sql statements, can i query it(excel data)?
i don´t know how, i think also sql statement in c# don´t work in this case.
must i use xml?
(no code needed)
thanks 
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
You can use VB6 which lets you use SQL statements. I don't think you can use XMl unless it's 2003 or above. No C#.
Blog link to be reinstated at a later date.
|
|
|
|
|
Hello,
You can use excel sheet as an Database, and you can also query it like regular Access or Sql Database.you can use oledb connection to excel file from your vb.net or c# application.
Use the connection string below,
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=XLFile.XLS; Extended Properties="Excel 8.0; HDR=No;"
|
|
|
|
|
Hi,
When i installed sql server its giving error:
sql server service failed to start
|
|
|
|
|
What Error do you get ?
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
When i installed sql server its giving error:
sql server service failed to start:sql server books online:"how to view sql 2005 setup logfiles and sql server manually
I have sql server configuration manager.How can i use this to create database and table.Please help me.
|
|
|
|
|
Hi,
I installed sql server 2008 .It installed but it has configuration not enterprise.I need to work in asp.net.so pls give me website where i can load.
Thanks
|
|
|
|
|
mkalantri wrote: it has configuration not enterprise
What does that mean? The version is not SQL Server 2005 Enterprise Edition or what?
Enterprise edition is downloadable only as a trial version. If you want to actually use it, you must buy it.
modified on Tuesday, September 9, 2008 4:56 PM
|
|
|
|
|
Hi,
i downloaded it's giving error.it's trail based.I have MySQL but i am unable to connect MYSQL with asp.net.If you have idea pls let me know how to do it.
Thanks
|
|
|
|
|
I'm sorry, but cannot help you with MySQL.
Your original post was about SQL Server 2005 (or 2008, didn't quite figure out) which is a completely different product than MySQL.
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
