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.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
CREATE PROCEDURE [dbo].[Tel_WordReport] ( @tableName varchar(100) = null, @ColumnName1 varchar(100) = null, @Value varchar(100) = null ) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; declare @SQL varchar(500) = null -- NONCLUSTERED INDEX [NIX__UNQ__UID_] DECLARE @Year_Ref smallint SET @Year_Ref = (SELECT [Year_Ref] FROM YEAR_LOOKUP WHERE [Year_no]= YEAR(GETDATE())) SET @SQL = 'SELECT Date,Ref, Comments,SentTo,SentBy,Regarding' SET @SQL = @SQL + ' FROM [' + @tableName + '] ' + ' WHERE [' + @ColumnName1 + '] = ''' + '' + @Value +''''+ ' AND [Year_Ref] =''' + '23 '+'''' SET @SQL = @SQL EXEC (@SQL) END
|SQL Server - executing an agent job from a stored proc||2||25|
|MS SQL BCP Extra Lines Between Records||2||24|
|too many installs coming along with SQL 2016?||1||17|
|SQL Database Restore 2008 R2||1||13|