Getting all columns from SQL Table

select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='TableName'

Comments

Post a Comment

Popular posts from this blog

This content database has a schema version which is not supported in this farm

Image
 Today i have faced one issue while mount content database to server. the issue is " This content database has a schema version which is not supported in this farm." I was getting this error when i ran Mount-SPContentDatabase using powershell.  I tried checking SP versions and other things finally got solution in below way Reason: Once you have taken the backup from SharePoint 2013 content database, usually you will restore the database in the target SQL server. After restoring the database, you will try to restore content database in any one of Webapplication most probably new one. In this stage, you will get the above error message. Solution: Your source SQL server schema and the destination SQL server schema might not be matched. So you need to update the "Versions" table values in the "Restored Database". 1. Open " Versions " table from any of the existing "Content database"  from the Target SQL Server machine in ...
Read more

Check current user exists in a group using an AJAX call

$.ajax({     url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/sitegroups/getByName('Site Members')/Users?         $filter=Id eq " + _spPageContextInfo.userId,     type: "GET",     cache: true,     async: false,     headers:{         "ACCEPT": "application/json;odata=verbose"     },     success: function (data) {         if (data.d.results[0] != undefined) {         //user is a member         }     },     error: function () {     } });
Read more

Difference between Application Page and Site Pages

Difference between a Site Page and an Application Page Here we will check what is the difference between a site page and an application page in Sharepoint. There are two types of pages in SharePoint. 1. Site Pages 2. Application Pages Common on them: They both inherit their layout from the same master page. 1. Site Pages: A site page contains text, images, web parts etc and Site pages are stored in the file system. But a end user can create, edit or customized a site page using sharepoint designer or browser. But once an end user modified the site page using SharePoint designer, the template for this page is stored in the content database rather in file system. So every time a user requested the page, the page is retrieved from the content database. At the same time you can also reset to the original template using designer. A site page can contain inline server code, but once it becomes customized it can not contain. A site page can also host features such as dynamic Web ...
Read more