|
- 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,
- How do I rename a column in a database table using SQL?
151 If I wish to simply rename a column (not change its type or constraints, just its name) in an SQL database using SQL, how do I do that? Or is it not possible? This is for any database claiming to support SQL, I'm simply looking for an SQL-specific query that will work regardless of actual database implementation
- Login to Microsoft SQL Server Error: 18456 - Stack Overflow
I am getting this error while trying to connect to the SQL Server Microsoft SQL Server Error: 18456 Can anybody tell me what the error code means?
- SQL Server Insert if not exists - Stack Overflow
Hello @Jay, if I'm not wrong, "ON DUPLICATE KEY" only works in MySql, and not SQL Server
- how do I query sql for a latest record date for each user
To get the latest record date along with the corresponding value for each user, you can use a subquery or a common table expression (CTE) in SQL Here’s a solution using a CTE (if your SQL environment supports it):
- SQL Error: ORA-00942 table or view does not exist
I use SQL developer and i made a connection to my database with the system user, after I created a user and made a another connection with that user with all needed privileges But when I try to p
- How to run SQL script in MySQL? - Stack Overflow
I want to execute a text file containing SQL queries, in MySQL I tried to run source Desktop test sql and received the error: mysql> \home\sivakumar\Desktop\test sql ERROR: Failed to open f
- How do I query for all dates greater than a certain date in SQL Server . . .
How do I query for all dates greater than a certain date in SQL Server? Asked 13 years, 1 month ago Modified 2 years, 7 months ago Viewed 2 1m times
|
|
|