Skip to content

ErcanOPAK.com

  • ASP.Net WebForms
  • ASP.Net MVC
  • C#
  • SQL
  • MySQL
  • PHP
  • Devexpress
  • Reportviewer
  • About

Tag: column

SQL

How to check for ‘IS NOT NULL’ And ‘IS NOT EMPTY’ string in SQL

- 09.04.21 - ErcanOPAK comment on How to check for ‘IS NOT NULL’ And ‘IS NOT EMPTY’ string in SQL

If you only want to match N” as an empty string SELECT COLUMN FROM TABLE WHERE DATALENGTH(COLUMN) > 0 If you want to count any string consisting entirely of spaces as empty SELECT COLUMN FROM TABLE WHERE COLUMN <> ” If you want to use DATALENGTH for any string consisting entirely of spaces then you […]

Continue Reading ..
SQL

Filter Rows By Max Date in SQL

- 13.01.21 - ErcanOPAK comment on Filter Rows By Max Date in SQL

SELECT m1.Column1, m1.Column2, m1.Column3, r.MaxTime FROM ( SELECT Column1, MAX(TimeColumn) as MaxTime FROM MyTable GROUP BY Column1 ) r INNER JOIN MyTable m1 ON m1.Column1= r.Column1AND m1.TimeColumn = r.MaxTime

Continue Reading ..
ASP.Net MVC / ASP.Net WebForms / JavaScript

How to use column search in datatable when responsive is false

- 18.09.20 - ErcanOPAK comment on How to use column search in datatable when responsive is false

just add “$(“th”).show();” in the end of initComplete … , initComplete: function () { … $(“th”).show(); } , …  

Continue Reading ..
SQL

Unique Constraints in MS SQL Server to prevent duplications

- 31.03.20 | 31.03.20 - ErcanOPAK comment on Unique Constraints in MS SQL Server to prevent duplications

The UNIQUE constraint ensures that all values in a column are different. Both the UNIQUE and PRIMARY KEY constraints provide a guarantee for uniqueness for a column or set of columns. A PRIMARY KEY constraint automatically has a UNIQUE constraint. However, you can have many UNIQUE constraints per table, but only one PRIMARY KEY constraint […]

Continue Reading ..
SQL

Rename column SQL Server

- 28.11.19 - ErcanOPAK comment on Rename column SQL Server

EXEC sp_RENAME ‘TableName.OldColumnName’ , ‘NewColumnName’, ‘COLUMN’

Continue Reading ..
SQL

How to Alter a Computed Column in SQL?

- 25.09.19 | 22.11.19 - ErcanOPAK comment on How to Alter a Computed Column in SQL?

There is NO way to alter computed column. You have to drop and recreate it. Let’s say you have a table with 3 column. And the 3rd one is the sum of the other two: CREATE TABLE MyTable (Column1 int, Column2 int, Column3 AS Column1 + Column2); If you want to change that computed column as multiply of the other […]

Continue Reading ..
ASP.Net WebForms / C# / Devexpress

How to set Tooltip for a particular Devexpress Gridview Column

- 24.05.19 | 22.11.19 - ErcanOPAK comment on How to set Tooltip for a particular Devexpress Gridview Column

You can use code below:

Continue Reading ..
ASP.Net WebForms / C# / Devexpress

Devexpress ASPxGridview Column Grouping in Code

- 12.06.18 | 30.03.20 - ErcanOPAK comment on Devexpress ASPxGridview Column Grouping in Code

The following code shows how to group by two columns (“Country” and “City”).

Continue Reading ..
SQL

Add Default Value in SQL Server

- 03.06.18 | 03.06.18 - ErcanOPAK comment on Add Default Value in SQL Server

If there is no default value for the column then you can use this query: ALTER TABLE MyTable ADD CONSTRAINT df_MyTable_MyColumn DEFAULT 0 FOR MyColumn

Continue Reading ..
Page 1 of 2
1 2 Next »

Posts navigation

Older posts
April 2021
M T W T F S S
 1234
567891011
12131415161718
19202122232425
2627282930  
« Jan    

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (243)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (194)
  • How to make some specific word(s) Bold or Underline in ReportViewer (187)
  • How to solve “Response.Redirect cannot be called in a Page callback” for DevExpress Components (183)
  • Confirm before process with ASPxButton in Devexpress (172)
  • ASPxGridView – Disable CheckBox based on condition in GridViewCommandColumn (170)
  • Find numbers with more than two decimal places in SQL (168)
  • Devexpress ASPxGridview Column Grouping in Code (164)
  • DATEADD Function in SQL (163)
  • Tense Changes When Using Reported Speech (160)

Recent Posts

  • How to check for ‘IS NOT NULL’ And ‘IS NOT EMPTY’ string in SQL
  • How to auto-scroll or manually to end of div when data is added
  • Filter Rows By Max Date in SQL
  • How to Validate a DateTime in C#?
  • Convert comma separated string into a List in C#
  • Converting a List to a comma separated string in C#
  • How to add placeholder to Multiple Selection DropDownList in Asp.Net MVC
  • How to use toFixed() for Float numbers in Javascript
  • Convert List to List in one line in C#
  • How to use column search in datatable when responsive is false

Recent Posts

  • How to check for ‘IS NOT NULL’ And ‘IS NOT EMPTY’ string in SQL
  • How to auto-scroll or manually to end of div when data is added
  • Filter Rows By Max Date in SQL
  • How to Validate a DateTime in C#?
  • Convert comma separated string into a List in C#

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (243)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (194)
  • How to make some specific word(s) Bold or Underline in ReportViewer (187)
  • How to solve “Response.Redirect cannot be called in a Page callback” for DevExpress Components (183)
  • Confirm before process with ASPxButton in Devexpress (172)

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter

powered by XBlog Plus WordPress Theme