Come-at-able

Use the following queries to find the column name from the tables from the database. SELECT table_name=sysobjects.name, column_name=syscolumns.name FROM sysobjects JOIN syscolumns ON sysobjects.id = syscolumns.id WHERE sysobjects.xtype=’U’ AND syscolumns.name like ‘FirstName’ ORDER BY sysobjects.name,syscolumns.colid SELECT table_name=sysobjects.name, column_name=syscolumns.name, datatype=systypes.name, length=syscolumns.length FROM sysobjects JOIN syscolumns ON sysobjects.id = syscolumns.id JOIN systypes ON syscolumns.xtype=systypes.xtype WHERE sysobjects.xtype='U' and syscolumns.name='CARDNAME' ORDER BY sysobjects.name,syscolumns.colid

Suppose you have List of record from a table and you need the rownumber for each row you can use this below query: row_number() OVER (ORDER BY [Project2].[case_no] ASC) AS [row_number]

If you have some scenario where you need to add where clause based on some condition. for example: GradeID     MinMark   MaxMark    Grade 1           0          0          A 2           0          10         B 3           11         20         C 4           21         NULL       D As per above table we need Grade based on parameter @Mark to be checked as per the ...