Select a.account_id, a.bill_contact, a.bill_address, cc.cc_number, cc.cc_type, cc.cc_exp From Account a, (Select * From Credit_Card) As cc Where (a.bill_method = 'CC' AND a.account_id = cc.account_id) MW
2003-06-19
1 reads
Here is an example. I want to have two fields as primary keys. Do I just add Primary key as stated ? SELECT distinct TOP 100 PERCENT [Client ID] Primary Key, [Account Number] Primary Key, [Proj Black 1% Depr Month], [Proj Black Str Adj], [Proj Black Sea Adj], [Black Book Straight Proj Loss], [Black Book […]
2003-06-18
1 reads
I've found that a locked bit isnt enough, I want to know who locked. Lots of times an app/connection will drop, leaving the lock bit set. We go with the userid of the user locking the record, either NT login or some internal login. To update you have to be that user, which means if […]
2003-06-12
By using the OR clause, you will get both. The OR clause returns all records that match either criteria (ie.. The course is active or the course name starts with '10'). The AND clause will only return those records that meet both criteria (ie.. the course is active and the course name starts with '10').
2003-06-09
Sorry we haven't been able to help. You might try the newsgroups that MS has, see www.msdn.microsoft.com. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-05-30
1 reads
Dear friend Let me know one thing, are you trying for client side cursors or disconnected record sets. In that case I better suggest the use of DB library and ODBC API.But an ADO like implementation is not child’s play I think With regards John
2003-05-29
I have installed yesterday on a test server the SP3a. No problems. MS say trhat if you already have installed the SP3 u don't need to install this version.
2003-05-27
1 reads
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
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