Actually it should import in row order if there is no clustered index. Are you expecting to "select" the data and get it back in this order? There is no guarentee of this. If this is what you want, add an identity column to your table, import into it and select by the identity column. […]
2003-04-30
1 reads
Much thanks to Chip Pearson in the microsoft.public.scripting.vbscript news group for posting the links to www.cpearson.com/zips/xlconsts.zip and www.cpearson.com/zips/xlobjects.zip The numeric translations for my variables was containted within. The correct line should read as follows: wkbnew.worksheets(1).range(rowcol).validation.add 3, 1, 1, "=$A$1:$A$4" Peace Out!
2003-04-30
2 reads
You could put a constraint on the field to limit what values are allowed. Jeremy
2003-04-30
Is there an "On Error Resume Next" command? I am creating these procedures that bomb out when they encounter an error and I need to do some clean up if they do encounter an error.
2003-04-30
Yes. I would imagine so. Just a reminder, when using @@ERROR, note that it gives the error of most recent sql statement. Hence it is better to store this @@ERROR in a variable and use the variable to check for conditions, return as output parameter etc.,
2003-04-30
That is my understanding as well. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-04-30
Hi I have solved it, problem was that I was also doing: ] -> []] but i shouldn't. btw. % -> [%] and _ -> [_] was needed to make it complete. Thank you for participating. Regards Benny Bech
2003-04-30
Greg, this is true if you have sysadmin rights for the box (which is the minimum required to execute xp_cmdshell unless addition GRANT statements are executed). However, if a user isn't a sysadmin, SQL Server will use the SQL Server Proxy Agent account, provided this is set. Of course, if the statement is executed as […]
2003-04-29
1 reads
Well, this is certainly a pickle. First, thank you to everyone for your time. Much to my embarassment it seems to be an ASP issue after all. Being that the entire framework is for business logic abstraction, there's quite a few reference tosses of the ADO Connection object bouncing around and it ultimately lands on […]
2003-04-29
Try: SELECT * FROM Product WHERE Description LIKE '%'+@Desc+'%' Example: Declare @d varchar(8000), @arg varchar(10) Select @d='ABC''DEF', @Arg='C''D' Select @d Select Case When @d like '%'+@Arg+'%' then 'Yes' Else 'No ' end
2003-04-29
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
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