|
Anyone have quick explanation or link to info about what these directories are all about... what are they for?
I am not having any particular problems, but I am wondering what they are for.
|
|
|
|
|
The '80' directory contains client tools and any components shared between instances of SQL Server 2000 (which is version 8.0). The '90' directory similarly contains client tools and components shared between instances of SQL Server 2005 (version 9.0).
Directories named MSSQL.n and MSSQL$name contain the program files and (by default) data files for a particular instance of SQL Server. Different instances can be at different service pack levels, which is why they've got separate copies of a lot of the program files.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
Hi all,
How to use Linked servers (sp_addlinkedserver)
thanks
|
|
|
|
|
Look at Books online. There is a full explanation there. You can also go to MSDN and search for linked servers
|
|
|
|
|
|
Hi!
I have a SP that looks like the following:
Create Procedure dbo.Name
(
@FirstName varchar(50)
)
As
Declare @FirstNameID int
Insert Into Table1
(
FirstName
)
Values
(
@FirstName
)
Select @FirstNameID = Scope_Identity()
GO
The problem I am having is this procedure also needs to check, if the FirstName already exists then the entry being made should use that ID otherwise it needs to add a new FirstName.
The ID is Auto incrimented.
If you need more detail please email me so that I can give more detail...
Thanks Guys!!!
Illegal Operation
Making Computer Software Talk
|
|
|
|
|
Something like this should get you started:
CREATE PROCEDURE dbo.Name
(
@FirstName VARCHAR(50)
)
AS
DECLARE @FirstNameID INT
SELECT
@FirstNameID = FirstNameID
FROM
Table1
WHERE
FirstName = @FirstName
IF @FirstNameID IS NULL
BEGIN
INSERT INTO Table1
(
FirstName
)
VALUES
(
@FirstName
)
SELECT @FirstNameID = Scope_Identity()
END
|
|
|
|
|
Ok that looks like it will work but how would I handle an error if the user tries to enter an existing FirstName?
Illegal Operation
Making Computer Software Talk
|
|
|
|
|
Like you would handle any other error. Some people like to use the return value. I like to throw an execption back to my app so that I don't have to manage integer to error message conversions. Pick a style that your comfortable with.
CREATE PROCEDURE dbo.Name
(
@FirstName VARCHAR(50)
)
AS
DELCARE @ErrStr VARCHAR(200)
DECLARE @FirstNameID INT
SELECT
@FirstNameID = FirstNameID
FROM
Table1
WHERE
FirstName = @FirstName
IF @FirstNameID IS NULL
BEGIN
INSERT INTO Table1
(
FirstName
)
VALUES
(
@FirstName
)
SELECT @FirstNameID = Scope_Identity()
END
ELSE
BEGIN
SET @ErrStr = 'First name already exists in database.'
RAISERROR(@ErrStr,16,1)
RETURN
END
|
|
|
|
|
I've got two tables in a master-detail relationship, does anyone know how to get the row in the master field which is tha parent to the row in the child table?
Thanks in advance Ed
|
|
|
|
|
simple thing,u can use datarelation class in the dataset object.
/*code*/
ds.relations.add("relationname",ds.tables[0].columns[id],ds.tables[1].columns[id])
/* use foreach statement to retrieve the records.......*/
use getchildrows () inside the loop.....
feel free to ask: arunjothi@gmail.com
|
|
|
|
|
There is a data relation defined in the DataSet already (created using the designer in VC# Express 2005). What I'm trying to achieve is essentially filling in some default values in the child row based on the data stored in the parent row.
At the moment I've got an event handler for the DataGridView.DefaultValuesNeeded event, this is working well so far but that's because the default values (although dynamic) are simple, e.g. one of them is the current date so I've just put it a:
e.Row.Cells["QuotationsDate"].Value = DateTime.Now;
But looking up a value from the parent table is more difficult since e.Row.DataBoundItem is not yet initialized, presumably this is called before the row is initialized.
Is the only option to modify the DataSet.Designer.cs file so that it provides the default values. This would work (I think) but I don't know what VS would do if I happened to load the designer, it'd probably overwrite the changes. Still it may be the only solution.
Any thoughts?
Ed
|
|
|
|
|
Anybody know how to script out the data in SQL 2005? i.e. I want all the data in a table to come out as INSERT statements.
Or do I have to write the code myself?
regards,
Paul Watson
Ireland
Feed Henry!
K(arl) wrote:
oh, and BTW, CHRISTIAN ISN'T A PARADOX, HE IS A TASMANIAN!
adapted from toxcct:
while (!enough)
sprintf 0 || 1
do
|
|
|
|
|
I havn't come across anything (but havn't used SQL 2005 that much) but my guess is that you will have to write the code yourself.
Ed
|
|
|
|
|
Hi guys and gals!
I am using C# (VS2003.NET) to create my PPC application and SQL CE as my database back end. I have a little app that captures information on my mobile device. How can I sync my PPC data with a SQL Server 2005 Express DB on my server?
Any help will be GREATLY appreciated.
Kind greetings
Willem Le Roux
|
|
|
|
|
SQL Server CE has built-in replication capabilities. These use IIS as a front-end, and you need to install the appropriate components for your version of SQL Server. See here[^] for information on these components. I don't know if SQL Server CE 2.0 is compatible with SQL Server 2005 Express.
The second method is to use the SqlClient namespace to connect directly to your SQL Server, and use queries against the SQL Server 2005 database to manually synchronise your SQL Server CE database. This is more effort than the first option but doesn't require any changes to SQL Server. You will also need to make your SQL Server available over whatever communications method you're using; you may not be comfortable exposing your SQL Server to the internet. I wouldn't be.
Both of these options tie you into using SQL Server on the host, which you'll have to judge for yourself whether that's a problem. The third option is to write your synchronisation mechanism yourself. You might consider using Web Services as the communication protocol.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
Hi All ADO.NET Guru,
I'm writing the following code to import Excel into DataSet.
But I get the error "Unspecified error"
Dim m_sConn1 As String<br />
m_sConn1 = "Provider=Microsoft.Jet.OLEDB.4.0;" & _<br />
"Data Source= " & fileName & ";" & _<br />
"Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""<br />
<br />
Dim objConn As New System.Data.OleDb.OleDbConnection(m_sConn1)<br />
objConn.Open()<br />
Dim objAdapter As New OleDbDataAdapter("Select * From [Sheet1$]", m_sConn1)<br />
Dim objDataset As New DataSet<br />
Dim objDataview As New DataView<br />
objAdapter.Fill(objDataset, "Sheet1")<br />
<br />
objConn.Close()
Please help me.
Thanks,
Tran Thai Nam
|
|
|
|
|
In your Select statement try using a range. For example:
<br />
Dim query as String<br />
query = "SELECT * FROM [" + sheet + "$" + range + "]"<br />
You may also have to add TableMappings
Mike Luster
CTI/IVR/Telephony SME
|
|
|
|
|
Another thing I want to mention after being burned by OLE DB and Excel. Even though you have IMEX=1 set, don't be surprised if the data fill contains some unexpected nulls. This happens because the underlying ISAM driver for Excel uses the first 8 cells of a column by default to determine the type. If you are dealing with spreadsheets from other people, chances are they are not 100% clean.
Fear not, all you need to do is edit the Registry and change a setting:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel
TypeGuessRows should be set to a value appropriate for determining the data type of your column. You can specify 0 and it will scan 16,000 rows which is probably overkill in most cases. This is an intertive process to get to the point where you have an acceptable value and clean results. Once you finish the tuning remember to add the registry setting to your setup program
Good Luck
Mike Luster
CTI/IVR/Telephony SME
|
|
|
|
|
How can i make a search multiple tables using a keyword?
those tables doesn't have similarities or doesn't have relationships.
i'm using SQL Server 2005 and in ASP.Net
or can anyone give me a sample stored proc?
thanks in advance...
|
|
|
|
|
Select * from tbalename where filedname like '%vision%'
gets all the records contains vision
U append the query based on your requirement
"Every morning I check Forbes 40 richest Indians list , if i'm not there I go to work."
|
|
|
|
|
Hi,
I have a members table, and the primary key ID is of type int, which has been setup to automatically increment the ID by 1 when a new member has been entered. I have added a lot of members while testing, but when I go live with the site then I would like to reset the auto-incrementer so that when a new member is added it starts back at 1 again. How do I do this?
I hope someone can help!!
Regards,
ma se
|
|
|
|
|
dbcc checkident('table_name'reseed,0)
|
|
|
|
|
Thanks, but where do I type this in? SQL Management studio? Where can I read more about this?
|
|
|
|
|
Open Query analizer use ur Databse and write taht line code
dbcc checkident('table_name',reseed,0) and run this query
check this also http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_5lv8.asp
--run this query
use name_of_dataabse
dbcc checkident('table_name',reseed,0)
|
|
|
|