Web API: All about
NodeJS Installation Usage [js] /* users.json { “user1” : { “name” : “mahesh”, “password” : “password1”, “profession” : “teacher”, “id”: 1 }, “user2” : { […]
Software Development
SQL Server: Debug – Why does query statement fail when there is only one record being added to reference table?
Because the query statement is too long, so the next added record may corrupt the query Because the reference table number is limited at 256 […]
SQL Server: Debug – Why can’t I find a stored procedure by SQL Profiler?
Because that stored procedure is executed inside a stored procedure. Stored procedure executed inside a stored procedure is not hit by SQL profiler (?) Because that […]
SQL Server: Debug – How to check temporary table created by INSERT INTO?
Get the table structure by [sql]exec tempdb..sp_help ‘#tempTableName'[/sql]
React Native: How to store data into the local storage of the application?
Use Realm How to see Realm database Install Realm Browser How to know my Realm file path [js] let YourRealmDB = new Realm({schema: [YourSchema]}); console.log(‘YourRealmDB […]
ASP.NET: C# – How to re-arrange rows in a DataTable?
[c] … DataView view = dataTable.DefaultView; // dataTable has [Column 1], [Column 2], [Column X], [Column Y] view.Sort = “[Column 1] DESC, [Column 2] DESC”; […]
SQL Server: How to trace down database activities?
Create trigger to log activities Record actions happening on CREATE/ALTER/DELETE stored proc Create table to save actions happening [sql] CREATE TABLE dbo.ProcedureChanges ( EventDate DATETIME […]
ASP.NET: How does ASP.NET Ajax work?
SYS namespace SYS namespace represents the root namespace for the Microsoft Ajax Library. Sys is not a server side namespace. ASP.NET Ajax registers its clientside […]
SQL Server: How to use SQL Server Profile
How to trace which stored procedures are called Open “Trace Properties” window Select “Event Selection” tab Check “Show all events”, “Show all columns” tab Check […]