How to set a default value for an existing column
This will work in SQL Server: ALTER TABLE Employee ADD CONSTRAINT DF_SomeName DEFAULT N’SANDNES’ FOR CityBorn;
sql-server
Is there a Boolean data type in Microsoft SQL Server like there is in MySQL? [duplicate]
You could use the BIT datatype to represent boolean data. A BIT field’s value is either 1, 0, or null.
How to rename a table in SQL Server?
To rename a table in SQL Server, use the sp_rename command: exec sp_rename ‘schema.old_table_name’, ‘new_table_name’
Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AS” in the equal to operation
I do the following: …WHERE fieldname COLLATE DATABASE_DEFAULT = otherfieldname COLLATE DATABASE_DEFAULT Works every time. 🙂
Does a foreign key automatically create an index?
A foreign key is a constraint, a relationship between two tables – that has nothing to do with an index per se. But it is a known fact that it makes a lot of sense to index all the columns that are part of any foreign key relationship, because through a FK-relationship, you’ll often need … Read more
Get list of databases from SQL Server
Execute: SELECT name FROM master.sys.databases This the preferred approach now, rather than dbo.sysdatabases, which has been deprecated for some time. Execute this query: SELECT name FROM master.dbo.sysdatabases or if you prefer EXEC sp_databases
What is the use of GO in SQL Server Management Studio & Transact SQL?
It is a batch terminator, you can however change it to whatever you want
How do you specify a different port number in SQL Management Studio?
127.0.0.1,6283 Add a comma between the ip and port
Cannot Connect to Server – A network-related or instance-specific error
I found the following techniques helpful: Make sure your database engine is configured to accept remote connections: Start > All Programs > SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration Click on Surface Area Configuration for Services and Connections Select the instance that is having a problem > Database Engine > … Read more
SQL Client for Mac OS X that works with MS SQL Server [closed]
Let’s work together on a canonical answer. Native Apps SQLPro for MSSQL Navicat Valentina Studio TablePlus Java-Based Oracle SQL Developer (free) SQuirrel SQL (free, open source) Razor SQL DB Visualizer DBeaver (free, open source) SQL Workbench/J (free, open source) JetBrains DataGrip Metabase (free, open source) Netbeans (free, open source, full development environment) Electron-Based Visual Studio … Read more