Everything you need to know about backup and disaster recovery with AWS, for FREE!
Dim commandText As String = "DECLARE @investor varchar(10), @sql varchar(1000) " commandText += "SELECT @investor = '69836', " commandText += "@sql = 'SELECT * FROM OPENQUERY(db, ''SELECT * FROM table1 " commandText += "WHERE investor = ' + @investor + ' '')' EXEC(@sql)" Dim query As SqlCommand = New SqlCommand(commandText, conn)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Use SSRS to email customers?||4||29|
|Question on sending emails using SQL Server 2008 R2 database mail||10||57|
|SQL Job Failed||6||31|
|SQL 2008 - Find rows where only a specified field value exists for all rows with the same ID||7||17|
Join the community of 500,000 technology professionals and ask your questions.