Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[uspGetEmployee] @FilterType [nvarchar](50), @FilterValue[nvarchar](50), @startRowIndex int, @maxRows int, @totalRows int out AS BEGIN SET NOCOUNT ON; DECLARE @firstID2 int, @startRow2 int SET @startRow2 = ((@startRowIndex - 1) * @maxRows) + 1 SET ROWCOUNT @startRow2 EXEC('SELECT ' + @firstID2 + ' = EmployeeID FROM Employee where ' + @FilterType + ' like ''%' +@FilterValue + '%'' ORDER BY EmployeeID') SET ROWCOUNT @maxRows EXEC('SELECT EmployeeID, FirstName, LastName, Organization FROM Employee WHERE EmployeeID >= ' + @firstID2 + ' and ' + @FilterType + ' like ''%' +@FilterValue + '%''') SET ROWCOUNT 0 EXEC('SELECT ' + @totalRows + ' = COUNT(EmployeeID) FROM Products where ' + @FilterType + ' like ''%' +@FilterValue + '%''') END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|AJAX ModalPopupExtender will Not Hide in Asp.net||1||57|
|Data organization issue||7||55|
|Need a “no-repeat” transparent background image to cover a webpage. Opacity: 0.4; VS 2012 W/VB.net code behind||7||55|
|Using VS2010 with .NetFramework 4.0, how would you make a multiline textbox appear as a label control?||9||44|
Join the community of 500,000 technology professionals and ask your questions.