Technical Article

RE: Key Items

  • Reply

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 […]


Technical Article

RE: How to lock?

  • Reply

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 […]


Technical Article

RE: Using "Like" or Wildcard

  • Reply

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').


Technical Article

RE: Output to file

  • Reply

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



Deadline for Microsoft MVP contributions is 20 March 2023


Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Goal Progress for Jan 2023


The grade for January is a D. Details below, but just not making a...

Context Info Across Databases–#SQLNewBlogger


Does Context Info work across databases? This post shows it does. Another post for...

Read the latest Blogs


Storing a text file in a VARCHAR(MAX) column

By Mick Opalak

I'm using OPENROWSET to put the contents of a text file into a VARCHAR(MAX)...

"ID" primary key from two separate tables as a foreign key in a new table

By Edub1122

I have two tables: tblProfessors with ProfessorID as the primary key and tblStudents with...

blocking issue

By vsamantha35

Hi All, We are seeing SELECT's blocking DML's like UPDATE statements. When we tried...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers