Topics
Started by
Posts
Last post
I'm trying to use a trigger to update the record that has been created with addtional details, howe…
3 replies
Hi, Is there any easy way of determining nested triggers?! For example, if I update a table that ha…
1 replies
Hi friends, create tab T1(name varchar(22),age numeric(22)) create tab T2(name varchar(22),ag…
6 replies
hi im migratting an MS Access database to SQL Server 2008, and I have a trouble trying to convert t…
1 replies
Hi, I have a table on which the primary key is defined as composite of two keys. Now i want to add …
5 replies
Hi, Is there a way of getting the inserted and deleted "virtual tables" using the output on the sam…
3 replies
Hi! I am trying to select records between July 1st 2011 and August 14, 2011. I am not returning any…
6 replies
Hello I have build this cursor that work correctly, but i need to changing then to out an IF condit…
10 replies
I need to implement trigger on INSERTION and insert the same record to another table but a column v…
5 replies
I want to eliminate ('withdrawn','Discontinued','Matured','Withdrawn from Public') from the resulta…
4 replies
Hello, I have already a trigger that sends us a mail when a new database is created (some of our us…
4 replies
Hi SSC, I have a table containing prices for certain stock prices, and dates upon which their share…
4 replies
I have a query I'm trying to write where we have a scheduled event that occurs x number of days. We…
10 replies
CREATE TABLE #temp ( ID INT, FirstName NVARCHAR(100), ) INSERT INTO #temp SELECT '1','A' UNION ALL …
5 replies
Hi I'm looking at using Merge which I've never used. I've achieved Auditing before with an After tr…
13 replies
Viewing 15 topics - 4,996 through 5,010 (of 10,647 total)
You must be logged in to create new topics.