Get all active SPIDs for a database
SELECT d.name , CONVERT (SMALLINT, req_spid) AS spid FROM master.dbo.syslockinfo l , master.dbo.spt_values v , master.dbo.spt_values x ,
SELECT d.name , CONVERT (SMALLINT, req_spid) AS spid FROM master.dbo.syslockinfo l , master.dbo.spt_values v , master.dbo.spt_values x ,
There is a very good sample libraries available by google. [google-gdata][1] You can go through all these example, but for my scenario, I have need only 3 assembles from the core project. 1. Google.GData.Client.dll 2. Google.GData.Extensions.dll
Below is a simple **CTE (Common Table Expression)** Example to retrieve all descendant categories from Category table. WITH Categories AS ( SELECT C.ParentCategoryID , C.CategoryID ,
- Run Windows PowerShell ISE in administrator mode. - Enter and run the following PowerShell cmdlets hitting enter after each line:
DECLARE @CustomerId int , @Email VARCHAR(500) DECLARE db_cursor CURSOR FOR