Tag: update

ASP.Net MVC / ASP.Net WebForms

How to add Output Parameter to SqlDataSource

- 24.06.22 - ErcanOPAK comment on How to add Output Parameter to SqlDataSource

<asp:Parameter Name=”NewID” Direction=”Output” Type=”Int32″ DefaultValue=”0″ /> Here is a more detailed example in use: <asp:sqlDataSource ID=”EmployeeDetailsSqlDataSource” SelectCommand=”SELECT EmployeeID, LastName, FirstName FROM Employees WHERE EmployeeID = @EmpID” InsertCommand=”INSERT INTO Employees(LastName, FirstName) VALUES (@LastName, @FirstName); SELECT @EmpID = SCOPE_IDENTITY()” UpdateCommand=”UPDATE Employees SET LastName=@LastName, FirstName=@FirstName WHERE EmployeeID=@EmployeeID” DeleteCommand=”DELETE Employees WHERE EmployeeID=@EmployeeID” ConnectionString=”<%$ ConnectionStrings:NorthwindConnection %>” OnInserted=”EmployeeDetailsSqlDataSource_OnInserted” RunAt=”server”> <SelectParameters> <asp:Parameter […]

Read More
SQL

How to get triggers create and update date in SQL

- 07.06.22 - ErcanOPAK comment on How to get triggers create and update date in SQL

SELECT o.name as [Trigger Name], CASE WHEN o.type = ‘TR’ THEN ‘SQL DML Trigger’ WHEN o.type = ‘TA’ THEN ‘DML Assembly Trigger’ END AS [Trigger Type], sc.name AS [Schema_Name], OBJECT_NAME(parent_object_id) as [Table Name], o.create_date [Trigger Create Date], o.modify_date [Trigger Modified Date] FROM sys.objects o INNER JOIN sys.schemas sc ON o.schema_id = sc.schema_id WHERE (type = […]

Read More
Windows

How to solve 0xc0000135 application errors after Windows 11 Update

- 20.05.22 - ErcanOPAK comment on How to solve 0xc0000135 application errors after Windows 11 Update

Windows 11 users are receiving 0xc0000135 errors when attempting to launch applications after installing the recent Windows 11 KB5013943 cumulative update. Yesterday, Microsoft released new Windows cumulative updates to fix security vulnerabilities and bugs as part of the May 2022 Patch Tuesday. These updates include the Windows 11 KB5013943 update, which included fixing a bug causing .NET […]

Read More
SQL

How to find repetitive records and keep only 1 record for uniqueness in SQL

- 08.11.19 | 22.11.19 - ErcanOPAK comment on How to find repetitive records and keep only 1 record for uniqueness in SQL

–STEP 1: Find Repetitive Records (Only the Active Ones) SELECT INDEX1, INDEX2 INTO #TEMP_TABLE FROM MY_TABLE WHERE ACTIVE = 1 GROUP BY INDEX1, INDEX2 HAVING COUNT(1) > 1 ORDER BY COUNT(1) DESC –STEP 2: Create the Cursor DECLARE @INDEX1 INT DECLARE @INDEX2 INT DECLARE @ID INT DECLARE MY_CURSOR CURSOR FOR SELECT INDEX1, INDEX2 FROM #TEMP_TABLE […]

Read More
ASP.Net MVC / ASP.Net WebForms / Devexpress / HTML

How to Solve The ‘Object reference not set to an instance of an object’ error in Batch Edit mode for ASPxGridView

- 01.10.19 | 22.11.19 - ErcanOPAK comment on How to Solve The ‘Object reference not set to an instance of an object’ error in Batch Edit mode for ASPxGridView

The issue occurs in Batch Edit Mode, because in this mode an empty invisible row is created and used for further grid editing. Since the Eval method returns a value type of an object, your attempt to call the ToString() method to the null value can lead to an exception. If you remove this conversion and use <%# […]

Read More
SQL

Return number of rows affected by UPDATE statements in SQL

- 18.09.19 | 22.11.19 - ErcanOPAK comment on Return number of rows affected by UPDATE statements in SQL

DECLARE @Teams TABLE( Name varchar(100) ) INSERT INTO @Teams VALUES (N’GALATASARAY’) INSERT INTO @Teams VALUES (N’LIVERPOOL’) INSERT INTO @Teams VALUES (N’BARCELONA’) INSERT INTO @Teams VALUES (N’PARIS SAINT GERMAIN’) INSERT INTO @Teams VALUES (N’JUVENTUS’) UPDATE @Teams SET Name = N’PORTO’ WHERE Name = ‘PARIS SAINT GERMAIN’ SELECT @@ROWCOUNT –gives 1

Read More
PHP / Wordpress

How to solve “PHP Update Required” warning on WordPress

- 14.09.19 | 22.11.19 - ErcanOPAK comment on How to solve “PHP Update Required” warning on WordPress

The WordPress open-source content management system (CMS) will show warnings in its backend admin panel if the site runs on top of an outdated PHP version. The short-term plan is to migrate as many active users to more recent versions of PHP as possible so that the WordPress team can drop support for older PHP […]

Read More