all groups > sql server clients > april 2004 > threads for april 29 - 30, 2004
Filter by week: 1 2 3 4 5
Linked Servers
Posted by Christoph Schmitt at 4/30/2004 9:07:31 PM
Hi,
i have several questions, because i'm quite new to SQL-Server and Access
Projects. Till now i only worked with Access.MDB's
i created a new access project and have my database on SQL-Server. I see all
tables in my access-project and can work with them.
Now i need data from 1 excel file ... more >>
Query syntax for count comparison
Posted by Ysandre at 4/30/2004 12:51:02 PM
I have 2 tables, with 2 columns each: Seq# and Client
I need the syntax of a query to compare count(Client) by Seq#, between Table1 and Table2
Something like this (although this doesn't work)
Select Table1.Seq
from Table1 inner join Table2 on Table1.Seq# = Table2.Seq
where count (table1.Client... more >>
adding a column to a db in use
Posted by lisa at 4/30/2004 7:22:32 AM
Is it ok for me to add a column while the database is in
use? My users received a message when I added the first
column to an existing table. Is there a way to stop them
from receiving messages if I add a column?... more >>
Problem in Visual Basic
Posted by Tahir Hussain at 4/30/2004 12:41:02 AM
When I run Visual Basic Application With Back hand Is SQL SERVER DataBAse I Had Connect database with ODBC
But its very Slow What can i do... more >>
How to make query result fast
Posted by ping at 4/29/2004 11:59:01 PM
I have around 5 items in my database. It takes me about 1-
2 minutes to show up all the result. How can I make my
query result faster? I try to select everything on my
product table.... more >>
Secured application information
Posted by Bill B at 4/29/2004 6:16:06 AM
I'm having a major problem trying to figure out how to set up an online application for my visitors. I know that the security issue is something I have to look at with the server, but that's pretty much all I know. I need an online application for visitors to complete. It will consist of personal... more >>
|