|
- What is the difference between varchar and nvarchar?
An nvarchar column can store any Unicode data A varchar column is restricted to an 8-bit codepage Some people think that varchar should be used because it takes up less space I believe this is not the correct answer Codepage incompatabilities are a pain, and Unicode is the cure for codepage problems With cheap disk and memory nowadays, there is really no reason to waste time mucking
- SQL Server Configuration Manager cannot be found
After installing SQL Server 2008, I cannot find the SQL Server Configuration Manager in Start SQL Server 2008 Configuration Tools menu What should I do to install this tool?
- sql - How do I limit the number of rows returned by an Oracle query . . .
Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: select * from sometable order by name limit 20,10 to get the 21st to the 30th rows (s
- How to fix SQL Server 2019 connection error due to certificate issue
To improve the answer, let me sum up the comments: While setting TrustServerCertificate=True or Encrypt=false in the connection string is a quick fix, the recommended way of solving this issue is to provide a proper certificate for your SQL Server from a trusted CA To install a certificate for a single SQL Server instance (source): In SQL Server Configuration Manager, in the console pane
- How do I fix the error Named Pipes Provider, error 40 - Could not open . . .
I can't seem to connect to my database from a site I get this error: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server I tried using the local IP address to connect as
- How to split strings in SQL Server - Stack Overflow
I have the following input: Data ----- A,10 A,20 A,30 B,23 B,45 Expected output: col1 Col2 ---- ----- A 10 A 20 A 30 B 23 B 45 How can I split the string to produce the
- How to find server name of SQL Server Management Studio
I installed Microsoft SQL Server 2008 When I start SQL Server Management Studio (SSMS), I get the Connect to Server login window with a blank textbox for Server name I have tried a lot of names,
- Format SQL in SQL Server Management Studio - Stack Overflow
In Visual Studio amp; other IDEs, you can easily auto format your code with a keyboard shortcut, through the menu, or automatically as you type I was wondering if there is yet a way to enable this
|
|
|