sql²åÈëÓï¾äÎÊÌâ - MS-SQL Server / »ù´¡Àà

Èý¸ö±í

Óû§±í£ºbf_user
CREATE TABLE [dbo].[BF_User](
[cUser_Id] [nvarchar](20) NOT NULL,
[cUser_Name] [nvarchar](100) NULL,
[cPassword] [nvarchar](255) NULL,
  ¡£¡£¡£¡££©
Óû§È¨ÏÞ±í£ºBF_HoldAuth

CREATE TABLE [dbo].[BF_HoldAuth](
[hoid] [int] IDENTITY(1,1) NOT NULL,
[cacc_id] [varchar](50) NULL,
[iyear] [varchar](50) NULL,
[cauth_id] [varchar](50) NULL,
[cUser_Id] [nvarchar](20) NULL,
[iIsUser] [bit] NULL,
[csub_id] [varchar](50) NULL,
  ¡£¡£¡£¡£¡££©

Óû§×é±í£ºBF_HoldBcgrp
CREATE TABLE [dbo].[BF_HoldBcgrp](
[hbid] [int] IDENTITY(1,1) NOT NULL,
[cacc_id] [varchar](50) NULL,
[iyear] [varchar](50) NULL,
[BcGroup] [varchar](50) NULL,
[cUser_Id] [nvarchar](20) NULL,
  ¡£¡£¡£¡£¡££©

ÎÊÌâ1. ÏòÓû§×é±í²åÈëÓû§×éȨÏÞ 
  INSERT INTO BF_HoldBcgrp (bcgroup, cuser_id) VALUES ('A','35101');

  ÒòΪ±í¡¾bf_user¡¿ÖÐûÓÐÁС°bcgroup¡±£¬ËùÒÔÈçºÎ¸ù¾Ý²éѯ±í¡¾bf_user¡¿µÃ³öÓû§ID£¬ÅúÁ¿²åÈë¡£
   
  ÁС°bcgroup¡± ²åÈëµÄÊdz£Á¿

ÎÊÌâ2. ²åÈëÓû§È¨ÏÞ  
  INSERT INTO BF_HoldAuth (cauth_id, cuser_id, csub_id) VALUES ('BF010401','35104','BF');
  INSERT INTO BF_HoldAuth (cauth_id, cuser_id, csub_id) VALUES ('BF010402','35104','BF');
  INSERT INTO BF_HoldAuth (cauth_id, cuser_i