Database

17-Jun-04 3:53

If the common fields will have same data on all the forms, I would create one table for contact details which are nullable, and other individual data into seperate tables and enforce the constriants through application.

Bhaskara

primary keys in MS SQL

Anonymous17-Jun-04 2:11

Anonymous

17-Jun-04 2:11

Hi,

I want to know the primary keys of a given table. I s there any query or procedure which gives the primary keys of a given table in MS SQL.

Karteek

RichardGrimmer17-Jun-04 3:38

RichardGrimmer

17-Jun-04 3:38

ADODB::Connection.OpenSchema will probably have something, or ADOX

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

VenkatFor.NET17-Jun-04 4:31

17-Jun-04 4:31

Try this

select *
from syscolumns
where id = ( select id from sysobjects where name = 'Table1' )
and colid in ( select distinct keyno from sysindexkeys where id = (select id from sysobjects where name = 'Table1' ) )

Where Table1 is the table name for which you are trying to find Primary Keys

Bhaskara

VenkatFor.NET17-Jun-04 4:33

17-Jun-04 4:33

Or If you are using VB.NET or some app, you can use SQLDMO components provided by MS SQL Server and manipulate DB objects, iterate through databases and tables and find out info about DB objects

Bhaskara

Running SQL commands in a batch-file?

Grimolfr28-Jun-04 9:03

Grimolfr

28-Jun-04 9:03

You should never read data straight from the sys... tables. The next service pack you install could completely change their schema/usage.

Instead, try these two queries. Once you see the data, you should be able to figure out how to combine them to meet your needs:

<br />
SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS<br />
SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE<br />

Grim

(aka Toby)

MCDBA, MCSD, MCP+SB

Need a Second Life?[^]

SELECT * FROM user WHERE clue IS NOT NULL
GO

(0 row(s) affected)

matthias s.17-Jun-04 1:30

matthias s.

17-Jun-04 1:30

Hi there!

I'd like to create a batch file (*.bat) into which I can place osql calls that will run a couple of stored procedures (in order to create a database or populate some tables, etc.). I have a couple of probs with it:

1. I'd like to only redirect errors into a file. How can this be done? If I use the /o param the complete inputfile gets written out! And how can I suppress those >1 >2 >3... (what do they represent anyway?)

2. Is there a way to do variables in a batch file, which later can be used? It like to create for example a variable holding the username at the top of the *.bat file which I later can reuse when running osql commands.

3. Any samples, better ideas, hints?

Thanks for reading,

Matthias

If eell I ,nust draw to your atenttion to het fakt that I can splel perfrectly well - i;ts my typeying that sukcs.
(Lounge/David Wulff)

www.emvoid.de

How to create DSN at RUN time

Zeeshan Bilal17-Jun-04 0:09

Zeeshan Bilal

17-Jun-04 0:09

how to create DSN at run time of our database.

Actualy i want that when i deliver the product to user
and he execute the application ..my application
create the DSN of its database ownself..

that is user not build it by using administrative tools in control panel.

i want to do it by CODE .. that i can acces my data base.

any code ,, sample ???

thanx

RichardGrimmer17-Jun-04 3:43

RichardGrimmer

17-Jun-04 3:43

DSN is configured in the registry - simple reg key adding & writing fns work ok - look in HKEY_LOCAL_MACHINE\Software\ODBC and you should be able to figure it out

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

Zeeshan Bilal17-Jun-04 21:58

Zeeshan Bilal

17-Jun-04 21:58

I cant Get ut point ...

plz send any sample / code line etc.

i wanna make user DSN ...

thanx

RichardGrimmer17-Jun-04 22:27

RichardGrimmer

17-Jun-04 22:27

OK - to make a DSN, you need to make some keys in the registry. This can be acheived using the WIN32API function RegCreateKeyEx. (There is probably a simpler method in .NET).

If you open regedit, and navigate to HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.ini, then you will see several keys.

