Database Discussion Boards

Re: How to get a better way to retrieve data from database?

sam#17-Jun-07 21:53

17-Jun-07 21:53

again n again firing query for retrieval increases too much communication cost so it's not a good idea for retrieving data.

Suggestion 1:
create a stored procedure do all your work there and return the final result

Suggestion 2:
make a dynamic query or condition for your query and fire at once

Hope it'll help in improving performance of your data retrieving procedure

SQL server 2005 Enterprise Edition Doubt...

Sathyaa1516-Jun-07 23:18

Sathyaa15

16-Jun-07 23:18

Hai,

I have SQL Server 2005 Enterprise Edition in the DVD.I have Windows XP SP2 operating system in my PC.But i am unable to install the SQL Server 2005 Enterprise Edition in my PC.Why?.Please anybody give the solution for this.

And also what edition is suitable for the Windows XP Sp2 System.

Regards,
Gnanavel N

Re: SQL server 2005 Enterprise Edition Doubt...

sam#17-Jun-07 21:45

sam#

17-Jun-07 21:45

it also requires 3.1 or 3.2 installer might be missing in your OS

Re: SQL server 2005 Enterprise Edition Doubt...

Colin Angus Mackay17-Jun-07 21:48

Colin Angus Mackay

17-Jun-07 21:48

For SQL Server Enterprise you need a Server class OS.

Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

Re: SQL server 2005 Enterprise Edition Doubt...

Colin Angus Mackay17-Jun-07 21:47

Colin Angus Mackay

17-Jun-07 21:47

Sathyaa15 wrote:
But i am unable to install the SQL Server 2005 Enterprise Edition in my PC.Why?.Please anybody give the solution for this.

The solution is to install it on a Server edition of Windows.

SQL Server Enterprise (and Standard) is not designed to run on desktop editions of Windows (Home and Professional).

If you want to run SQL Server on Windows XP then use SQL Server 2005 Express Edition.

Re: SQL server 2005 Enterprise Edition Doubt...

sam#17-Jun-07 21:56

sam#

17-Jun-07 21:56

Colin Angus Mackay wrote:
The solution is to install it on a Server edition of Windows.

dear i think your are mistaken it's running perfactly at my desktop with WinXp Sp2

Re: SQL server 2005 Enterprise Edition Doubt...

Colin Angus Mackay17-Jun-07 22:40

Colin Angus Mackay

17-Jun-07 22:40

sam# wrote:
dear

First, this freaks me out. Sorry, I have to say that. I'm not your wife so I'd prefer you didn't address me like that.

sam# wrote:
i think your are mistaken it's running perfactly at my desktop with WinXp Sp2

Enterprise Edition is not designed to run on Windows XP. If you have somehow managed to install it on Windows XP then you are breaking the license agreement.

Re: SQL server 2005 Enterprise Edition Doubt...

Pete O'Hanlon17-Jun-07 23:43

Pete O'Hanlon

17-Jun-07 23:43

I rather suspect that you've installed the Developer edition. Enterprise edition checks to see if the system is a server or not - if you're not running a server OS then it will fail to install. The only way to get round this is through registry hacks which would invalidate your XP licence.

Deja View - the feeling that you've seen this post before.

Re: SQL server 2005 Enterprise Edition Doubt...

Mike Dimmick18-Jun-07 2:34

Mike Dimmick

18-Jun-07 2:34

There is also a Workgroup Edition which does run on Windows XP.

Stability. What an interesting concept. -- Chris Maunder

Re: SQL server 2005 Enterprise Edition Doubt...

Colin Angus Mackay18-Jun-07 8:47

Colin Angus Mackay

18-Jun-07 8:47

So there is. I forgot about that one.

FULL TEXT SEACRH SQL SERVER 2000

Durahman Hamdan16-Jun-07 17:54

Durahman Hamdan

16-Jun-07 17:54

How to pass a parameter that separated by a blank characther eg "JOHN SMITH" to a Stored Procedure to be used for a full text search.

Thank you

Re: FULL TEXT SEACRH SQL SERVER 2000

Member 387988117-Jun-07 20:41

Member 3879881

17-Jun-07 20:41

