Tag Info

New answers tagged

1

Use: A foreign data wrapper like odbc_fdw or tds_fdw (see foreign data wrappers list, foreign data wrapper documentation); or dbi-link - see github repo


1

In the folder %APPDATA%\Microsoft\Microsoft SQL Server\110\Tools\Shell you should find a file named RegSrvr.xml. That's the file where Management Studio stores local registered servers. If the file is missing or corrupt, SSMS won't display anything. In this case, you can create a new file and paste this: <?xml version="1.0"?> <model ...


1

try something like this.. DECLARE @MyTable AS TABLE ( [Month] INT, Salary INT ); INSERT INTO @MyTable VALUES (1,2000), (1,3100); SELECT [Month], STUFF(( SELECT ',' + CONVERT(NVARCHAR(30),Salary) from @MyTable WHERE Month = out.Month FOR XML Path('')) ,1,1,'') csv FROM @MyTable out GROUP BY Month;


0

select * from invoice where invoicedata not like '%invoice%' or invoicedata not like '%this%'


1

Full text search is a richer way of indexing complex strings. I know your case does not contain prose but FTS may still work for you. As an alternative to wildcard search you could split your concatenated values into their separeate parts. There are many ways to achieve this; reading this link will lead you to one that suits. Then you can treat your data ...


3

Its not too difficult to build a query that does it. First create a query that joins on a table using LIKE with wildcards. Then exclude everything from this query. To see what I mean, see this simple example: http://sqlfiddle.com/#!6/619fb/2 Or alternately I have reproduced an example here: --Create tables for comparing data CREATE TABLE Invoice ( ...


1

To connect to SSMS they need the CONTROL SERVER permission. No, that is not true at all. I hope you didn't learn that from any documentation, blog post or presentation. If you did, you should tell us where, so we can hunt them down and correct it. In order to connect, they need to be a member of the public role (granted by default to all logins). To do ...


0

Try this SELECT * FROM [MyDSN].[default].[Table].[name] You must separate the schema "Table" from the table name "name". If you wrap those together like this [Table.name] it won't works.


0

To fix this problem is very simple Fix/Workaround/Solution for Microsoft SQL Server, Error :4064 # First click on Option>> Button of “Connect to Server” Prompt. Now change the connect to database to any existing database on your server like master or msdb. Now click on connect and it will successfully log you in. Once you login in the system run ...


0

In windows authentication, you don't have to type the password, it will validate by AD. The reason for Login error could be your login does not have access to the database server. Please ask the database administrator to grant access to your login.


0

As Pablo Montilla mentioned in a comment on the question, I should have added a code sample to indicate that I was using Dapper. (I have since added the sample.) The solution was to pass an argument to Dapper's Query method to tell it not to buffer all of the results before letting me iterate over them. The default behavior of Dapper is to buffer the ...



Top 50 recent answers are included