Ok, So I'm a bit new at SQL Server, and I've researched this everywhere but cannot find a clear answer and/or sample code for a solution:
-I have a table [Indicators] that has a bunch of fields including [MOE] field and a [Indicator_Selec tor] field, and the [INDid] field, which is the PK.
-My goal is to auto-generate the [INDid] field (PK) from concatenating the [MOE] and [Indicator_Selec tor] fields. so... [INDid]=[MOE]+[Indicator_Selec tor]....
1 result in 0.0014 seconds.
-
newDevMan started a topic SQL Server: Create an ID field (PK) based on two fields with a trigger-- HELP!in SQL ServerSQL Server: Create an ID field (PK) based on two fields with a trigger-- HELP!