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.
Create Procedure [dbo].[sp_***]( @subdomain_name nvarchar(15), @city nvarchar (25), @state nvarchar (2), @email nvarchar (50) ) AS DECLARE @count int DECLARE @totalCount int SELECT @totalCount = count(*) from navSystemA SET @count = 0 WHILE @count <= @totalCount BEGIN SET @cmd = N'INSERT INTO navSystemAMap (storeID, navID, active) VALUES (select count(*) from navSystemA)+ 1, @count, 1)' SET @parameters ='@subdomain_name nvarchar(15)' EXEC sp_executesql @cmd, @parameters, @subdomain_name SELECT @count = @count - 1 END GO
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Loop through SQL parameters and insert to temp table?||4||53|
Conver SQL Server 2008 R2 from sql_latin1_general_cp1_ci_
|too many installs coming along with SQL 2016?||1||28|
|Change this SQL to get all nodes||3||37|