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