Hi. I have a trigger that adds a row to a table whenever another table has a row added or updated. It seems that the trigger is adding two rows instead of one whenever it's fired. Anyone ever have this problem? Solutions? Thanks in advance.
2004-01-26
2 reads
Hi there,A question more on Windows rather than SQL server. Is it possible to create a user account that expires after a set number of days? I am running Windows 2000 Server.Thanks in advance...
2004-01-13
1 reads
Yes, take a look at the undocumented sp_MS_marksystemobject in your master db.
2004-01-06
- aparently I can only "reply with quotes". Normal reply does not have an accessable textbox.- can you provide the toppic's subject in the reply-notifications-email ?
2004-01-05
Spark up BOL and look for sp_create_removable in the index. This will present you with several topics on creating a db for usage on a cd-rom, dvd, etc... Vik
2003-12-23
you can also use the table datatype to return some data to the calling procedure though the suggestion above is the more straightforward way. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/ www.dkranch.net
2003-12-10
1 reads
quote: When you take the complete back up , take the backup of the log file also this will truncate the log till that time automatically.
2003-11-21
JulieW, Heres an idea, it's a bit ugly but should work - though you need 2 queries. Hopefully someone else has a suggestion because I'd like to know a nice way to do it as well. update @tablename set roletype = 'SecondLife' where id in ( select max(id) as id from @tablename where roleid in […]
2003-09-01
1 reads
Hi Billy, quote: What is the fastest and most reliable way of figuring out the average date? Convert to number, average it and back? Is it: DECLARE @tt TABLE (THE_DATE SMALLDATETIME) INSERT INTO @tt VALUES('1/1/2003'); INSERT INTO @tt VALUES('1/2/2003'); INSERT INTO @tt VALUES('1/3/2003'); INSERT INTO @tt VALUES('1/4/2003'); INSERT INTO @tt VALUES('1/5/2003'); SELECT CAST(AVG(CAST(THE_DATE AS INT)) […]
2003-08-28
2 reads
You can handle smaller amounts of data like this, but for the large amounts you are talking about see the BOL topic "Retrieving ntext, text, or image Values".
2003-08-27
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers