[عبد الخالق]

(27-07-23, 12:55 PM)ahmed_king2023 كتب : اخي توجد مشكلة في موقع
قمت برفعه علي ميديا فاير
https://www.mediafire.com/file/j2qjegwte...s.rar/file

للاسف المشروع يتضمن ادوات DevExpress فلن يعمل عندي و سكريبت القاعده غير مرفقه

---

اعمل مشروع جديد بدون ادوات خارجيه بنافذة واحده لعرض ناتج الاستعلام و رفع ملف القاعده مع سكريبت القاعده متضمنه بيانات

[ahmed_king2023]

عملت مشروع قاعدة بيانات اسمه HR
http://www.mediafire.com/file/20c0aam0tk...tion24.rar

[عبد الخالق]

(27-07-23, 07:24 PM)ahmed_king2023 كتب : عملت مشروع قاعدة بيانات اسمه HR
http://www.mediafire.com/file/20c0aam0tk...tion24.rar

اين القاعده او سكريبت القاعده
لا تعمل backup ارسل الملف او سكريبت

[ahmed_king2023]

USE [master]
GO

/****** Object: Database

---

Script Date: 27/07/2023 06:13:23 م ******/
CREATE DATABASE

---

CONTAINMENT = NONE
ON PRIMARY
( NAME = N'HR', FILENAME = N'D:\Microsoft SQL Server\MSSQL12.AYMEN\MSSQL\DATA\HR.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'HR_log', FILENAME = N'D:\Microsoft SQL Server\MSSQL12.AYMEN\MSSQL\DATA\HR_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
USE

---

GO
/****** Object: Table [dbo].[dept] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
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]

GO
/****** Object: Table [dbo].[Employees] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[management] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
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
/****** Object: Table [dbo].[unit] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
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

[عبد الخالق]

(27-07-23, 08:28 PM)ahmed_king2023 كتب : USE [master]
GO

/****** Object: Database

---

Script Date: 27/07/2023 06:13:23 م ******/
CREATE DATABASE

---

CONTAINMENT = NONE
ON PRIMARY
( NAME = N'HR', FILENAME = N'D:\Microsoft SQL Server\MSSQL12.AYMEN\MSSQL\DATA\HR.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'HR_log', FILENAME = N'D:\Microsoft SQL Server\MSSQL12.AYMEN\MSSQL\DATA\HR_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
USE

---

GO
/****** Object: Table [dbo].[dept] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
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]

GO
/****** Object: Table [dbo].[Employees] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[management] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
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
/****** Object: Table [dbo].[unit] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
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

هذا السكريبت فيه تكوين الجدوال فقط ولم يتضمن بيانات
اعد السكريبت ولكن قم بتضمين البيانات

---

ايضا لم اجد الاستعلام الذي في اول الموضوع

---

قم بعمل سكريبت لكامل قاعده البيانات بشمل البيانات والاجراءات المخزنه ايضا

[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

---

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

[عبد الخالق]

(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؟

[ahmed_king2023]

اخي قاعده بيانات جديده تعتبر لايوجد لدي اي اجراء مخزن او بيانات جديده قاعده
انا اريد مثلا كيفية بحيث عندما ابحث عن موظف يظهر لي اي ادارة يتبع واي قسم واي وحدة
موظف عبد الخالق ادارة موارد بشرية قسم شؤون موظفين وحدة ملاك وظيفي
هدا سكربت
USE

---

GO
/****** Object: Table [dbo].[dept] Script Date: 27/07/2023 10:40:13 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
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]

GO
/****** Object: Table [dbo].[Employees] Script Date: 27/07/2023 10:40:13 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[management] Script Date: 27/07/2023 10:40:13 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
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
/****** Object: Table [dbo].[unit] Script Date: 27/07/2023 10:40:13 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
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
SET IDENTITY_INSERT [dbo].[management] ON

INSERT [dbo].[management] ([id], [manage_name], [employee_id]) VALUES (2, N'ادارة الموارد البشرية', NULL)
INSERT [dbo].[management] ([id], [manage_name], [employee_id]) VALUES (4, N'ادارة الشؤون الادارية', NULL)
SET IDENTITY_INSERT [dbo].[management] OFF

---

رقم وظيفي هو employee_id
بحيث يميز موظف عن الاخر
عندما ابحث عن موظف يكون هو يميزه عن موظف اخر

[عبد الخالق]

(28-07-23, 12:42 AM)ahmed_king2023 كتب : اخي قاعده بيانات جديده تعتبر لايوجد لدي اي اجراء مخزن او بيانات جديده قاعده
انا اريد مثلا كيفية بحيث عندما ابحث عن موظف يظهر لي اي ادارة يتبع واي قسم واي وحدة
موظف عبد الخالق ادارة موارد بشرية قسم شؤون موظفين وحدة ملاك وظيفي
هدا سكربت
USE

---

GO
/****** Object:  Table [dbo].[dept]    Script Date: 27/07/2023 10:40:13 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
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]

GO
/****** Object:  Table [dbo].[Employees]    Script Date: 27/07/2023 10:40:13 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[management]    Script Date: 27/07/2023 10:40:13 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
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
/****** Object:  Table [dbo].[unit]    Script Date: 27/07/2023 10:40:13 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
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
SET IDENTITY_INSERT [dbo].[management] ON

INSERT [dbo].[management] ([id], [manage_name], [employee_id]) VALUES (2, N'ادارة الموارد البشرية', NULL)
INSERT [dbo].[management] ([id], [manage_name], [employee_id]) VALUES (4, N'ادارة الشؤون الادارية', NULL)
SET IDENTITY_INSERT [dbo].[management] OFF

---

رقم وظيفي هو employee_id
بحيث يميز موظف عن الاخر
عندما ابحث عن موظف يكون هو يميزه عن موظف اخر

حاولت اطبق الاستعلام في اول الموضوع على مشروعك الاخير خصوصا السكريبت
فحصل رفض لان اسماء الجداول اتغيرت

[ahmed_king2023]

قمت بتطبيق علي سكربت جديد انا بحاجة الي مشروع