• sharepointcafenet@gmail.com

Videos

  • How to Host a WCF Service in IIS?

    SharePointCafe Admin

    .

    If you are new to WCF services then please read my earlier blogs. Go through with this link – WCF Tutorial step by step.WCF supports a various way to host a service. In this blog, I will explain about Hosting a WCF Service in IIS. How to host WCF service in IIS? Step 1: Create…

    Read More: How to Host a WCF Service in IIS?

  • Write Power Shell Script to Lock and Unloock a Site in SharePoint 2010

    sharepointcafe

    .

    Below Power Shell Script will Unlock a SharePoint site if it is in locked/read-only.#Region variable declarationWrite-Host “UnLock status started…..”Add-PSSnapin Microsoft.Sharepoint.PowershellSet-SPSite -Identity “<site-url>” -LockState “Unlock”Write-Host “Task completed…..”Read-Host -Prompt “The above error occurred. Press Enter to exit.”For -LockState attribute there are mainly 4 parameters that can be used:Unlock – To unlock site collection and make it available to…

    Read More: Write Power Shell Script to Lock and Unloock a Site in SharePoint 2010

  • Introduction of JSON

    SharePointCafe Admin

    .

    What is JSON? JSON stands for JavaScript Object Notation. JSON is a data exchange format between javascript and server-side languages like JSP, ASP.NET etc. How to write data in JSON format ? Within the script tag, we write JSON data format. Benefit of using JSON JSON is a lightweight data exchange format built into Java…

    Read More: Introduction of JSON

  • SPQuery and SPSiteDataQuery in SharePoint

    SharePointCafe Admin

    .

    Before reading this blog, you may also like to know about CAML Query. You can know about CAML Query in details. In this blog, we will see SPQuery and SPSiteDataQuery.   SPQuery and SPSiteDataQuery in SharePoint 2010   SPQuery – SPQuery can be used to query a single list.   SPQuery query = new SPQuery(); SPSiteDataQuery –…

    Read More: SPQuery and SPSiteDataQuery in SharePoint

  • Important SQL Query asked in Interview

    SharePointCafe Admin

    .

    Important SQL Query asked in InterviewSQL query to check a record in table, if exist then insert else update the record. BEGIN  IF EXISTS (SELECT * FROM [users] WHERE email=@email)    UPDATE [users] SET updated_date = GETDATE() WHERE email=@emailELSE    INSERT INTO [users] (uid,first_name,last_name,email,password,gender,is_active,reg_date) VALUES (NEWID(),@fname,@lname,@email,@password,@gender,1,GETDATE())ENDStored procedure to return id of last inserted record:@id int…

    Read More: Important SQL Query asked in Interview

Archives

Follow Us On

Subscribe to my news letter

    Must Read Articles

    RSS
    Facebook
    Twitter
    YouTube
    YouTube
    Instagram