Personally, I do prefer (and use) the 'single-update' method to increment and return the next countervalue in one go. It makes it unnecessary to wrap in explicit transactions and such. It's physically impossible for the server to return the same counter to more than one caller.update counterTable set @nextid = nextId = nextId + 1 […]
2005-04-20
I am not quite sure how the data looks like but here is a wild guess select BLOCK_ID , DENSITY , AVG_THICK , BLOCK_SIDE , (case when BLOCK_SIDE ='top' then 23 else 0 end) - (case when BLOCK_SIDE ='top' then 1 else -1 end) * (select sum(AVG_THICK) from […]
2005-04-18
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!
2005-04-14
Select StoreNo From MyTable Where DayPolled between '22-Mar-2005' and '28-Mar-2005' group by StoreNo Having Count(*) < 7Edit: Sorry I just noticed this answers only part of your question.
2005-03-31
When you execute sp_detach_db, the procedure cache is flushed for that database. This is probably due to DBCC DETACHDB() [which sp_detach_db wraps], though this command is undocumented. Edit: You can see this by watching syscacheobjects. I did so with the pubs db on a development sql server. Run a stored procedure, verify it's in the […]
2005-03-31
I found this quote at http://www.mcse.ms/archive85-2004-2-364893.htmlSteve 2004-02-06, 11:33 amUpdate on this. I have turned on journaling on the specific table I am trying to update, and updating/insert/delete works. The problem is, that our 400 people do not want journaling turned on. I have read that having the commit level set to *NONE the odbc connection doesnt […]
2005-03-29
I have another one that I'm trying to solve: Create another view that returns the name of each country and the number of orders shipped to that country. Name the number of orders column "NumOrders.” Include code that checks if the view already exists. If it does, it should be dropped and re-created. Can any one […]
2005-03-12
Hi People,really hope you can help me with this one - I'm trying to import some data from an excel (2003) spreadsheet. It's just straight text in four columns and I have specified that all columns are nvarchar(255) apart from the fourth column which is nvarchar(1000)This should be plenty for the data in the fourth column as […]
2005-02-09
We use SQL Compare but I also recommend x-SQL Object (http://www.x-sql.com/).
2004-10-22
I have to bulk insert the data from csv file into orders table. I am trying to use following code but fail to import/insert. bulk insert ordersfrom 'c:\orders.csv' WITH ( FIRSTROW = 2, DATAFILETYPE = 'native', FIELDTERMINATOR = '\c', ROWTERMINATOR = '\n',CODEPAGE = 'RAW' ) Error message which I m getting is: Bulk Insert fails. Column is too […]
2004-10-04
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