The simplest way to find out what you need to add, is to use the UI to create the DSN that you need, and then look at what it adds to this key. (since different sources need different information). Once you know what needs adding, you can write some code to add the keys.....

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

help needed to create table for MS Access

Anonymous19-Jun-04 1:43

Anonymous

19-Jun-04 1:43

I got it ..but cannot build code.

can u send me some code plz

plz at zahid_ash@yahoo.com

thanx

FASTian16-Jun-04 22:06

FASTian

16-Jun-04 22:06

I need to create a new table in MS Access which has an auto number field as primary key.

Thanks

Hesham Amin16-Jun-04 22:21

Hesham Amin

16-Jun-04 22:21

in database window :
Select tables
Click new
Design view -> OK
set Fieldname = (your Filed name) and datatype = AutoNumber
click primary key from toolbar.
Save table.

FASTian17-Jun-04 21:03

FASTian

17-Jun-04 21:03

well actually i needed to do this through a SQL query.

Hesham Amin17-Jun-04 22:21

Hesham Amin

17-Jun-04 22:21

FASTian wrote:
well actually i needed to do this through a SQL query.
you should tell me Smile | :)

Create table ABC(MyID COUNTER primary key )

Re: auto number generated

FASTian18-Jun-04 3:02

FASTian

18-Jun-04 3:02

sorry forgot to mention that Smile | :)

.....really appreciate your help

thanks

auto number generated

viviansm16-Jun-04 21:40

viviansm

16-Jun-04 21:40

Good day.
I am a beginner in VB.NET. I have a problem that I used (TheTable.Rows.Count + 1) to generate the no. for the customer ID. If I deleted some of the records and then add a new records, the customer ID will not correct. This is because I am using TheTable.Rows.Count + 1, what I can do to solve this problem?
How do check the last customerID in the Customer table in SQL server? can this solve my problem? I am using ADO.net.
The code i am writing is :

Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click

SqlDataAdapter1.Fill(Me.DataSet11, "Customer")
Dim TheTable As DataTable = Me.DataSet11.Tables(0)
Dim aRow As DataRow = TheTable.NewRow()
txtCustID.Text = TheTable.Rows.Count + 1
ClearForm()
txtCustName.Focus()
end sub

Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Try
Dim TheTable As DataTable = Me.DataSet11.Tables(0)
Dim aRow As DataRow = TheTable.NewRow()
aRow("CustID") = TheTable.Rows.Count + 1
aRow("CustName") = txtCustName.Text
aRow("CustAdd") = txtAdd.Text
aRow("Postcode") = txtPostcode.Text
aRow("City") = txtCity.Text

TheTable.Rows.Add(aRow)
SqlDataAdapter1.Update(Me.DataSet11, "Customer")
txtCustID.Text = aRow("CustID")
MessageBox.Show("Customer Was Successfully Added ", "VIP", MessageBoxButtons.OK, MessageBoxIcon.Information)

txtCustID.Text = TheTable.Rows.Count + 1
ClearForm()
txtCustName.Focus()

Catch ex As Exception
MessageBox.Show(ex.Message.ToString())
End Try

End Sub

If anyone know how to solve this problem, please post.
Thanks in advance!

viv

Tarakeshwar Reddy16-Jun-04 22:57

Tarakeshwar Reddy

16-Jun-04 22:57

Write a query to get Max(custId).
Select max(custID) from tblCustomer

What this will do is get the maximum value in the cust id column from the table and return it to you, just add 1 to it and show thas as your next custID.

Tarakeshwar
CCIE Q(Routing and Switching), MCSE Security

Re: auto number generated

WoutL16-Jun-04 23:09

WoutL

16-Jun-04 23:09

Wrong!!!

You cannot rely on the identity to always 'grow by one'

If you want to know the latest Identiit value of a table use:

IDENT_CURRENT('table_name')

If you want the Identity of the record you just inserted use:

SCOPE_IDENTITY( )

Wout Louwers

Re: auto number generated

VenkatFor.NET17-Jun-04 4:57