Simply Learn Technologies

Search This Blog

Links

Welcome
About Me
Projects
More…
Posts

Welcome
About Me
Projects
Posts

Welcome
About Me
Projects
Posts

Write and Run C# online

June 08, 2016

Write your C# code online and run it by using .net Fiddle

visit: https://dotnetfiddle.net/

Get link
Facebook
X
Pinterest
Email
Other Apps

Labels

C#

Labels: C#

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Post a Comment

Getting Highest Entered Records from the Table (SQL Server)

December 27, 2022

If you want to get the highest entered records (transactions) in the current month you may write the query below select top 1 CourseID,count(*) as forms from dataform where month(DataFormDate)=MONTH(GETDATE()) group by CourseID order by forms desc when you want more than one records change the top 1 to the desired numbered.

Get link
Facebook
X
Pinterest
Email
Other Apps

Post a Comment

Convert Array to Comma Seprated String

June 10, 2016

If you have an array of Integers and want to convert it into comma separated string. here is the following code //integer Array int[] arr = new int[5] {1,2,3,4,5}; string arrvalue= string.Join(",", arr); results will be arrvalue= "1,2,3,4,5"

Get link
Facebook
X
Pinterest
Email
Other Apps

Post a Comment

Generate Random GUID (Uniqueidentifer) in SQL Server

June 08, 2016

To generate GUID (Uniqueidentifier) you can use this. SQL: select NEWID() Update Records which has null values in GUID Field with new guids SQL: update [YourTableName] set [YourColumnName]=NEWID() where [YourColumnName] is Null

Get link
Facebook
X
Pinterest
Email
Other Apps

Post a Comment

Labels

Array
Array to String
C#
DateTime
GUID
SQL
Uniqeidentifier

Report Abuse

Powered by Blogger

Simply Learn Technologies

Write and Run C# online

Labels

Comments

Post a Comment

Popular posts from this blog

Getting Highest Entered Records from the Table (SQL Server)

Convert Array to Comma Seprated String

Generate Random GUID (Uniqueidentifer) in SQL Server