|
I know what you mean... I try to studiously change the defaults whenever I install new software, but then comes along a product written by idjits that won't let me change them. Microsoft is the single worst offender in that respect, but there are a host of others. Eventually I get lazy, and as the advice to rape victims goes, I lie back and accept the inevitable. But with each new system I try again, having just had to rebuild thousands of files because reinstalling Windows erased them. 
Will Rogers never met me.
|
|
|
|
|
 I also joined that club in the 90s.
|
|
|
|
|
As Mycroft said, it's more of a matter of opinion if this isn't a server installation. Personally I like to have the database files in an easy path so I use C:\Databases\... and a tree structure for different versions, databases etc.
If you're going to create multiple databases you can change the default location for the new databases in the Management Studio / Server Properties / Database Settings and type a path you want. However, note that the Management Studio won't create a new folder for you so you have to create it separately and assign proper privileges.
|
|
|
|
|
Anywhere but under Program files.
All Users App Data should work.
|
|
|
|
|
You cannot vote on your own post
0
i want to run windows form program in more than one PC and the database to be in one PC and other PCs connect to it
DB (sql server)
>>>>>>>>
how can i control
*in setup of sql server
*or on connection string
*and what the requirements to make this is need to windows server or sql express
________________________________
tell me the steps and requirements please 
|
|
|
|
|
Mohamed Nabawy wrote: You cannot vote on your own post
Which I believe makes sense.
Mohamed Nabawy wrote: i want to run windows form program in more than one PC and the database to be in
one PC and other PCs connect to it
DB (sql
server)
>>>>>>>>
how can i control
*in setup of
sql server
*or on connection string
*and what the requirements to make
this is need to windows server or sql express
Your question is a bit large...
Have you tried or planned of trying something? If yes and you got stuck in a specific question then posting a targeted question would likeliy give you many helpful answers. Especially if you present some effort you have already made and want some help to get it running etc.
If you're still in the early phase of learning the concepts, I suggest that you read the literature available and google for specifics.
|
|
|
|
|
See if xp_cmdshell is what you are looking for. It allows you to run a windows command from within a T-SQL stored procedure.
|
|
|
|
|
Hello Everybody,
As we find the Sum of Salary from Emp Table.
SQL Query : Select Sum(Emp) from Emp;
Now I want to get the product of Salary : Product means (first sala * Second Sal * Third Salary * ...... * Last salary);
How can i use with the help of SQL Command.
I Do't want to USE PL/SQL Command.
Thanks
If you can think then I Can.
|
|
|
|
|
assuming as you haven't given a table structure, that there is a column that has the first salary etc in.
select salary_type, sum(emp) from emp group by salary_type
if this doesn't help you, you will need to provide more information i.e. table structures etc.
As barmey as a sack of badgers
Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
|
|
|
|
|
I think u are not find the meaning of my question.
I want to Get the Multiplcation of All Employee Salary.
For Example :
Ename Sal
----- ----
Anu 10
Minu 20
Tusar 20
Piter 10
Now I want to get the Multiplication of All Salary : (10 * 20 * 20 * 10)
With the help of SQL. I Do't want to use PL/SQL Commands.
Thank
If you can think then I Can.
|
|
|
|
|
|
This Is Just for Knowing Concept to How To Multiply Fields Values.
And I Say that i do't want to use PL/SQL.
If you can think then I Can.
|
|
|
|
|
Did you try using Cursor, I think that can solve your problem.
Hope this helps.
All the best.
|
|
|
|
|
No, But How can i use cursor for this requirement...
If you can think then I Can.
|
|
|
|
|
You can use select exp(sum(ln(sal))) from emp which of course will throw an exception for negative numbers and zero.
But that you can easily fix with a case expression.
The best solution is of course to create a function to do the job.
|
|
|
|
|
Can u please explain with the form of SQL Query.
If you can think then I Can.
|
|
|
|
|
eg_Anubhava wrote: Can u please explain with the form of SQL Query.
Well I did.
I'll do it again, with extra explanation, and I'll write slowly.
You have a table EMP that has a column SAL that you want the product from instead of the sum.
Then the query can look like this:
SELECT EXP(SUM(LN(SAL)))
FROM EMP This query has the drawback that the LN() function will throw an exception for negative numbers and zero.
Tip: CASE WHEN and SIGN() will be useful.
This can be mathematically written like: A*B = eln(A)+ln(B)
|
|
|
|
|
It is generating an Error while executing this Query.
Error Message is : Undefined Function 'LN' in Expression.
If you can think then I Can.
|
|
|
|
|
ln() is supported on Oracle since version 8i. If you're using an older version than that, you're having bigger problems than the missing ln() function.
But if you by any chance aren't using Oracle despite your numerous references to PL/SQL, then both SqlServer and MSAccess uses log() instead of ln().
|
|
|
|
|
eg_Anubhava wrote: Can u please explain with the form of SQL Query.
which proves that you did not look at the link I posted above. It is shown there!
|
|
|
|
|
And obviously I didn't either. 
|
|
|
|
|
If you don't want to use any of the built in Oracle commands, then you could achieve this by using a cursor to iterate over the user's salary and keep a running total that way.
|
|
|
|
|
declare @temp table (ename varchar(10), sal int)
insert into @temp values ('Anu', 10)
insert into @temp values ('Minu', 20)
insert into @temp values ('Tusar', 20)
insert into @temp values ('Piter', 10)
select exp(sum(log(sal))) from @temp
|
|
|
|
|
It returns the wrong answer in some cases change the values and then try.
the difference of values are in some points.
If you can think then I Can.
|
|
|
|
|
Try
SELECT CAST(ROUND(COALESCE(EXP(SUM(LOG(ABS(NULLIF(sal,0))))),0)*SIGN(MIN( ABS(sal)))*(COUNT(NULLIF(SIGN(sal),1))%2*-2+1),0) AS INTEGER)
FROM @temp
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
