|
Hi,
I need some help with an SQl statement please. Can someone please adapt the following statement to not only retreive the top 10 results but also return a counr of the total records in the DB.
<code>SELECT TOP 10 * FROM [tbl_Gallery] WHERE ([gal_Cat] LIKE '%' + @gal_Cat + '%') ORDER BY [gal_Id] DESC</code>
Thanks!!!
|
|
|
|
|
SELECT TOP 10 *, (SELECT COUNT(*) FROM [tbl_Gallery]) FROM [tbl_Gallery] WHERE ([gal_Cat] LIKE '%' + @gal_Cat + '%') ORDER BY [gal_Id] DESC
is this what you wnat?
|
|
|
|
|
Nearly, how do i recall the COUNT value?
|
|
|
|
|
you can assigne any name to the count
SELECT TOP 10 *, 'anything'=(SELECT COUNT(*) FROM [tbl_Gallery]) FROM [tbl_Gallery] WHERE ([gal_Cat] LIKE '%' + @gal_Cat + '%') ORDER BY [gal_Id] DESC
|
|
|
|
|
Hello
Its not like I am giving any assignment work to the genius people here.
I want some brainstorming and so asking this question.
Server – 1 (MySQL DB installed)
Client – 12 ~ 20 (practical condition, ideal condition may be more than 20) (MySQL DB installed)
Client application writes values to the server DB the local DB is updated immidiately. DB name is unique across client machines.
what are the different methods to do that.
Thanks
Regards
Anil
|
|
|
|
|
Is it necessary for each client to have a local copy of the database? Could they not just connect to the remote database?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi
I have a website which is sitting on a web server
I am trying to connect to sql server but it shows the following message:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
However I can remote desktop into sql server
Does this mean that there is another problem with the connection or do i have to configure sql server to allow remote connection from sql server
thanks!!!
|
|
|
|
|
You need to configure SQL Server so that it accepts remote connections. Try googling and you will find solution.
|
|
|
|
|
Hi
I cannot find the following location
Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
I cannot find configuration tools, is it named differntly?
thanks
|
|
|
|
|
Hi
I Managed to find it, it is in a different position to sql 2005.
However the problem is still there can you suggest anything else?
thanks
|
|
|
|
|
Make sure sql server is running
|
|
|
|
|
yes sql server is running, anymore advice that is actually useful?
|
|
|
|
|
Jamie1985 wrote: anymore advice that is actually useful?
Yeah, don't talk to people like that. What you said was pretty rude. Good luck getting help with your problem after that.
I'm going to become rich when I create a device that allows me to punch people in the face over the internet.
"If an Indian asked a programming question in the forest, would it still be urgent?" - John Simmons / outlaw programmer
|
|
|
|
|
i'm not worrying about not getting help, no one is replying anyway even before 'the comment'
|
|
|
|
|
I have had that problem before. You want to know what I did? I plugged that error message into google, and it gave me tons of results. I found the solution that applied to me, and I fixed it. Maybe you should try the same.
I'm going to become rich when I create a device that allows me to punch people in the face over the internet.
"If an Indian asked a programming question in the forest, would it still be urgent?" - John Simmons / outlaw programmer
|
|
|
|
|
Thanks for the reply
However I have spent all day looking on the net
I have configured the TCP/IP and Named Pipes so they are enabled
I ahve also tried editing the firewall on my computer
I keep getting the same error, I have only recently put the site on a web server and it worked fine before on citrix server
I cannot think of anything else hence why im posting and mad
|
|
|
|
|
Jamie1985 wrote: I keep getting the same error, I have only recently put the site on a web server and it worked fine before on citrix server
I cannot think of anything else hence why im posting and mad
I understand the frustration. Ah, you are using a citrix server huh? I haven't used citrix , but I have heard of the horrors of it. I'm guessing it's something with citrix.
I'm going to become rich when I create a device that allows me to punch people in the face over the internet.
"If an Indian asked a programming question in the forest, would it still be urgent?" - John Simmons / outlaw programmer
|
|
|
|
|
I was using citrix
Ive now moved the application over to a web server
it works fine on cirtix but not the web server
very strange
lots of people have had the saem erro as me but no definitif anaswer
|
|
|
|
|
Ah, I see. That's odd. Yeah, that's a pretty generic and common error message. I have gotten it twice. The first time was the Named Pipes thing, the other was... Well, I can't remember. I have been trying to remember but I can't. What port is your SQL Instance running under?
I'm going to become rich when I create a device that allows me to punch people in the face over the internet.
"If an Indian asked a programming question in the forest, would it still be urgent?" - John Simmons / outlaw programmer
|
|
|
|
|
1433
i donu if i need to edit something in SQL Server Browser
|
|
|
|
|
Oh yeah. I remember you said you tried messing with the firewall. But The default SQL instance is port 1434. Check and make sure, in your firewall, that you have UDP Port 1434 open. Hopefully that will help 
I'm going to become rich when I create a device that allows me to punch people in the face over the internet.
"If an Indian asked a programming question in the forest, would it still be urgent?" - John Simmons / outlaw programmer
|
|
|
|
|
hi thanks for the reply
but i think the port needs tp be 1433 as that is default, read it on a few articles online
do you know how i would make remote connections enabled and not just local?
thanks
|
|
|
|
|
Hi,
Dont know if this helps but try enabling SQL Server Browser in the Configuration settings.
I recall seeing this inn a forum somewhere.
I don't speak Idiot - please talk slowly and clearly
|
|
|
|
|
i have sql 2000 though, can i still do this? if so how? only find article on 2005
|
|
|
|
|
I'm not going to backtrack through the thread, but here's some hints:
- 1433 is the tcp/ip sql port. Try and Telnet to the port on the machine with the sql server (telnet <ip> 1433. If it connects, that's not the problem.
- Enable remote access, which depends on your network configuration. If the sql db and web server are the same machine, that's not the problem.
- If you're using Sql 2005 Express, then I think you can't connect remotely (not sure since I don't use it).
- Check your connection string, user, password, default db, etc.
- Try using SQL Manager from another machine. If you can connect and view tables, then it's a configuration problem in your connection.
- If your connection settings are in a web.config, make sure you're really picking up the config file you should be.
- Check the firewall. The port should be open (1433) but also make sure it routes to the sql server.
Usually when I run into problems, one of the above will fix it. Yours may be different. Hope this helps!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
