|
SQL Server databases are loaded by the SQL Server service. SQL Server Express Edition is no different - it creates an instance by default named SQLEXPRESS. With SQL Server 2005, you can specify a database file to attach in the connection string, so it isn't permanently associated with the SQL Server instance.
Microsoft have now ported SQL Server 2005 Mobile Edition back to the desktop properly and called it SQL Server Compact Edition 3.1. This is an in-process database engine like Access/Jet. Find out more here[^]. However, this does not use the same format data files as the other SQL Server editions. (It's really only branded 'SQL Server', it has nothing in common).
|
|
|
|
|
Hi,
I have to extract a blob field from a sql database.
please help.
Thanks
|
|
|
|
|
|
When I run my program,I get these errors and I don't know how to solve it:
1.A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
2.Cannot open database "NORTHWND.MDF" requested by the login. The login failed.
dataAdapter.Fill(dataset,"Customers"); This is where the exception is thrown
I use windows authentication and the owner of database is current user.
Can anyone please help?
|
|
|
|
|
Try enabling "Named Pipes" and restart SQL.
Regards,
Hulicat
|
|
|
|
|
I tried it but it didn't help.
|
|
|
|
|
For clarity you:
Opened the SQL Server Configuration Manager, expanded the Network configuration and enabled the Shared Memory and Named Pipes?
check if VIA is disabled.
The same needs to be done in Client configuration in client protocol section.
Regards,
Hulicat
|
|
|
|
|
Hi,
try to connect to SQL Authentification.
Can you show the connection string which you use to connect to sql server?
|
|
|
|
|
Hi,
When i set a primary key to a column in a table by default it would create a clustered index for that column.
The question is: Can i set primary key for the column with no index being created.
If yes how can this be achieved?
Gautham
|
|
|
|
|
Please read first what is indexing and
what is primary key
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
What do you want to know abt that?
I know what is a primary key and what does an index do in general
Gautham
|
|
|
|
|
gauthee wrote: Can i set primary key for the column with no index being created.
Then what is the meaning of this line?
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
That is a question iam asking!
Is it possible or not?
There are two questions infact:
1) Can a primary key be set for a column with index being set?
2) Can a primary key be set for a column with a non clustered index?
Hope you understood???
Gautham
|
|
|
|
|
Still you are not understanding what i am trying to tell.
No arguments please.
Kool.... think....ba ...bye
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
No, you can't. SQL Server uses the index to determine whether the key already exists. If it didn't have an index it would have to do a (slow) table scan, i.e. read all the records in the database.
You can create the primary key index non-clustered if you prefer.
|
|
|
|
|
Mike,
Thanks for the reply!
We cannot create primary key without indexes being added to the column now that is answered.
You said a non-clustered index with a primary key, how can it be done?
Gautham
|
|
|
|
|
Primary key with non clustered index ....
ALTER TABLE TableA ADD CONSTRAINT
PK_TableA PRIMARY KEY NONCLUSTERED (ColA)
Primary key with clustered index ....
ALTER TABLE TableA ADD CONSTRAINT
PK_TableA PRIMARY KEY CLUSTERED (ColA)
Regards
KP
|
|
|
|
|
I planned to have insert, update, delete actions in the same procedure by passing a flag. If i have the things like this will it lead to any performance or debug issues
Best Regards,
M. J. Jaya Chitra
|
|
|
|
|
I think No.
The name is Sandeep
|
|
|
|
|
I have one table in which the name field is a mandataory field and i can't keep this as null so that While deleting also i have to pass the value unnecessarily.
I got one more clarification, if i have assigning a default value then can i omit the value while passing it from the front end.
Best Regards,
M. J. Jaya Chitra
|
|
|
|
|
M. J. Jaya Chitra wrote: if i have assigning a default value then can i omit the value while passing it from the front end.
Yes.
Regards,
Satips. ![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
Can't you just check the value of the parameter inside the Stored Proc? Just assign it a value if the Parameter is empty. Or you can even assign a default value for the Parameter inside the Proc. Anyway, if the default value is set, then there is no need of this checking.
The name is Sandeep
|
|
|
|
|
Hi,
I'm 6 months new to C#, ADO coding and VS05 (Express still at this point).
My original DB was in MySql but due to the limitations of connection models in Express, I moved it to Access 2000 structure, to get a feel for the ADO and graphical concepts in VS05. So far it hasn't gone too badly, aside that the Access DB is behaving as "read only", if I try to reach it from OpenOffice and migration from MySql blew my PK/FK's and auto-numbers out the window. I was able to re-establish relations in VS no problem, however getting auto-num back for updates I'm still chasing.
I have succeeded in building the DataSet from Access in VS and was able to create the DataSet.xsd, establish relationships, build some integrated grids and see the simple linking relationships at work.
Questions:
The point I'm at now, is learning how to manage the ADO data, (assuming ADO can now copy the Database local to the program as needed?) and figuring out how to make combined table-source queries, parameter queries and perhaps something like views to work in the forms I'm using.
(1) The first problem I saw was that with a zipcode file of 47,000 text entries, opening large forms with the full dataset of contact details takes forever. I have a serial PK in the zipcode file which is indexed, but I'm wondering if and how I would add an index to the actual ascii zip code column in VS, or would I be better off compressing the ascii to binary and just use the PK index alone?
(2) Then, it seems like I should limit zip code lookups to data entry activities only and make a temporary scratch table of the actual referenced and used zip codes that have been pulled up into the user's working set. That seems to me to blow the 3N theory a little but then again it's a temporary table used to keep the performance working right? Is this an acceptable approach and how would I do that in VS, to "Derive" a temporary working subset list from the master set?
(3) Last, assuming I can create a crisp working set with a temporary, qualified, ZipCode scratch table, how does one go about creating parameterized queries in VS' visual designer of the dataset, so I can make combined-reference queries? For example I might want to join 3 related tables into one to use as my main indexing source in a primary/secondary form and then have the secondary appear as a grid from that first combined query. How do I create that master join set? Do I simply add query to the xsd graphic canvas and query builder the joins? If I "add query" to the regular data set tables to do this, it tells me my query does not match the original and refuses.
Well that's three roughly related questions to not muddy the thread so perhaps I can answer some specific replies that will help narrow down the approach, if some others would be willing to point me in the right direction.
Thanks in advance,
Nosliw
|
|
|
|
|
Below is a select statement that will be a stored procedure at some point.
I will only be passing @startdate and @enddate as user defined.
For the purpose of testing I set them to dates
Note:
I am trying to get the data for @totalatstart"total opened at start" and @totalatend "total opened at end" to be specifc to "Client"
declare @startdate datetime
declare @enddate datetime
declare @totalatstart int
declare @totalatend int
DECLARE @difference int
set @startdate ='03/01/2007'
set @enddate = '06/11/2007'
Set @totalatstart =(select count(*) from job_ticket where report_date > @startdate )
Set @totalatend =(select count(*) from job_ticket where report_date < @enddate)
set @difference =(@totalatstart-@totalatend)
select count(*) as 'Opened', @totalatstart 'Total Open at Start', @totalatend 'Total Open at End', @difference 'Total Closed', location_name 'Cient',
AVG(datediff(d,report_date,getdate() )) AS [Average
days open]
from job_ticket j
inner join location l on l.location_id = j.location_id
where (report_date between @startdate and @enddate)
group by l.location_name
Current resluts look like this:
Opened | Total Open at Start | Total opened at End | Total Closed | Client | ||||||| |||| AVG
47 |||||||| 341|||||| |||||||| 48 ||||||||||||||||||| 293 ||||||||| Alexandria, VA||||| 70
59|||||||||| 341|||||||||||| 48 ||||||||||||||| ||| 293 |||||||||| Austin, ||||||||||| 63
Obviously something is wrong with my set statment or my entire approach to this
Any suggestions or help in the right direction would be greatly appreciated.
I have been reading and can not seem to figure this out.
Regards,
Regards,
Hulicat
|
|
|
|
|
Well - part of your problem is that you only identify the total at start, difference and total at end once. These have no relation to the rest of your query. I would suggest that you put the logic for the creation of these values into the main query.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
