RE: Maximum length of a Varchar Variable
How did I keep the nice format? I cheated!!!!!!!!!!!!!!!!!!I copied the code into Notepad, fixed the format and then copied that into the reply text box.-SQLBill
2004-02-27
Cursors
RE: Are partitioned views not that smart?
Hi John,Newbie or no, you are correct: you need those check constraints. But if you looke further back in this thread you'll see that we've discussed that a bit already. Friendly user mssql_rules has indicated that their view meets all those requirements for partitioned views, and that he can in fact update through them. If […]
2004-02-15
2004-02-15
1 reads
RE: Writing to a log within a stored procedure.
the Log RAISEERROR uses are the Windows Application Log and the SQL Server Error Log!!!!
2004-02-13
Active\Active SQL server cluster
Hello All, I'm a bit confused on how the failover processes works on a SQL server 2000 two node active/active cluster in terms of handling system databases. Given the following You have 2 node active/active cluster NodeA & NodeB and If I'm not mistaken a two node active\active cluster will have 2 instances running i.e NodeA will have a default […]
2004-01-20
2 reads
RE: SQL Server 6.5 SP3
You can download it if you know where to look. Try: ftp://207.46.133.140/bussys/sql/public/fixes/usa/SQL65/Sp3/ Select your processor (Alpha or Intel) and continue drilling down. Assuming an Intel processor, your full download path is: ftp://207.46.133.140/bussys/sql/public/fixes/usa/SQL65/Sp3/Sp3Intel/65SP3X86.EXE
2003-07-28
1 reads
2003-07-25
RE: Insert rows where PK is unique INT (not identity)
I'd insert into a temp table that does use an identity. You can set the seed to be the "pop" value from your separate table and then update that at the end. Be sure you lock this value until then (use a transaction). Insert into your table from the temp table.. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones […]
2003-07-24
RE: Complex Query -- Help needed
Why not simply the query, like so SELECT Regions.Description, COUNT(oh.id) AS TotalOrders, SUM(CASE WHEN (ISNULL(oh.timedorder,0) = 0) THEN 1 ELSE 0 END) AS TotalASAP, SUM(CASE WHEN (oh.timedorder = -1) THEN 1 ELSE 0 END) AS TotalNOASAP, SUM(CASE WHEN (isnull(oh.quote_minutes,0) <=59) AND ISNULL(oh.timedorder,0) THEN 1 ELSE 0 END) AS fiftymins, SUM(CASE WHEN (oh.quote_minutes >= 60 AND […]
2003-07-17
RE: what is the best way to search between tow date fd
but like your explains i can not search evry day between Getdate() '16:00' and Getdate()+1 '16:00' and in tow different field thnks ilan
2003-07-14
Blogs
How I implemented database migration on AWS using AWS DMS
As a Software Engineer, I would like to replicate a copy of my database...
My personal experience dockerizing a Rust Application: Deploy to AWS ECR using Github Actions
I have heard about many interesting things about programming in Rust and I decided...
The Importance of Patch Management to Avoid Downtime
A recent Microsoft outage caused by a bad patch pushed out to Windows instances...
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