|
You don't have any join to the "updated" record.
Try something like:-
CREATE TRIGGER CreateTrans ON [dbo].[Table1]
FOR UPDATE
AS
IF (COLUMNS_UPDATED() & 49)=49
BEGIN
INSERT INTO [Table2](x.ID)
SELECT x.ID FROM Table1 x INNER JOIN INSERTED ON x.Id = INSERTED.Id
END
GO
|
|
|
|
|
Give me a link from which i can able to access the all SQL commands and concepts
divya
|
|
|
|
|
this is a cool link to transact sql:
http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/
Human knowlege belongs to the world
|
|
|
|
|
|
Very Effective Link
A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."
-- Stephen Crane
|
|
|
|
|
|
Hello,
I've been lurking for a while, but this is my first post. I've tried searching the forum, but either I'm not doing the search correctly or what I want just isn't there!
I am starting a new job soon, and it has been suggested that I take an online SQL (the query language, not SQL Server) class. Do you have any recommended (and preferably cheap!) vendors? I would need a beginner level class.
Thanks!
Nancy K
|
|
|
|
|
You might want to join the Association for Computing Machinery (www.acm.org). As a member (membership is about $100 USD) you have access to an extensive online course offering (as well as a large online library of books). They have a number of courses on databases. There are a handful of SQL courses, these are all part of a larger dataase curriculum that is targeted towards SQL Server, Oracle, or DB2, but the introductory courses are query language focused. See http://pd.acm.org/[^]
You also might want to check out http://sqlzoo.net/[^]
|
|
|
|
|
And then make a sample application from a db book that relies on SQL. (Best way to learn)
A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."
-- Stephen Crane
|
|
|
|
|
I'm researching encrypting certain fields in a SQL Server 2005 database. I'm interfacing with the db through a web application of my creation. I was reading through an article about DB encryption( http://blogs.technet.com/keithcombs/archive/2005/11/24/415079.aspx[^] ), and though I was able to get an experiment up and working, there were a few things I didn't understand.
Why is it such a bad idea to give a low level user access to the decrypted data, but not the certificates and keys? The person in the article created a view as an intermediary step so that the low level user can see the decrypted data, but not let that user use the certificates or keys. Why can't they just use the key to get the data manually? It's my understanding that you would have 1 key per encrypted field. Or am I wrong about that? Does 1 key and certificate cover the whole database?
In addition, if you don't want to give the low level user access to the encryption methods, what is a good way to let them encrypt something and add it to the database? I can't seem think of a method analagous to the view method demonstrated in the article.
|
|
|
|
|
Wow I COMPLETELY worded that wrong.
First sentence of the second paragraph should read: Why is it such a bad idea to give a low level user access to the certificates and keys? Why do they only have access to the data?
|
|
|
|
|
Providing users with keys is often unnecessary and can be hidden from them. Also, access to cryptographic keys can expose the data. It is best to only give a user only as much as required to perform the specific task in an effort limit overall system liability.
A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."
-- Stephen Crane
|
|
|
|
|
Hi,
Is there any function in SQL server 2005 which takes the date/time and time zone as the parameters and returns whether the given date/time follows the daylight savings or not.
I was looking to a function in SQL Server very similar to the WIN API GetTimeZoneInformation().
So the input: date/time, time zone
Output: true/false (follows daylight savings/does not follow)
Pls let me know.
Thanks.
|
|
|
|
|
B"H
I have an application that needs to add fields to a table based on runtime values.
On the other hand the data set has 3 other tables that would greatly benifit from strong typed design time schema.
I would like to be able to save and load the data to/from XML. Hopefuly in the same file.
the problem is that when I load a file that was generated from a modified DataSet into a strongly typed data set, the additional fields are not loaded.
Thank you.
Rabbi Moshe Plotkin
SUNY New Paltz
Chabad & Dept. Computer Science
|
|
|
|
|
I am trying to install VS MSDE however when I click on setup.exe it tells me "A strong SA pasword is required for security reason. Please use SAPWD switch to supply same....."
However must articale that I read provide a command prompt option to change the SA password using osql. However when I try to run that command I recieve and error message stating that "OSQL is not a recognized internal or exteranl command...." My question are: I can not recall installing or configure SA account on my system, hence I am not sure how to access the database to update the A account. 2nd - How can I configure my PC to Osql. I have added it as a path on my PC but to no avail. Any other suggestion will be greatly appreciated.
Greg
Coding makes the world go round!!!
|
|
|
|
|
I think it is telling you that you need to run setup.exe with a command line switch and provide the password using the switch. If you haven't installed msde yet, then osql isn't installed either.
|
|
|
|
|
I have not yet install MSDE. However I try to input the new password through the setup.ini option but to no avail. I am not sure what else I can do to install MSDE.exe since it is not allowing me to do so neither through windows not command prompt.
Greg
Coding makes the world go round!!!
|
|
|
|
|
Are you sure the install has failed? MSDE gives no indication of success or failure, but would fail (with a false complaint about the sa password) on subsequent attempts to install. Have you rebooted and checked system services or the system tray to see if it is running?
|
|
|
|
|
I do see sqlserver.exe and write.exe in the process but I can not understand if this is in there why can't I OSQL?
Greg
Coding makes the world go round!!!
|
|
|
|
|
Hello,
I build a test report using SQL Server Business Intelligence
Development Studio. Every thing went well also I can preview of the
report. But when I wanted to deply it by right clicking it its throwing
a message
The first message I got was
'The project cannot be deployed because no target server is specified.
Provide a value for the TargetServerURL property in the property pages
for this project.'
To over the above problem I created a URL,
http://localhost/ReportServer in the property page .
And again I tried deploying it and second I got this message :
'A connection could not be made to the report server
http://localhost/ReportServer
Additional Information:
The attempt to connect to the report failed. Check your connection
information and that the report server is a compatible version.
(Microsoft.ReportingServices.Designer)'
This is first time I am trying to get the reports. Could some one
please help me how do proceed from here?
Thanks
-L
|
|
|
|
|
I tried this on XP PRo SQL Server 2005 Developer and this worked fine.
If you using SQL Server Express then this is not supplied with a Reporting Server Install and thus it won't upload into your local enviroments.
If you are using SQL server developer edition 2005 then you have to install the Reproting Server on your local box or a networked server.
To check if you have Reporting services installed go to http://localhost/Reports and your get up the web management tool.
Look where you want to go not where you don't want to crash.
Bikers Bible
|
|
|
|
|
I'm literally trying to clone data rows, nothing very complicated, infact, they aren't even going to be changed during this section of the project.
I've captured the rows I want to clone using a custom SQL query, but I'm not sure how to insert them back into the database with new ID's(primary key is autonumber)...
can't I just run a .update of some sort?
I've tried copying the data table from results of my query and merging into the complete table, that doesn't make any change.
I dont seem to be able to .insert anything other then independant values for each column.
I'm using VS 2005 and C#.
Thanks.
-- modified at 17:09 Monday 24th July, 2006
|
|
|
|
|
Just run an insert ignoring the autonumber primary key. It will be filled in for you.
INSERT INTO MyTable
(
Field1,
Field2,
Field3
)
SELECT
Field1,
Field2,
Field3
FROM
MyTable
WHERE
Field2 = 'MyCriteria'
|
|
|
|
|
I'm trying that, and I dont think I'm doing something right in the query.
Is field1 supposed to be the primary key?(as per default)?
I'm getting "primary key doesn't allow nulls" error, and my field1 is set to the autonum.
By autonum, I mean that SQL is set for INT for primary key, and I've got my dataset flagged to incriment 1, seed 1.
I think this is the correct way to set for autonum? I'm used to there being a default "autonum" from access for the field type...
-- modified at 18:26 Monday 24th July, 2006
|
|
|
|
|
try.....
insert into Employees
SELECT * from Employees where name = 'Joe'
Watch out for Unquie fields and indentity.
Look where you want to go not where you don't want to crash.
Bikers Bible
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
