Author Archives: Manish Gupta

WebForms UnobtrusiveValidationMode requires a ScriptResourceMapping for ‘jquery’. Please add a ScriptResourceMapping named jquery(case-sensitive).

Specifies how ASP.NET globally enables the built-in validator controls to use unobtrusive JavaScript for client-side validation logic. Type: UnobtrusiveValidationMode Default value: None Remarks: If this key value is set to “None” [default], the ASP.NET application will use the pre-4.5 behavior (JavaScript inline in the pages) for client-side validation logic. If this key value is set […]

How to concatenate row data by comma in sql?

How to concatenate row data by “,” in sql? DECLARE @Account_Num VARCHAR(7500) = ” CREATE TABLE #tempData ( AccountNo VARCHAR(20) ) INSERT INTO #tempData SELECT ‘123456’ UNION SELECT ‘89105’ UNION SELECT ‘32587’ UNION SELECT ‘98587’ SELECT @Account_Num += COALESCE(‘,’, @Account_Num) + AccountNo FROM #tempData SET @Account_Num = SUBSTRING(@Account_Num, 2, LEN(@Account_Num)) SELECT @Account_Num Result: 123456,89105,32587,98587

how to copy directory using sql server

DECLARE @Query VARCHAR(8000) SET @Query = ‘xcopy “{Source  Directory Path}\*.*” “{Destination Directory Path}\” /e /i /h /y ‘ PRINT @Query EXEC master.dbo.xp_cmdshell @Query Where “*.*” Copy all directory and file in source path. “/e” Copies directories and sub directories, including empty ones. Same as /S /E. May be used to modify /T. “/i” If destination does not […]

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)). Open Run Enter DCOMCNFG Append Component Service Then Computers Then My Computers Then DCOM Config Then From the DCOM Config List right click on “Microsoft Excel Application” Go to Security Tab […]

you do not have permission to use the bulk load statement. sql server

expand sql server instance you are connecting to expand security highlight login that needs to be changed right click – properties In the properties pane select “Server Roles”. Check “bulkadmin” permission from right hand list. Click Ok

microsoft office excel cannot access the file there are several possible reasons

Create directory “C:\Windows\SysWOW64\config\systemprofile\Desktop ” (for 64 bit Windows) or “C:\Windows\System32\config\systemprofile\Desktop ” (for 32 bit Windows) Set Full control permissions for directory Desktop (for example in Win7 & IIS 7 & DefaultAppPool set permissions for user “IIS AppPool\DefaultAppPool”)

invalid use of a side-effecting operator ‘insert’ within a function. sql server

User-defined functions cannot be used to perform actions that modify the database state. “Modify the database state” includes changing any data. You should be using a stored procedure, not a function

difference between union and union all

UNION  Union gives distinct records or entries from all table. SELECT dbA, dbB FROM tbl1 UNION SELECT dbA, dbB FROM tbl2 UNION ALL Union All gives all records from tbl1 and tbl2 SELECT dbA, dbB FROM tbl1 UNION ALL SELECT dbA, dbB FROM tbl2  

how to rebuild index in sql server

Index Rebuild  process drops the existing Index and Recreates the index. ALTER INDEX ALL ON [dbName].[tblName] REBUILD Index Reorganize process physically reorganizes the leaf nodes of the index. ALTER INDEX ALL ON [dbName].[tblName] Reorganize

unable to ping pc

Set Windows Firewall to allow ICMP replies from the mmc, or type “netsh firewall set icmpsetting 8” from the command line.