5409045121009 Thanks once more. What I'm doing -- before launching each page, but only after trying to give more attention in reviewing the texts and commands (of course!!!) -- is, at MMC, right-clicking over my site, disconnecting-and-(re)connecting IIS. Wish it -also-helps!!! Dalton
2003-05-11
1 reads
One more question- In setting up a 2 node fail over cluster, how similar in hardware do the 2 servers need to be? Is it sufficient for the 2 servers to be capable of performing the same level of transactions and have the same drive layout and folder structure or do they need to be […]
2003-05-08
I believe you are going to need to declare the table variable & fields before you can reference it. Not like a temp table that you can delcare and populate on the fly. declare @table table ( 1st field integer, 2nd field varchar(20), etc )
2003-05-07
1 reads
2003-05-05
1 reads
WHERE invoicedate BETWEEN DATEADD( mm, -6, CAST( CAST( DATEADD( dd, 1-DAY( getdate()), getdate() ) AS CHAR( 11 ) ) AS DATETIME ) ) AND CAST( CAST( DATEADD( dd, 1-DAY( getdate()), getdate() ) AS CHAR( 11 ) ) AS DATETIME ) Although I would recommend running GETDATE() one time prior to running this statement and using […]
2003-05-02
If you are talking about JOIN condition, it is better and more correct in the JOIN clause, not in the WHERE clause. It is also better to limit your result as soon as possible. Consider this: SELECT col1, col2 FROM t1 JOIN t2 ON t1.c3 = @variable AND t1.c4 = t2.c5 Having ON t1.c3 = […]
2003-05-02
I was going to use Isdate() but it doesn't work on Datetime types, does it? Developer Developer Developer Developer Developer Developer Developer *jumps around like a moron* Developer Developer
2003-05-02
select * into newtable where isdate(hopefully_date_field) = 1 Insert into newtable select field1, case field2 when isdate(hopefully_date_field) = 1 THEN hopefully_date_field else null end Either of these help?
2003-05-02
Are you doing your backups to a remote server? It seems that something happend in the network while executing the backups
2003-05-02
1 reads
By Angela-Henry
Have you heard the news about the new Power BI Project files? Okay, maybe...
By Steve Jones
I wrote an article that was published on SQL Server Central on how to...
It’s a great question. Let’s say you want to capture stored procedure completions. But,...
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