From the Oracle docs ROWID Pseudocolumn For each row in the database, the ROWID pseudocolumn returns the address of the row. Oracle Database rowid values contain information necessary to locate a row: The data object number of the object The data block in the datafile in which the row resides The position of the row … Read more
Starting in SQL Server 2017 the STRING_AGG function is available which simplifies the logic considerably: See SQL Fiddle with Demo In SQL Server you can use FOR XML PATH to get the result: See SQL Fiddle with Demo
Update: These articles in my blog describe the differences between the methods in more detail: NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL: SQL Server NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL: PostgreSQL NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL: Oracle NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL: MySQL There are three ways to do such a query: LEFT JOIN … Read more
Does this include: International numbers? Extensions? Other information besides the actual number (like “ask for bobby”)? If all of these are no, I would use a 10 char field and strip out all non-numeric data. If the first is a yes and the other two are no, I’d use two varchar(50) fields, one for the … Read more
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
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
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
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.
For anyone that is still stuck on this issue after trying the above. If you are right-clicking on the database and going to tasks->import, then here is the issue. Go to your start menu and under sql server, find the x64 bit import export wizard and try that. Worked like a charm for me, but … Read more
This should do it: Incorporated Kane’s suggestion, you can compute the phone number’s formatting at runtime. One possible approach would be to use scalar functions for this purpose (works in SQL Server):