Converting a string to Query in SQL Server

declare @a varchar(20)
declare @qry nvarchar(200)
set @a = '235,236,237'
set @qry = N'select * from students where stdID in (' + @a + ')'
exec sp_executesql @qry

Comments

Post a Comment

Popular posts from this blog

SharePoint 2010 Migration Woes: Importing and exporting lists template between different SP2010 Servers

Image
Migrations of SharePoint contents from one server to another can be a big PITA. Once I came across a  scenario  where I had to export a couple of lists from SharePoint online i.e. Office 365 to the SharePoint 2010 on my local server.  What I did is to copy the required lists along with content by creating a list template i.e. via .stp file. Then I upload it to my local SharePoint 2010 server's list template gallery. Later I  successfully  created a new list with the uploaded template. For that I took the following steps: Open your SharePoint site in the SharePoint designer 2010. Select Lists and libraries. Select you desire list and the click on the "Save as Template" from the ribbon. You'll be redirected to the SharePoint site and there after filling in the required fields and pressing OK , .stp will be created. This template can be viewed in Site Action -> Site Setting -> Galleries ->List Template. Select the list template and then from ...
Read more

Per-user throttling in SharePoint Online: a Recipe for getting blocked in SharePoint Online and way to Avoid it

Image
Suppose you have a CSOM or REST API based code that connects with your SharePoint online Site.  This code tends to update several fields including metadata of a number of files in a document library in complex manner.  Or  Try, for instance, creating site collection in Pnp Powershell using "New-SPOSite" serveral times.  Or  Someone decides to Load test SharePoint Online site.  These are some of the use cases as well which you can can find on Miscrosoft documentation given in the rederence below.  Now you will notice, if you run into aforementioned situation, at certain point that SharePoint Online will return HTTP status code 429 i.e. Too many requests or 503 i.e. Server Too Busy (an HTTP response status 503 on Windows server means Service Unavailable.) and requests will result in failure. Furthermore, if one continues with one's transgressions i.e. keeps on running the script, as warned by Microsoft, the script will eventually exceed it...
Read more

SharePoint Online: Elevated Permissions....with love

Image
Remember the good old days! when using RunWithElevatedPrivileges(SPSecurity.CodeToRunElevated), in the SharePoint server-side object model, would let us run our code (Full trust code) with full control i.e. granting us higher permission (as System Account) and letting us performs tasks that waren't permited to do in current user context.  Now, that, we have SharePoint addin and SharePoint online webparts, one still wonders if there is still a way of achieving that. Since there are use cases where a user needs a higher permission, for instance.  Changing a status of a field in a list where the current logged in user has read only permission.  Reading member of a SharePoint group.  In Workflows  like SharePoint Designer workflow you used to have App step, in Nintex workflow you have elevated permission and in MS Flow Impersonation is possible using connectors in Flow triggered by HTTP request can run under System account as show in the video below:  Other wa...
Read more