Introduction T-SQL (Transact-SQL) is a powerful language used to query and manipulate data in a Microsoft SQL Server database. It is a powerful language that allows you to perform complex operations on data stored in a database. One of the most common operations is to rotate a table, which is the process of rearranging the … Read more
Introduction When working with data in MS SQL Server, it is often necessary to delete duplicate rows based on certain conditions. This can be done using a combination of the SELECT DISTINCT and DELETE statements. The SELECT DISTINCT statement is used to return only unique rows from a table, while the DELETE statement is used … Read more
you are saying that on change in four table you want to update the record in 5th table. For this purpose you can write an update trigger which will trigger on change on any one of the four tables and check if the needed values in four tables are updated and it will change accordingly … Read more
Your code seems fine to me, and I am unsure as to what your exact issue is; however, to clear your TextBox control’s .Text property; assign it a value of string.Empty. textBox1.Text = string.Empty; As far as your insert command, that looks fine. A point has been made that your code is vulnerable to SQL … Read more
Introduction No, SQL Command is not the only way of adding, deleting, and updating records. There are a variety of other methods that can be used to manipulate data in a database, such as using stored procedures, triggers, and other programming languages. In this article, we will discuss the different ways of manipulating data in … Read more
your table structure should be below PatientTable PatientId int Primary Key, PatientName varchar(50), EmailId varchar(50) Password varchar(50) TestTable TestId int Primary key, TestName varchar(50) PatientTestTable PatientId int FK(PatientTable) TestId int FK (TestTable) This way you can give relationship to two tables. you need to understand funamental of RDBMS. 1 solved Relationship between tables in ms … Read more
You will need to install the Oracle Client first. Google “Oracle Database Client windows” to find the download from Oracle’s site. 1) Install the 64-bit package first. (VERY important as there is a bug that messes things up if you install the x86 package first) 2) Change the install path to “C:\oracle\x64” 3) Once installed … Read more
Try: select Agent, max(case when `desc` = ‘Total’ then ColValue else 0 end) Total, max(case when `desc` = ‘Replaced’ then ColValue else 0 end) Replaced from tbl group by Agent Demo sqlfiddle 1 solved T-SQL | SQL-Server Pivot [closed]
SELECT SUM(Value) FROM TableName; Using a GROUP BY (per your comment above) is when you want things grouped over a subset. In this case, a group by would return the same info you’ve sampled, because there’s no groups to sum on the desc field… however if you had two “e” descriptions (let’s say 40 for … Read more
Assuming your are using date and MSSQL2012+: SELECT UPPER( FORMAT(CONVERT(datetime, ‘2017-02-01′,121),’MMM’)) + ‘-‘ +RIGHT(CAST( YEAR( CONVERT(datetime, ‘2017-02-01’,121)) AS VARCHAR(4)),2) M_DELIVERY , ‘DELIVERY FOR ‘ +UPPER( FORMAT(CONVERT(datetime, ‘2017-02-01′,121),’MMM’))+’ ‘+ CAST( YEAR( CONVERT(datetime, ‘2017-02-01’,121)) AS VARCHAR(4)) AS Description Other way(using numbers and not date): (you can change months name abbrev.) SELECT SUBSTRING(‘GENFEBMARAPRMAYJUNJULAUGSEPOCTNOVDEC’,1+(MONTH_NUMB-1)*3,3)+’-‘+ RIGHT(YEAR_NUMB,2) AS M_DELIVERY , ‘DELIVERY … Read more
You do not need any of these IF..ELSE statements or even the sub-queries in your select, what you are after, can be achieved with the following simple select query: CREATE PROC GET_ORDER_ACCOUNT_DETAILS @ORDERID INT AS BEGIN SET NOCOUNT ON; SELECT CASE WHEN od.calcType=”K” THEN od.price * od.kilo ELSE od.quant * od.price END as [AMOUNT] ,od.quant … Read more
First, I do not really know which is the default OUTER JOIN in T-SQL (I’d bet FULL), but in any case, I think it is unclear – it is best to use LEFT, RIGHT, OR FULL JOIN explicitly when you need one. JOIN joins tables. Already existent ones or subqueries. APPLY applies (duh) a table-valued … Read more
You need to revisit your table design for sure. I am not very clear what you are looking for, but i feel that you are looking for entires in the derived table for which one or more values are null. For this scenario you can write query like following. select distinct mt.mainid from maintable mt … Read more
First, let’s define what we need. We need a table (view) with these fields: ProductId, ProductName, ProductViewCount, and RootCategoryId. Imagine, the Category table has RootCategoryId field already. Then we can use this query to receive the result: SELECT P.Id AS ‘ProductId’, P.Name AS ‘ProductName’, PVC.ProductViewCount, C.RootCategoryId FROM Category C INNER JOIN ProductCategory PC ON PC.CategoryId … Read more
The two likely problems that I can see without you adding the error code. is that you are missing the column names in your insert statement. is that a user is putting an apostrophe in one of your text boxes. This is a SQL Injection vulnerability. Try something similar to this instead: using (SqlConnection con … Read more