How to alter column definition in SQL

Alter table test add constraint pk  primary key clustered(USerId)

Comments

Post a Comment

Popular posts from this blog

How to show enlarge image when mouse hover on image or link in Asp.Net(c#) using JavaScript

Image
In this blog i am going to show we could show enlarded image when hover on Link or an image like we see on any e-commerce website.


First of all right click on your application >> Select Add New Folder and Give name as images >> Once folder created place some images in folder to show preview of images when hover on link using JQuery in asp.net.

After completion of folder creation and insertion of images in folder write the following code in your aspx page ::

Put the below code inside the <heaD> tag::
 <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js">
</script>
<script type="text/javascript" language="javascript">
    $(document).ready(function () {
        ShowPreview();
    });
    // Configuration of the x and y offsets
    function ShowPreview() {
        xOffset = -20;
        yOffset = 0;

        $("a.preview").hover(function (e) {
            …
Read more

StateCode and StatusCode Values for mostly used entities in Microsoft Dynamics CRM 2013

In this blog I have given a list of all StateCode and StatusCode of useful entities. Please refer MSDN for more details for any doubt if you have regarding any thing. I also have collected this through MSDN
The following table shows default Microsoft CRM values for StateCode and StatusCode. Each StateCode has its own default StatusCode value. For example, if a Product StateCode is 0 (Active), the default StatusCode is 1 (Active(default)). If the Product StateCode is 1 (InActive), the default StatusCode is 2 (Inactive(default)). Microsoft CRM only accepts StatusCodes that are valid for a particular StateCode.



Entity
Status (statecode)
Status Reason
(statuscode)
Account (account)
0
Active
1
Active
1
Inactive
2
Inactive
Activity (activitypointer)
0
Open
1
Open
1
Completed
2
Completed
2
Canceled
3
Canceled
Read more

How to add custom filter lookup field based on OptionSet field selection in Dynamics CRM.

Image
In this blog I am going to show how we can filter records based on the selected option set value.

For this example I have created an entity and placed 2 fields mainly, One is Option set Field for Region/ Divison and another is Lookup filed of State. So when user will select the region the lookup values will show only filtered records based on the region, copy and paste the code below in your form option set OnChange event which will filter record of lookup.


function FilterPackagesLookup() {
    try {
        preFilterLookup();

    } catch (e) {
        ShowCatchMessage(e.message);
    }

}

function preFilterLookup() {
    try {
        if (Xrm.Page.ui.controls.get("new_state") != "undefined" && Xrm.Page.ui.controls.get("new_state") != null) {
            Xrm.Page.getControl("new_state").addPreSearch(function () {
                addLookupFilter();
            });
        }
    } catch (e) {
        ShowCatchMessage(e.message);
    }
}

fu…
Read more
go to top image