1
2
3
4
5
6
7
8
9
10
11
12
SELECT * INTO #temptable FROM [Northwind].[dbo].[Products] UPDATE #temptable SET [UnitPrice] = [UnitPrice] + 10
DECLARE @tempTable TABLE ( [ProductID] [int] NOT NULL, [ProductName] [nvarchar](40) NOT NULL, [UnitPrice] [money] NULL ) INSERT INTO @tempTable SELECT [ProductID], [ProductName], [UnitPrice] FROM [Northwind].[dbo].[Products] UPDATE @temptable SET [UnitPrice] = [UnitPrice] + 10
WITH yourName [(Column1, Column2, ...)] AS ( your query )
WITH temp AS ( SELECT [ProductName], [UnitPrice] FROM [Northwind].[dbo].[Products] ) SELECT * FROM temp ORDER BY [UnitPrice] DESC
WITH orderSales (OrderID, Total) AS ( SELECT [OrderID], SUM([UnitPrice]*[Quantity]) AS Total FROM [Northwind].[dbo].[Order Details] GROUP BY [OrderID] ) SELECT O.[ShipCountry], SUM(OS.[Total]) AS TotalSales FROM [Northwind].[dbo].[Orders] AS O INNER JOIN [orderSales] AS OS ON O.[OrderID] = OS.[OrderID] GROUP BY O.[ShipCountry] ORDER BY TotalSales DESC
WITH customerList AS ( SELECT [CustomerID], [ContactName] FROM [Northwind].[dbo].[Customers] WHERE [Country] ='UK' ) ,orderList AS ( SELECT [CustomerID], [OrderDate] FROM [Northwind].[dbo].[Orders] WHERE YEAR([OrderDate])< 2000 ) SELECT cl.[ContactName], YEAR(ol.[OrderDate]) AS SalesYear FROM customerList AS cl JOIN orderList AS ol ON cl.[CustomerID] = ol.[CustomerID]
WITH digitList AS ( SELECT [digit] from [digits] ) SELECT a.[digit] * 10 + b.[digit] + 1 AS [Digit] FROM [digitList] AS a CROSSJOIN [digitList] AS b
WITH CTE_1 AS ( .... ), CTE_2 AS ( SELECT ... FROM CTE_1 JOIN ... ) SELECT * FROM FOO LEFTJOIN CTE_1 LEFTJOIN CTE_2
WITH cteName AS ( query1 UNION ALL query2 )
IFOBJECT_ID('Employees','U')ISNOTNULL DROPTABLE dbo.Employees GO CREATETABLE dbo.Employees ( EmployeeID intNOTNULLPRIMARYKEY, FirstName varchar(50)NOTNULL, LastName varchar(50)NOTNULL, ManagerID intNULL ) GO INSERTINTO Employees VALUES (101,'Alireza','Nematollahi',NULL) INSERTINTO Employees VALUES (102,'Ahmad','Mofarrahzadeh', 101) INSERTINTO Employees VALUES (103,'Mohammad','BozorgGhommi', 102) INSERTINTO Employees VALUES (104,'Masoud','Narimani', 103) INSERTINTO Employees VALUES (105,'Mohsen','Hashemi', 103) INSERTINTO Employees VALUES (106,'Aref','Partovi', 102) INSERTINTO Employees VALUES (107,'Hosain','Mahmoudi', 106) INSERTINTO Employees VALUES (108,'Naser','Pourali', 106) INSERTINTO Employees VALUES (109,'Reza','Bagheri', 102) INSERTINTO Employees VALUES (110,'Abbas','Najafian', 102)
WITHcteReports(EmpID, FirstName, LastName, MgrID, EmpLevel) AS ( SELECT EmployeeID, FirstName, LastName, ManagerID, 1 FROM Employees WHERE ManagerID ISNULL UNIONALL SELECT e.EmployeeID, e.FirstName, e.LastName, e.ManagerID,r.EmpLevel + 1 FROM Employees e INNERJOINcteReports r ON e.ManagerID = r.EmpID ) SELECT FirstName +' '+ LastName AS FullName, EmpLevel, (SELECT FirstName +' '+ LastName FROM Employees WHERE EmployeeID = cteReports.MgrID)AS Manager FROMcteReports ORDERBY EmpLevel, MgrID
WITHcteReports(EmpID, FirstName, LastName, MgrID, EmpLevel) AS ( SELECT EmployeeID, FirstName, LastName, ManagerID, 1 FROM Employees WHERE EmployeeID = 110 UNIONALL SELECTe.EmployeeID, e.FirstName, e.LastName, e.ManagerID,r.EmpLevel + 1 FROM Employees e INNERJOINcteReports r ON e.EmployeeID = r.MgrID ) SELECT FirstName +' '+ LastName AS FullName, EmpLevel FROMcteReports ORDERBY EmpLevel
These are very simple and elegant visualizations, and they should not require a bloated graphing library to produce.
React Trend is a concrete component that does 1 thing, and does it well: generate these trending graphs. Demo
Error2'student_mvc.Security.CustomRoleProvider' does not implement inherited abstract member 'System.Web.Security.RoleProvider.GetAllRoles()
Error3'student_mvc.Security.CustomRoleProvider' does not implement inherited abstract member 'System.Web.Security.RoleProvider.GetUsersInRole(string)
The first preview of Entity Framework Core (EF Core) 8 is available on NuGet today!
EF Core 8, or just EF8, is the successor to EF Core 7, and is scheduled for release in November 2023, at the same time as .NET 8.
EF8 currently targets .NET 6. This will likely be updated to .NET 8 as we near release.
EF8 will align with .NET 8 as a long-term support (LTS) release. See the .NET support policy for more information.
Line 19: @BundleConfig.AddStyles("~/Content/css",
Line 20: "~/Content/bootstrap.css",
Type 'sitemap' does not inherit from 'System.Web.UI.Page'.
ویژگیها
1- داکیومنت مناسب + ایجکسی بودن
2- قابلیت نگهداری صفحه(اگر در صفحهی 6 مرورگر را ببندید. در بازدید بعدی باز هم همان صفحهی 6 نمایش داده میشود).
3- خروجی اکسل و ورد و...(pdf برای زبان فارسی مناسب نیست.)(با جاوااسکریپت کار میکنه)
4- نمایش متفاوت در گوشیها( هر ستون به یک سطر تبدیل میشه)
5- فیلتر کردن و جستجوی کلی(بدون زحمت)(نگهداری فیلتر و جستجو در بازدید بعدی)
6- افزودن دکمه در هر سلول با توجه به نیاز
7- کم زیاد کردن ستونها توسط کاربر و نگهداری تغییرات برای بازدید بعدی
8- فریز کردن عنوان جدول در زمان ارتفای زیاد
9- نمایش جدول در داخل جدول
10-تغییر اندازه ستون ها- مرتب سازی هر ستون- امکان استفاده از چند فیلتر با هم