ASP DOT NET

Monday, June 11, 2018

Q.How to generates id using char and int in sql server?

select isnull(max(convert(int,substring(Column_Name,5,len(Column_Name)))),0) as Column_Name from Table_Nmae
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to to select duplicate rows from sql server?

 SELECT * FROM Recruitment WHERE Email IN (SELECT Email FROM Recruitment GROUP BY Email HAVING COUNT(*) > 1); WITH CTE AS (     SELECT   ...