asp.net codes

Thursday, May 28, 2020

hide the jquery validationEngine closePrompt error message

›
 $.validationEngine.closePrompt(".formError", true);
Sunday, January 19, 2020

Find Column Name From All Tables of Database

›
SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c...
Monday, December 30, 2019

TOP 5 ITEMS FROM EACH CATEGORY

›
;with Rohi  as (  select GlobalCodeName ,sortorder,GlobalCodeCategoryID,  ROW_NUMBER() OVER (PARTITION BY GlobalCodeCategoryID order by...

usage of ntile

›
CREATE TABLE ntile_usage ( ID INT NOT NULL ); INSERT INTO ntile_usage(ID) VALUES(1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(...

Group by with use CUBE, ROLLUP AND GRUPING SETS

›
CREATE TABLE Sales ( Country varchar(50), Region varchar(50), Sales int ); INSERT INTO sales VALUES (N'Canada', N'Alberta...
›
Home
View web version
Powered by Blogger.