In English, not SQL, what are you trying to accomplish here? Have you taken a look at DATEADD(hour, DateField)? To strip the time portion of a datetime field, use DATEADD(day, 0, DATEDIFF(day, 0, DateField)) since it requires no lookup to syslanguages to find the localization string for CONVERT(varchar, DateField, 112). Also, use the BETWEEN clause. […]
2003-07-14
2003-06-17
Problem Solved. After running a packet sniffer for a while I discovered that there was an ARP request for the IP of the database server right before the problem. So as it turns out there was a network camara sharing its IP address. The camara was on the same network segment so its ARP request […]
2003-06-11
11 reads
When using SQL Query Analyzer: What DB would I run that proc under...master Thanks
2003-06-09
This may be simplistic and I may be missing the original concept of what we are talking about, but I think you can update the nulls with <BR><BR> SET <this column> = MAX(<this column>)+1, ... etc<br><br> that would store the next available value to the column for you (just make VERY sure you get the […]
2003-06-02
the hard-coded numbers were inserted by me as I added items in the columns. The Spanish column does allow nulls, but the primary key 'ID' certainly does not. The problem is that the insert statement added the values and there werent't any hardcoded 'IDs' for those values. However I am trying to get those values […]
2003-06-02
Ah, sorry, the error is on the ID column, not the Spanish column. What eljeffo said should be true. Patrick
2003-06-02
What generates the hard-coded numbers? Also, give me a little more info please on why you think the numbers have to be updated... I thought you were inserting...
2003-06-02
I have checked the log file but I didn't find any thing related to jobs venkatesh
2003-05-27
2 reads
The SQL Agent log file might have some clues. That log is can be found in the following default location c:\mssql\log\sqlagent.out, although on your install it might be somewhere else. Gregory Larsen, DBA If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
2003-05-27
1 reads
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
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...
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