Use this function in ur back end code....,
Function singletodouble(ByVal str As String) As String
Dim i As Integer
Dim strdouble As String
strdouble = " "
For i = 1 To Len(str)
If Mid(str, i, 1) = "'" Then
strdouble = strdouble & Mid(str, i, 1) & "'"
Else
strdouble = strdouble & Mid(str, i, 1)
End If
Next
singletodouble = Trim(strdouble)
End Function

After that pass the value to ur stored procedure like:
'" & singletodouble(txtdesc.Text) & "'[for example the string in textbox it will be pass this way]...,
I think this will help u...,

Regards,

Magi

group by clause.

Vipin.d15-Jun-07 23:25

Vipin.d

15-Jun-07 23:25

HI i am using MSSQL 2000.

I ve some doubt in group by cluase or selecting data on a certain manner.

i ve 3 table
tbl1 contain fileds Refno(p),catId,remitId,Amt
egs: r1 c1 rm1 1000
r2 c2 rm2 300
r3 c1 rm2 2000
r4 c3 rm3 50
r5 c2 rm3 4000
r6 c1 rm2 500

tbl2 catId(p), catname

eg : c1 cat1
c2 cat2
c3 cat3
c4 cat4

tabl3 remitID(p),remitname
eg: rm1 remit1
rm2 remit2
rm3 remit3
i want to display data like
r1 cat1 remit1 1000
r3 cat1 remit2 2000
r6 cat1

like

i want group tthe data based on category id

how i do this?

is it

SELECT Refno,catname,remitname,Amt from
tbl1,tbl2,tbl3 where
tbl1.catId=tbl2.catId and tbl1.remitId=tbl3.remitId

GRoup by ??????

thanks in advance

All I ever wanted is what others have....
CrazySanker

Re: group by clause.

Arun.Immanuel16-Jun-07 1:07

Arun.Immanuel

16-Jun-07 1:07

I think you need to sort them like

<br />
SELECT Refno,catname,remitname,Amt from<br />
tbl1,tbl2,tbl3 where<br />
tbl1.catId=tbl2.catId and tbl1.remitId=tbl3.remitId<br />
order by catname <br />
<br />

Regards,
Arun Kumar.A

Re: group by clause.

Vipin.d16-Jun-07 20:59

Vipin.d

16-Jun-07 20:59

thank u. but when we use group by clause??

i am really confused with groupby clause and order by...
Anyway thank u

All I ever wanted is what others have....
CrazySanker

Re: group by clause.

Arun.Immanuel16-Jun-07 21:16

Arun.Immanuel

16-Jun-07 21:16

Vipin dev wrote:
when we use group by clause??

ORDER BY clause is used to sort the records based on certain fields.

GROUP BY clause is used to find SUM,AVG,MAX,etc.,
for each group of a field.

For more information Click Here[^]

Regards,
Arun Kumar.A

coping tables os Sql srver to folder

razanabanu15-Jun-07 22:58

razanabanu

15-Jun-07 22:58

Hi All,I would like to copy my database to my folder..how can I open that database.how can I do that?help me,please..

Hi,Im Razana

opening a db on network path?[sql servr 05]

giddy_guitarist15-Jun-07 22:37

giddy_guitarist

15-Jun-07 22:37

hi ,

ok i thought it was as simple as putting the path to the db into AttahDbFileName , but it does'nt work.

I get "<path+database> is on a network path and this is not supported"

I tried messing with the surface area cfg , no change. Could someone give me a pointer as to what i have to do to add a database that is on a network??

Also , The "server" computer that does have the database has SQLSERVER 05 exp. installed. But "client" computer that tries to connect to this "server" also has SQLSERVER 05 exp. installed , so maybe its using the wrong instance of the service?

My connection string looks like this:
"Data Source=.\SQLEXPRESS;AttachDbFilename=\\Gidlaptop\data (e)\Gid\My Creations\Hotel Management Studio\HotelManager.Core\bin\Debug \DataServices\HTLDATA.mdf;Integrated Security=True;User Instance=True";

[using C under .NET 2.0]

Thanks so much!

Gideon

Re: opening a db on network path?[sql servr 05]

originSH18-Jun-07 2:51

originSH

18-Jun-07 2:51

I'ts a very bad idea to have the files running over a network.

Whilst being about Sql Server 7, this [^] article has a good summary of the pains it can cause.

If you really want to do this then heres a link to the knowledge base article:

Description of support for network database files in SQL Server[^]

Re: working with a DB over a network

giddy_guitarist18-Jun-07 9:22

