2004-12-16
SQL
RE: Copy SP
I have INSERT tbl2 SELECT id,fname,lname from tbl1 WHERE ref# = '123' This works fine but what if I just wanted to insert fname and leave lname out (which would insert NULLS in that column).
2004-12-16
RE: How to!
SQL doesnot allow you to use derived column names in the where clause. You will have to repeat the formula in the where clause
2004-12-14
2004-12-07
RE: Build query by using function
Try this: SELECT SerialNumber, PassFail, CASE WHEN [PassFail] = 1 THE 'Pass' ELSE 'Fail' END AS Expr1 FROM TestLog (Note, this does not include any test for a NULL or any other number..., you may want to look up CASE in BOL and see if you want to include more...)
2004-12-06
RE: Temporary Network
To use a name you need to ask your network admins to create a record foryour server on DNS server. I also tested creating a DNS alias which is not a machine name but a nice name. We usually use DNS aliases for the Web, but it works fine with SQL ServerYelena
2004-11-19
RE: Temporary Network
Just install SQL on one of the servers, people can connect via IP or the NetBIOS name.
2004-11-19
RE: Dynamic SQL problem
Don't make me feel < snip and switch to my online dictionary> embarrassed </snip>
2004-11-19
Distributed Transaction - OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator.
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!
2004-11-11
RE: Help with UPDATE query
..I agree, swap the or for an and....I rewrote the code below and tested it with a positive outcome. IF EXISTS(SELECT patient.F00069, patient.F00026, patient.F01298, patient.F01299, patient.F01300 FROM patient INNER JOIN tumor ON patient.UK = tumor.FK1 INNER JOIN followup ON tumor.FK1 = followup.FK1 INNER JOIN hospital ON tumor.UK = hospital.FK2 WHERE (hospital.F00026 = '0' OR hospital.F00026 = […]
2004-11-09
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
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