[عبد الخالق]

(27-07-23, 09:15 PM)ahmed_king2023 كتب : CREATE TABLE [dbo].[dept](
[dept_id] [int] IDENTITY(1,1) NOT NULL,
[dept_name] [nvarchar](150) NULL,
[id_mange] [int] NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_dept] PRIMARY KEY CLUSTERED
(
[dept_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[Employees](
[id] [int] IDENTITY(1,1) NOT NULL,
[EmployeeID] [int] NOT NULL,
[EmployeeName] [nvarchar](150) NULL,
[Nationality] [nvarchar](150) NULL,
[Gender] [nvarchar](50) NULL,
[phone] [varchar](150) NULL,
CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED
(
[EmployeeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
CREATE TABLE [dbo].[management](
[id] [int] IDENTITY(1,1) NOT NULL,
[manage_name] [nvarchar](150) NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_management] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
CREATE TABLE [dbo].[unit](
[id] [int] IDENTITY(1,1) NOT NULL,
[unit_name] [nvarchar](150) NULL,
[dept_id] [int] NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_unit] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

---

اخي لديك اسماء جدوال وحقوله في سكربت فوق

اخي هل تعرف ما المقصود بالبيانات؟ المقصود Schema and Data لاني لم اجد بيانات لاجرب عليها الاستعلام

---

ايضا لم اجد الاستعلام الذي في اول الموضوع!
هل هود Stored Procedure؟