SQL Server Interesting Fact

-
Just try out this

DECLARE @ AS INT
SET @= 6
PRINT @

What you think by looking code?
Isn't it throw an error....but
that's true internally '@' is treated as variable so it will show you output as normal variable.
Just try it..

Comments

Post a Comment

Popular posts from this blog

TFS API: Get list of associated work item from work item of any type

-
I have been observing most of users reported and looking for a way to list out associated work item linked to parent work item. Generally, when we associated work item to another work item - it simply attach it as Link irrespective link type. We can achieve this using TFS Client Side Object model (API). Below is high level code snippet which will fetch all the links associated with work item. // Connect to the server and the store.  TfsTeamProjectCollection  teamProjectCollection = new TfsTeamProjectCollection(collectionUri); //Get the work item service workItemStore = (WorkItemStore)teamProjectCollection.GetService(typeof(WorkItemStore)); // Define a query that uses a variable for the type of work item.  string queryString = string.Format("Select * From WorkItems where Id = {0}",workItemId); // Create and run the query. Query query = new Query(workItemStore, queryString); WorkItemCollection results = query.RunQuery(); foreach(WorkItem wt in results) { ...
Read more

Associate Test Case Automation using TFS API

-
Hello, I have been observing most of users reported that associating automation to test case one by one from Visual Studio Team Explorer is tedious job rather time consuming. I was thinking what if we could achieve this using TFS object model. My idea was fetch test case one by one and associate automation to test case and save test case work item. Resolution: Here is code which can use to associate automation in bulk -  Add below references -  Microsoft.TeamFoundation Microsoft.TeamFoundation.Client   Microsoft.TeamFoundation.WorkItemTracking.Client Microsoft.TeamFoundation.WorkItemTracking teamprojectCollection = TfsTeamProjectCollectionFactory.GetTeamProjectCollection(collectionUri); workItemStore = projectCollection.GetService<WorkItemStore>(); //You can either specify work item query to fetch test cases WorkItemCollection workItemCollection = workItemStore.Query(      " SELECT * FROM WorkItems " +      " WHE...
Read more

How To: Bulk upload Test Case results to Microsoft Test Manager

-
Problem Definition: Most TFS or Microsoft Test Manager users find it difficult to update test execution result to MTM. Assume that you are done with 100+ test case execution manually and now you want to upload results (Pass/Fail/Block) for all those test cases and also link bugs, test cases to result as needed. Doing this manually is very time consuming. At this time there is no way to support this ask in MTM versions but yes, we can achieve this by writing our own code using TFS SDK APIs. Resolution: I came along with this issue some time back and created a tool using TFS APIs which upload results to MTM very smoothly. Here is how my tool works:   1. Run tool exe  2. Connect to team foundation server you want to  3.  Select test plan -> Test Suite  4. Click Get Test Case button  5. This will create excel with test cases from selected test suite.  6. There is filter if you want to upload results specifically for manual or automated or all...
Read more