|
thx for the response,
but i'm not quite sure.
if i deliver you person 2 and 3 can you give me the group the present ?
i gues i need a select where group is the same for person 2 and 3 and where group is not used by other persons or so..
hmm this might work...
Problem is that i get a bunch of persons and update common data as group,
i'll need to check if the group exists
if not i'll add the common data
else i'll update the common data of those persons.
so i didn't think about a cross table..
good thinking...
thx
just thinking now that i need to insert multiple keys in de many-to-many table when adding one record for a group, but that should not be a problem.
|
|
|
|
|
listen,
i don´t understand what you want to do. what about the groups stuff? name then to understand, maybe anyone could help you.
do you have 5 tables? persons,group1?,group2?,group3?,group4? 
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
Hi!
I am a newbee to SQL and I am trying to write a trigger. My aim is to realize a triger when a new record has been made in TABLE (A), and identical record will be written in TABLE (B) please see the example below. What intriques my mind is, would it be the last record in TABLE(A) which will be written in TABLE(B) with the definition below.
If you give me a correct example, I would really appreciate it.
Thanks.
<br />
CREATE TRIGGER Trigger2<br />
ON dbo.Customer<br />
FOR <br />
INSERT INTO Administration (AccountStatus, UserType, UserLoginId,UserPassword,PasswordReminder,PasswordReminderAnswer,IsUserLoggedIn)<br />
VALUES (False, <br />
Customer.Usertype,<br />
Customer.UserLoginId,<br />
Customer.UserPassword,<br />
Customer.PasswordReminder,<br />
Customer.PasswordReminderAnswer,<br />
False)<br />
AS<br />
<br />
<br />
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
|
In SQL, you shouldn't think of it as a last row. What you really want is to identify the row by either a sequence number or a timestamp. Try to break yourself from visualizing the data like a file.
Good luck.
|
|
|
|
|
try this;
declare @id_last int
set @id_last = (select max(id) from mytable)
if that is a report? ok, if not (meaning you edit,delete,add) better place some kind of "lock"(search this keyword) because people can trigger that procedure at the same time!!! 
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
Hi All, could you please give some tips and suggestions on how to improve performance of databases in SQL and optimize in better ways.
Be a good professional who shares programming secrets with others.
|
|
|
|
|
This is far too large a topic to answer in a forum. You are better off looking at a specialised website such as sqlservercentral.com
Bob
Ashfield Consultants Ltd
|
|
|
|
|
If you are speaking of MS-SQL sever, you should investigate using SQL profiler. Typically, you would look for long running SQL statements or high CPU, high disk IO, etc. There are many resources out there on SQL Profiler. I've used it with tremendous success. Good luck. David
|
|
|
|
|
Thanks Mr.David for your quick response. Thanks again for reminding me to use sql profiler. I will try today itself.
Be a good professional who shares programming secrets with others.
|
|
|
|
|
hi,
I am using sql server 2005 and i have to deploy my database into client side.
my database table having some very important data and
I want to restrict server administrator not to open my database or he can not make any direct changes in databse table.
Please let me know , is there any way to stop server adminstrator to make direct changes in database.
Is there any sql scripts to stop this.
thanks
Hari
|
|
|
|
|
As far as I know you cannot stop the SA account from accessing any database, thats the whole point of the sa.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
If you need to restrict windows administrators, you can disable BUILTIN/Administrators from logins. If it is something else you need, could you specify a bit more.
Mika
|
|
|
|
|
Hello people,
Is there any good link to study about LDAP server and its main usage and where it will be deployed ?
Many Thanks,
Sakthi
Nice things do nice works
|
|
|
|
|
hi all ,
i'm trying to import db from one db to other , here i'm getting only tables and views only .
in that db i'm having stored procedures also but im not getting stored procedures .
can any body explain me how to get the whole db .
Thanks ,
csn
|
|
|
|
|
Redgate[^] has excellent tools for working with databases.
|
|
|
|
|
For Procs you will have to generate script in old DB and then execute it in new db after imporying tables and views.
By the way whats exact nature of requirement that is forcing you to import DB?
Razov
If you think this answer helps you please rate it, it helps me. 
|
|
|
|
|
Hi, you have 2 choose option "copy objects and data between sql server databases" in export wizard. Then click Next, check all the options provided, then click Next, then Finish.
If this solution solves your problem, please rate this.
Be a good professional who shares programming secrets with others.
|
|
|
|
|
i want to install the sql 2000 database in other machine.
so how to create sql 2000 database setup?
|
|
|
|
|
|
Jeez, I take it you never heard of Google?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Well, first you must build a difference machine...
“If we are all in agreement on the decision - then I propose we postpone further discussion of this matter until our next meeting to give ourselves time to develop disagreement and perhaps gain some understanding of what the decision is all about.”-Alfred P. Sloan
|
|
|
|
|
Hi friends, i need to know how much space occupied by database with my data in sqlserver 2005.
to know this i did by right clicking on database and has seen it properties it showing nearly 2.4GB. But my database doesn;t contain that much data?
how can i know the exact size of my database?
G. Satish
|
|
|
|
|
sp_databases
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Hi
I have an access file which contains forms,tables,queries,..
How could I know what table or query the forms are taking data from?
I am too late but i will never give up
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