giddy_guitarist

18-Jun-07 9:22

Hi,

Thank you! for the reply, but because of my ms access background i did'nt realize how i need to connect to a database that is on a locally connected computer. I did'nt want to use the DB from a UNC path , i just wanted to connect to it! Big Grin | :-D

I thought , naively Sigh | :sigh:

, i could just use attachDbFile and specify the UNC location. But it seems i had to "Attach" the database on the "server" first[^]

Then i was told to use either one of these connection strings:
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername; Password=myPassword; OR

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

(Where myDataBase is the name i used when i "Attached" the database.)

Also, i needed to allow remote connections.[^].(Dont forget to enable the sql browser service, its off by default)

I hope this helps someone else , if they had the same mis understading i had!

Gideon

Problem in recreating the table Full text catalog in sql server

AmitSumit15-Jun-07 21:45

AmitSumit

15-Jun-07 21:45

Hi,

Thanks in advance….

I have table and having Full text catalog implemented. I want to drop the Full text catalog by using script (Tsql) and then again generate the same Full text catalog on the same table.

I can drop the table Full text catalog successfully but when I execute the script to recreate the Full text catalog it through the following error.

## "File 'sysft_adm_groups_full_text_new1' cannot be reused until after the next BACKUP LOG operation."

Below are the script that I am using to recreate.

CREATE FULLTEXT CATALOG [adm_Test_full_text]
IN PATH N'C:\Program Files\Microsoft SQL Server\MSSQL.5\MSSQL\FTData'
AUTHORIZATION [dbo]

Thanks again

Amit

datepart function.....

Member 387988115-Jun-07 21:18

Member 3879881

15-Jun-07 21:18

Hi folowing my query is not considering the datepart function in where condition...,
How to make it proper plz any one hlp me...,

SELECT dbo.tblEmployeeMaster.empId,dbo.tblEmployeeMaster.empName,
dbo.tblMonthHourDetails.SDate, dbo.tblTimeCardmain.shift,
dbo.tblMonthHourDetails.AppWHours,dbo.tblMonthHourDetails.projectid
FROM dbo.tblEmployeeMaster INNER JOIN dbo.tblMonthHourDetails
ON dbo.tblEmployeeMaster.empId = dbo.tblMonthHourDetails.EmpId
INNER JOIN dbo.tblTimeCardmain
ON dbo.tblMonthHourDetails.EmpId = dbo.tblTimeCardmain.empid
AND dbo.tblMonthHourDetails.SDate = dbo.tblTimeCardmain.carddate
WHERE dbo.tblmonthhourdetails.projectid=100 And
(dbo.tblMonthHourDetails.MedicalLeave <> 0) OR
(dbo.tblMonthHourDetails.AnnualLeave <> 0)
and datepart(mm,sdate)=5 and datepart(yyyy,sdate)=2007

Advance thanks...,

Magi

Re: datepart function.....

Arun.Immanuel15-Jun-07 21:47

Arun.Immanuel

15-Jun-07 21:47

Magh_M wrote:
and datepart(mm,sdate)=5 and datepart(yyyy,sdate)=2007

It is because of And has higher precedence than Or.

Try this:

<br />
WHERE dbo.tblmonthhourdetails.projectid=100 And<br />
<big>(</big>(dbo.tblMonthHourDetails.MedicalLeave <> 0) OR<br />
(dbo.tblMonthHourDetails.AnnualLeave <> 0)<big>)</big><br />
and datepart(mm,sdate)=5 and datepart(yyyy,sdate)=2007

along with the column list and check the expression evaluates like you expect.

If you still find the same problem,
try to include the exressions
datepart(mm,sdate),datepart(yyyy,sdate)
along with the column list and check if the expressions evaluate like you expected.

Regards,
Arun Kumar.A

Re: datepart function.....

Member 387988116-Jun-07 1:20

Member 3879881

16-Jun-07 1:20

Thank u
Keep in touch

Magi

VB6

xxxxxzer15-Jun-07 12:25

xxxxxzer

15-Jun-07 12:25

Hi Can any one give the code for importing text file or excel sheet of say 10k records into sql database and then searching those 10k records with the existing database whether record exixt or not and give the status of records found in data grid.all this has to be developed from front end application in vb6.0..Please help

Thanks Sandeep

gbfbnhfgnbh

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.