Database Discussion Boards

First Prev Next

Re: How do i update a select?

Michael Potter29-Nov-06 5:51

Michael Potter

29-Nov-06 5:51

I believe your UPDATE should look something like this:

UPDATE
    tblSender 
SET
    User_Flag = 1
WHERE
    createdate = (SELECT 
                      MAX(s.createdate)
                  FROM
                      tblSender s
                  WHERE
                      s.Sender_FName = tblSender.Sender_FName AND
                      s.Sender_LName = tblSender.Sender_LName)

My 2 cents:
DISTINCT is a waste of syntax since you are using a GROUP BY Clause.
I see more and more examples on this board of tables without proper primary keys. Last/First names are lousy columns to use for an update (or a primary key).

Re: How do i update a select?

FIFI529-Nov-06 7:44

FIFI5

29-Nov-06 7:44

thanks alot, this seems to do the job. I'm gonna look it over and let u know

FIFI

Re: How do i update a select?

FIFI530-Nov-06 4:29

FIFI5

30-Nov-06 4:29

yeah man this works great. Thanks alot.

SQL Server with InfoPath

lyntonS29-Nov-06 2:56

lyntonS

29-Nov-06 2:56

Please can someone assist me with hooking-up an InfoPath Button event to a SQL Database. Button controls inserting of new data? Thanks for the rescue!

Re: SQL Server with InfoPath

Kamalonline44-Dec-06 20:30

Kamalonline4

4-Dec-06 20:30

Hello...Unfortunately infopath dosent provide inserting/Updating data from Infopath to SQl server.Only we can only retrive data from SQL Server - Infopath but not insert/update.
However we can do this by implementing webservice.

1.Create webservice that can interact with sql server(write functionality Update/Delete what ever you want)
2.Create connection to webservice in infopath(Tools>connectins)
3.Submit data to webservice from infopath.

How ever some of professional thirdparty tools available to interact with sql server,like QDABRA DBXL tool.

Regards
Kamalonline4@yahoo.com

database design

Rupa Kalluru29-Nov-06 0:28

Rupa Kalluru

29-Nov-06 0:28

Hi everbody,

Iam currently working on datbase design.
Iam stucked at:If a primary key is assigned in database,I need to know all the foreign key relation of this PK on other tables in that database.

please help out on this,

thanks in advance,
Rupa

Rupa

Re: database design

User 171649229-Nov-06 1:09

User 1716492

29-Nov-06 1:09

Seems to me you need to learn the basics.

http://www.htmlgoodies.com/primers/database/article.php/3478051[^] is a series of articles.

You should use google [^] to search for Database basics tutorials

modified 1-Aug-19 21:02pm.

Re: database design

ed^nrgc29-Nov-06 7:04

ed^nrgc

29-Nov-06 7:04

Primary keys and foreign keys are the backbone for how tables relate to each other.

Re: database design

Rupa Kalluru29-Nov-06 16:37

Rupa Kalluru

29-Nov-06 16:37

I need to know the tables which are in related with the same foreign key.
Pls do tell the table which constitutes the FK available in the database.

Means that IS there any table in the database in SQL SERVER which is having the FK's.sitting in it.

Please try to understand the query first,then reply it in more meaning manner

Surya

Re: database design

Pete O'Hanlon30-Nov-06 5:14

Pete O'Hanlon

30-Nov-06 5:14

If I understand your question properly, you want to be able to find out which tables have FKs pointing to a PK.

To do this, you need to look in the tables sysobjects and sysdepends (plus syscolumns for column names). The xtype in sysobjects lets you specify PK for primary keys. I hope that this helps.

Arthur Dent - "That would explain it. All my life I've had this strange feeling that there's something big and sinister going on in the world."
Slartibartfast - "No. That's perfectly normal paranoia. Everybody in the universe gets that."

Deja View - the feeling that you've seen this post before.

Can we get a trigger of one table on another?

lavanya_satheesh28-Nov-06 23:32

lavanya_satheesh

28-Nov-06 23:32

I have got four tables. When update happens in any of the four tables a trigger should be fired. i have written it for one table. is there any way to get this same trigger for all the other tables also? Or should i write different triggers for all the tables. I am having difficutly in enabling the trigger for other tables using the enable trigger command. dont know if that is possible. Please help.

Thanks in advance.
Lavanya Rose | [Rose]

Re: Can we get a trigger of one table on another?

Pete O'Hanlon29-Nov-06 8:45

Pete O'Hanlon

29-Nov-06 8:45

You should have different triggers for each table, mainly because each table will be structured differently, and I assume that the triggers will be different.

How i can detemine a changes that occure in my database

AmirAlilou28-Nov-06 21:55

AmirAlilou

28-Nov-06 21:55

How i can detemine a changes that occure in my database and then i deside based on it.

