What is tableName.* in SQL
is exactly that same as Where it is useful is in a JOIN, for example:
sql server
Using Excel VBA to run SQL query
Below is code that I currently use to pull data from a MS SQL Server 2008 into VBA. You need to make sure you have the proper ADODB reference [VBA Editor->Tools->References] and make sure you have Microsoft ActiveX Data Objects 2.8 Library checked, which is the second from the bottom row that is checked (I’m using Excel … Read more
SHOWPLAN permission denied in database ‘tempdb’. in sql server 2008
Get an admin to run the following in the tempdb: where <UserName> is your username.
Comma separated results in SQL
Use FOR XML PATH(”) – which is converting the entries to a comma separated string and STUFF() -which is to trim the first comma- as follows Which gives you the same comma separated result Here is the FIDDLE
SQL WHERE.. IN clause multiple columns
You can make a derived table from the subquery, and join table1 to this derived table:
SQL- Ignore case while searching for a string
Use something like this – or
How to select the last record of a table in SQL?
Without any further information, which Database etc the best we can do is something like Sql Server MySql
What are named pipes?
Both on Windows and POSIX systems, named-pipes provide a way for inter-process communication to occur among processes running on the same machine. What named pipes give you is a way to send your data without having the performance penalty of involving the network stack. Just like you have a server listening to a IP address/port … Read more
how to increment integer Columns value by 1 in SQL
My questions is how to increment a column’s value by 1. For example, suppose a column ID has values 1,2,3,4, .. Now when I update this table then ID column should increment by 1, Now ID will become 2,3,4,5, ..
How to connect to a local database in SQL Server Management Studio?
You need to download and install SQL LocalDB. It is a special edition of SQL Server that does not allow remote connection and supports windows integrated authentication only. It is a simple one click MSI install so it is easy to deploy. To download and install SQL Server 2016 Express, go to SQL Server downloads. LocalDB is a … Read more