Author Archives:
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.