for example :
i have a database program that locate in one server in my local network,two or more users run it and each one use own sections in my application.when one user add,delete or update records of my database Tables how i can determine this event.because i want to show changes immidiatly to other users that syncronously running my app.

please help me.

Re: How i can detemine a changes that occure in my database

Bassam Saoud29-Nov-06 1:31

Bassam Saoud

29-Nov-06 1:31

Each user is using a different DB? if so, then replication is what your looking for.You can also look at writing Trigers..

Re: How i can detemine a changes that occure in my database

AmirAlilou29-Nov-06 4:38

AmirAlilou

29-Nov-06 4:38

I have one App in Server and Each user Login to it then based on permissions that define , can access to own sections in app.my program have one database and 40 table.
Please guide me by sample.

Sql Server procedures

raj_mas28-Nov-06 21:23

raj_mas

28-Nov-06 21:23

Can we write a procedure in MS sql server to make a connection with oracle?

Re: Sql Server procedures

Marek Grzenkowicz29-Nov-06 4:32

Marek Grzenkowicz

29-Nov-06 4:32

I'm not sure what you want to do, but it is possible that a linked server[^] is an answer to your problem.

Run SQL script at given time - MS SQL

pclouw28-Nov-06 21:06

pclouw

28-Nov-06 21:06

Hi,

I am using MS SQL 7 and would like to know if there is a way to setup MS SQL to run a script at a given time, i.e running an end of day script at midnight on some tables.

Thanks in advance,
Pieter

Re: Run SQL script at given time - MS SQL

Pete O'Hanlon29-Nov-06 8:49

Pete O'Hanlon

29-Nov-06 8:49

There is - you're in luck. What you do is to set up a job in SQL Server to do this. Here's how:

http://support.microsoft.com/kb/269074[^]

Good luck.

Date/time functions in SQL Server 2005

PrashantJ28-Nov-06 11:06

PrashantJ

28-Nov-06 11:06

Hi All,

I am looking for the functions in SQL server which would return me the mid day, last day of the month given the current date and the param. I would appreciate if you could point me to some related links. I have written some SQLs to do this but looks very ugly with lots of code.

Input will be some date and period.
Output will be the Till ending date interval1 and Till ending date interval2

If period(1) = weekly then the Till ending date = end of the current week (Sun) - I assume a week begins on Monday.
If period(2) = bi-weekly then the Till ending date = end of the following week (Sun)
If period(3) = semi-monthly & today <= 15th of the month then the Till ending date = 15th of the current month, otherwise Till ending date = end of month.
If period(4) = monthly then the Till ending date = end of month

For example:
Input
Some_date : 1-Jan-2006
Period

Output
Period Out1 Out2
1 8-Jan 15-Jan
2 15-Jan 29-Jan
3 15-Jan 31-Jan
4 31-Jan 28-Feb

Thanks for the help.

Re: Date/time functions in SQL Server 2005

Scott Holt28-Nov-06 13:25

Scott Holt

28-Nov-06 13:25

Do you have SQL Server Help? Start by looking at the help for functions GETDATE() and DATEPART(). Then follow other related links from there.

Scott

connecting to a database oracle 10g

hadad28-Nov-06 10:44

hadad

28-Nov-06 10:44

I can not connect to a database oracle 10g from the .net
I receive this error msg "ORA-12154:TNS could not resolve the connect identifier specified

Dad

Re: connecting to a database oracle 10g

Paul Conrad28-Nov-06 13:33

Paul Conrad

28-Nov-06 13:33

See my reply in the other thread. Please don't cross post Big Grin | :-D

Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon

Re: connecting to a database oracle 10g

Rupa Kalluru29-Nov-06 0:53

Rupa Kalluru

29-Nov-06 0:53

ORA-12154 TNS:could not resolve service name

Cause: The service name specified is not defined correctly in the TNSNAMES.ORA file.

Action: Make the following checks and correct the error:

Verify that a TNSNAMES.ORA file exists and is in the proper place and accessible. See the operating system specific manual for details on the required name and location.

Check to see that the service name exists in one of the TNSNAMES.ORA files and add it if necessary.

Make sure there are no syntax errors anywhere in the file. Particularly look for unmatched parentheses or stray characters. Any error in a TNSNAMES.ORA file makes it unusable. See the Oracle Net Services Administrator's Guide. If possible, regenerate the configuration files using the Oracle Network Manager.

Rupa

Re: connecting to a database oracle 10g

A k ch4-Jan-10 23:04

A k ch

4-Jan-10 23:04

User Id=SYSTEM;Password=MANAGER;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.4)(PORT=1521))(CONNECT_DATA=(SID=XE)))

Use you connection string like this.

Thanks & Regards,
Anil Chelasani

Last Visit: 31-Dec-99 18:00 Last Update: 19-May-24 4:23

Refresh

ᐊ Prev 1...1739 1740 1741 174217431744 1745 1746 1747 1748 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.