Viewing 15 posts - 7,006 through 7,020 (of 7,429 total)
Almost exactly the same FOR UPDATE trigger:
UPDATE tblB SET tblB.Column = inserted.Column
FROM inserted
WHERE tblB.whatiskey = inserted.whatiskey
You can also check for a specific column updating by using IF UPDATE(<column_name>)...
March 5, 2002 at 2:47 pm
Normally the easiest and fastest way in my opinion is to open the DTS package and do save as, there you can even specify another server to save to. Once...
March 5, 2002 at 1:37 pm
Open Enterprise Manager and Expand and open you database in question. Open the Tables list and right click the table with the relation ship choosing design. On the table design...
March 5, 2002 at 1:35 pm
quote:
I need to figure out a way to take a Saturday or a Sunday activity and make it look like a 'weekday'...
March 5, 2002 at 10:56 am
No there really isn't a way to directly do this. You could however keep a table of password change dates and catch people thru your apps. But if they used...
March 5, 2002 at 10:54 am
No, and I have not seen anything for a future implementation like this. You might want to suggest to Microsoft and see what happens.
"Don't roll your eyes at me. I...
March 5, 2002 at 10:46 am
I have never read anything on this and use alias quite often, expecially for long table names and data structures that don't make normal sense with their current names. It...
March 5, 2002 at 10:43 am
If this is SQL 7 I believe you have to delete from the FK table then from the main table for it to work.
If SQL 2000 there is an option...
March 5, 2002 at 10:34 am
In your FOR INSERT trigger do like this:
INSERT INTO tblB (ListOfColumns) SELECT ListOfColumns FROM inserted
The inserted table only exists to triggers to access and they contain the new information going...
March 5, 2002 at 10:31 am
The following is from MS Knowledge Base article at http://support.microsoft.com/default.aspx?scid=kb;en-us;Q195759
Run SQL Server 7.0 Setup from the original product CD. Doing so will not reinstall SQL Server or any components; however,...
March 5, 2002 at 10:29 am
Sorry which version of SQL are you using? You may need to create a new copy of the database and move all you data over then delete the old (You...
March 5, 2002 at 6:40 am
Doing that myself time is 0 but how are you determining the CPU and Duration time. Also are you sure nothing else was going on. Plus how being is your...
March 5, 2002 at 5:08 am
This is how to change the default language of the SQL Server from BOL:
How to set the default language (Enterprise Manager)
To set the default language
Expand a server group.
Right-click a...
March 5, 2002 at 4:41 am
When you are creating the DSN what screen is it failing at? Also based on another conversation a user change from TCP/IP to Multiprotocol and tried (which failed) then change...
March 5, 2002 at 4:24 am
We are inhouse Intranet apps. For us we keep the SQL Servers and Web Servers in the same domain that way we can acces thru trusted connections and not have...
March 4, 2002 at 7:28 pm
Viewing 15 posts - 7,006 through 7,020 (of 7,429 total)