RE: Accessing all rows in an Update Trigger
Not really. Set based triggers are nice for performance, until you need to do something like you have here. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-06-10
career
RE: Tables with tree structure
If you are interested in traversing the hierarchy then you can do it with the sampel SP which builds the tree using @@rowcount variable. Hope this helps. If its irrelevant then accpet my applogies. Regards, Affan SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE sp_BuildHierarchy AS BEGIN -- Deletes all the data from […]
2003-06-10
RE: import excel file to sql table that has ID field
Just a shot in the dark, going back to your original question (BTW, if I have only ONE sheet in my excel workbook, named “tblExcel”, why do TWO sources appear in the “DTS Import /Export”)... Maybe you have defined a NAME in your tblExcel worksheet called tblExcel? And, maybe that NAMEd area tblExcel extends past […]
2003-06-09
1 reads
RE: SQL Server 2000/ SQLXML
lol. Good to see there are other SAFA's out there... Dis maar alteight(Spelling?) lekker... Cheers, Crispin
2003-06-09
RE: SQL Server 2000/ SQLXML
Fascinating have I fallen into a alt.sports.boer newsgroup by mistake? You'll need to do Select * from (tablename) as ROOT for XML Auto, Elements if you want <ROOT> around your output.
2003-06-09
RE: log file too big
I do not want to delete all the publications at this point. Is there another way to shrink this log?
2003-06-09
2 reads
RE: Require guidance in Building Dimensions
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-09
RE: Existing DTS lost text column definition
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-09
RE: Using 'WITH(NOLOCK) to Improve Performance.
I don't think the hint hurts you. Easy enough to test a few times with/without. Probably need to revisit the query plan, see what can be tweaked. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-06-09
1 reads
RE: SQL Server 2000/ SQLXML
Maar n engelsman maak a plan wat werk... (But an englishman make a plan that works) Cheers, Crispin
2003-06-09
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers