Description:
In this example, we
explain that How to run a more than 8000 characters SQL statement from a
variable? Or varchar (MAX) text cuts off while going more than 8000 characters
inside a procedure. Or how to print the SQL Query when it exceeds the 8000
character. Because the problem was that by default Nvarchar (max) only print
8000 characters so when your query exceeds the 8000 characters at that time
what should you do if you want to debug or print the string sql query.
Description:
In this example, we
explain that How to run a more than 8000 characters SQL statement from a
variable? Or varchar (MAX) text cuts off while going more than 8000 characters
inside a procedure. Or how to print the SQL Query when it exceeds the 8000
character. Because the problem was that by default Nvarchar (max) only print
8000 characters so when your query exceeds the 8000 characters at that time
what should you do if you want to debug or print the string sql query.
Description:
In this example we
explain that how to add double click event on right click using JQuery. Or how
to fire double click event with context menu using JQuery. Or how can I call
double click event with right click context menu in Grid view or Data Table
using JQuery.
As
we all know because by default double click is not fire because of the it will
call context menu event first and when context menu appears then it will not
allow any action on data table or grid view.
Description:
In this example we
explain that how to add double click event on right click using JQuery. Or how
to fire double click event with context menu using JQuery. Or how can I call
double click event with right click context menu in Grid view or Data Table
using JQuery.
As
we all know because by default double click is not fire because of the it will
call context menu event first and when context menu appears then it will not
allow any action on data table or grid view.
Description:
In this example we explain that how to get download
count Day, Month, Year wise in a single query Using SQL Query. Or how to get
download count reports of Day, Month, Year in a single query using SQL Query.
Suppose you have to display some charts or report of
the website viewer or mobile app download count for Day, Moth, Year wise at
that time below SQL Query is useful to get the data.
Description:
In this example we explain that how to get download
count Day, Month, Year wise in a single query Using SQL Query. Or how to get
download count reports of Day, Month, Year in a single query using SQL Query.
Suppose you have to display some charts or report of
the website viewer or mobile app download count for Day, Moth, Year wise at
that time below SQL Query is useful to get the data.
Description:
In this example we explain that how to get all Month
like Jan,Feb, Dec etc.. Using SQL Query.
or how to get download count per month of the year using SQL Query. Or count
records of every month in a year using SQL.or SQL query to get month wise count
and display it on website or chart. or how to get count of month based on a
year using SQL query.
We have requirement like display Month wise download
application count in website. So achieve this below is the SQL Query that will helpful
for you to get month wise download count.
Description:
In this example we explain that how to get all Month
like Jan,Feb, Dec etc.. Using SQL Query.
or how to get download count per month of the year using SQL Query. Or count
records of every month in a year using SQL.or SQL query to get month wise count
and display it on website or chart. or how to get count of month based on a
year using SQL query.
We have requirement like display Month wise download
application count in website. So achieve this below is the SQL Query that will helpful
for you to get month wise download count.
Description:
In this example we explain that how to get all date
of the current month like 1 oct, 2 oct… 31 oct etc.. Using SQL Query. Or how to
get download count per day of the current month day wise using SQL Query.
We have requirement like display day wise download
application count in website. So achieve this below is the SQL Query that will helpful
for you to get daily date wise download count.
Description:
In this example we explain that how to get all date
of the current month like 1 oct, 2 oct… 31 oct etc.. Using SQL Query. Or how to
get download count per day of the current month day wise using SQL Query.
We have requirement like display day wise download
application count in website. So achieve this below is the SQL Query that will helpful
for you to get daily date wise download count.
Description:
In this example we explain that how to store binary
Image in Database in Asp.Net Core. or how to store image in database using .Net
Core. So how to save Images to database using Asp.Net Core.
So here we demonstrate that how to upload file and
save file n a binary format in database using Asp.Net Core. Below is the code
that will help you to save or upload file in database in .net core.
Description:
In this example we explain that how to store binary
Image in Database in Asp.Net Core. or how to store image in database using .Net
Core. So how to save Images to database using Asp.Net Core.
So here we demonstrate that how to upload file and
save file n a binary format in database using Asp.Net Core. Below is the code
that will help you to save or upload file in database in .net core.
Description:
In this example we explain that how to retrieve the
current user logged in to Dynamic 365 CRM.or how to retrieve or get the Logged
In user security Role Name in Dynamic 365 using JavaScript. Or how to get User
security role name from context in Dynamic 365 using JavaScript. Or get security
role name of the Logged In user using JavaScript.
So below is the JavaScript code that will help you
to get the current Logged In user security role name in Dynamic 365.or how to
get All Security Role Names of the Logged In User in Dynamic 365 using
JavaScript.
function GetLoggedInUserSecurityRoleNames() {
// Get Logged
In User Context
var
userSettings = Xrm.Utility.getGlobalContext().userSettings;
// Get Logged
In User Security Roles
var
loggedInUsersecurityRolesGuidArray = userSettings.securityRoles;
var
totalSecurityRolesArray = new Array();
var
allRolesName = "";
if (loggedInUsersecurityRolesGuidArray.length >
0) {
Xrm.WebApi.retrieveMultipleRecords("roles",
"?$select=name,roleid").then(
function
success(result) {
if
(result.entities.length > 0) {
// Push Role
Names and Role Ids to Array
for (var
rolesCount = 0; rolesCount < result.entities.length; rolesCount++) {
totalSecurityRolesArray.push({ RoleName:
result.entities[rolesCount].name, RoleId: result.entities[rolesCount].roleid
});
}
allRolesName = userSettings.userName + " has
the below Security Roles\n------------------------------------\n";
// Compare the User Security Roles with Total
Security Roles
for (var
userSecurityRolesCounter = 0; userSecurityRolesCounter <
loggedInUsersecurityRolesGuidArray.length; userSecurityRolesCounter++) {
for (var
totalsecurityRolesCounter = 0; totalsecurityRolesCounter <
totalSecurityRolesArray.length; totalsecurityRolesCounter++) {
if
(totalSecurityRolesArray[totalsecurityRolesCounter].RoleId.toLowerCase() ==
loggedInUsersecurityRolesGuidArray[userSecurityRolesCounter].toLowerCase()) {
allRolesName
+= totalSecurityRolesArray[totalsecurityRolesCounter].RoleName +
"\n";
break;
}
}
}
}
// Show User Roles
Xrm.Utility.alertDialog(allRolesName, null);
},
function
(error) {
// Show error
Xrm.Utility.alertDialog(error.message, null);
});
}
}
Description:
In this example we explain that how to retrieve the
current user logged in to Dynamic 365 CRM.or how to retrieve or get the Logged
In user security Role Name in Dynamic 365 using JavaScript. Or how to get User
security role name from context in Dynamic 365 using JavaScript. Or get security
role name of the Logged In user using JavaScript.
So below is the JavaScript code that will help you
to get the current Logged In user security role name in Dynamic 365.or how to
get All Security Role Names of the Logged In User in Dynamic 365 using
JavaScript.
function GetLoggedInUserSecurityRoleNames() {
// Get Logged
In User Context
var
userSettings = Xrm.Utility.getGlobalContext().userSettings;
// Get Logged
In User Security Roles
var
loggedInUsersecurityRolesGuidArray = userSettings.securityRoles;
var
totalSecurityRolesArray = new Array();
var
allRolesName = "";
if (loggedInUsersecurityRolesGuidArray.length >
0) {
Xrm.WebApi.retrieveMultipleRecords("roles",
"?$select=name,roleid").then(
function
success(result) {
if
(result.entities.length > 0) {
// Push Role
Names and Role Ids to Array
for (var
rolesCount = 0; rolesCount < result.entities.length; rolesCount++) {
totalSecurityRolesArray.push({ RoleName:
result.entities[rolesCount].name, RoleId: result.entities[rolesCount].roleid
});
}
allRolesName = userSettings.userName + " has
the below Security Roles\n------------------------------------\n";
// Compare the User Security Roles with Total
Security Roles
for (var
userSecurityRolesCounter = 0; userSecurityRolesCounter <
loggedInUsersecurityRolesGuidArray.length; userSecurityRolesCounter++) {
for (var
totalsecurityRolesCounter = 0; totalsecurityRolesCounter <
totalSecurityRolesArray.length; totalsecurityRolesCounter++) {
if
(totalSecurityRolesArray[totalsecurityRolesCounter].RoleId.toLowerCase() ==
loggedInUsersecurityRolesGuidArray[userSecurityRolesCounter].toLowerCase()) {
allRolesName
+= totalSecurityRolesArray[totalsecurityRolesCounter].RoleName +
"\n";
break;
}
}
}
}
// Show User Roles
Xrm.Utility.alertDialog(allRolesName, null);
},
function
(error) {
// Show error
Xrm.Utility.alertDialog(error.message, null);
});
}
}
