To add server using sp_addlinkedserver
I got it. It worked fine Thank you for your help:
sql server
SQL datetime compare
Even though in Europe and everywhere in the world it makes perfect sense to use the month as the second of three items in the date. In the US and in this case, apparently, SQL’s date time is MM.DD.YYYY, so you’re going for the 15th month and 18th month Therefore you should use or
SQL: IF clause within WHERE clause
Use a CASE statementUPDATE: The previous syntax (as pointed out by a few people) doesn’t work. You can use CASE as follows: Or you can use an IF statement like @N. J. Reed points out.
How do I fix the error ‘Named Pipes Provider, error 40 – Could not open a connection to’ SQL Server’?
Solving this problem is very easy: Go to control panel. search for services. Open Local services window from your search results Restart your MSSQLSERVER service. Screenshot of the steps:
How do I format a number with commas in T-SQL?
In SQL Server 2012 and higher, this will format a number with commas: You can also change 0 to the number of decimal places you want.
sql query to return differences between two tables
IF you have tables A and B, both with colum C, here are the records, which are present in table A but not in B: To get all the differences with a single query, a full join must be used, like this: What you need to know in this case is, that when a record can be found in A, but not in B, … Read more
SQL Server Linked Server Example Query
The format should probably be: For example: DatabaseServer1.db1.dbo.table1 Update: I know this is an old question and the answer I have is correct; however, I think any one else stumbling upon this should know a few things. Namely, when querying against a linked server in a join situation the ENTIRE table from the linked server will likely be downloaded … Read more
SQL – WHERE (X, Y) IN (A, B)
Why not something simple like the following? WHERE (X = 1 AND Y = 2) OR (X = 5 AND Y = 6) … Or, if you’re looking for rows (based on your example) where Y should be X + 1, then: WHERE Y = X + 1 If you have thousands of OR clauses like the … Read more
SQL Server: Error converting data type nvarchar to numeric
You might need to revise the data in the column, but anyway you can do one of the following:- 1- check if it is numeric then convert it else put another value like 0 2- select only numeric values from the column
How do I fix the multiple-step OLE DB operation errors in SSIS?
Take a look at the fields’s proprieties (type, length, default value, etc.), they should be the same. I had this problem with SQL Server 2008 R2 because the fields’s length are not equal.