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
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://www.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
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
By Steve Jones
The grade for January is a D. Details below, but just not making a...
By Steve Jones
Does Context Info work across databases? This post shows it does. Another post for...
I'm using OPENROWSET to put the contents of a text file into a VARCHAR(MAX)...
I have two tables: tblProfessors with ProfessorID as the primary key and tblStudents with...
Hi All, We are seeing SELECT's blocking DML's like UPDATE statements. When we tried...
Ask SSC