How to query the name of the current SQL Server database instance?
SELECT DB_NAME() Returns the database name.
ssms
SQL Management Studio – Execute current line
In options you can configure line numbers to be displayed, then you can just click on a line number, which will highlight the whole line.
SQL Server Management Studio 2012 – Export all tables of database as csv
The export wizard allows only one at a time. I used the powershell script to export all my tables into csv. Please try this if it helps you. $server = “SERVERNAME\INSTANCE” $database = “DATABASE_NAME” $tablequery = “SELECT s.name as schemaName, t.name as tableName from sys.tables t inner join sys.schemas s ON t.schema_id = s.schema_id” #Delcare … Read more
Microsoft SQL Server Management Studio closes immediately after startup
Step 1: Just delete this file: C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\Platform\Microsoft.VisualStudio.MinShell.Interop.pkgdef Alternatively, rename the file so it does not have the .pkgdef extension. Step 2: Optionally, you can remove the following Windows Registry Key (created at SSMS 18 startup using the .pkgdef file mentioned above): HKEY_CURRENT_USER\SOFTWARE\Microsoft\SQL Server Management Studio\18.0_IsoShell_Config\RuntimeConfiguration\dependentAssembly\bindingRedirection\{8BC7AF31-B6DA-4B97-8B36-F0500DECB147}
What’s the difference between SQL Server Management Studio and the Express edition?
There are no differences in Management Studio. The differences are in the database engine LIMITATIONS! The engine is the same but it will deny you some features. Import/Export wizard in the express edition can be found at: C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe If you dont have it, dowload it from Microsoft: http://go.microsoft.com/fwlink/?LinkId=65111 You could install the … Read more
How to insert a NEWID() / GUID / UUID into the code editor?
NEWID() itself is a function. when called returns a GUID value. You do not have to put it in a separate window and then copy paste value from there. Just simply put that function there where you want the GUID value and when the query is executed at run time the value returned by this … Read more
SQL Server Management Studio Skin / Appearance / Layout
I decided to try something simple on SSMS 2012: Go to http://studiostyl.es/ Pick a theme and download it Follow these screenshot instructions Note that doing this will only affect the theme of the text editor, not the toolbar, menu, object explorer window, etc.
In SQL Server Management Studio what is SQLCMD mode?
I did some more research, so here’s my understanding of this to extend what has been written so far: What is SQLCMD SQLCMD.exe is a console utility included in the instalation of SQL Server 2005 and higher. You can typically find it in a path like c:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE. It is a simple scripting … Read more
How to word wrap in SQL Server Management Studio
Just enable it through the options. Tools Options Text Editor All Languages Settings – Check Word Wrap
How to connect to LocalDb
I am totally unable to connect to localdb with any tool including MSSMA, sqlcmd, etc. You would think Microsoft would document this, but I find nothing on MSDN. I have v12 and tried (localdb)\v12.0 and that didn’t work. Issuing the command sqllocaldb i MSSQLLocalDB shows that the local instance is running, but there is no … Read more