• Register

Questions by miki

0 votes
1 answer 43 views
0 votes
1 answer 16 views
0 votes
1 answer 48 views
0 votes
1 answer 31 views
0 votes
2 answers 16 views
0 votes
2 answers 64 views
0 votes
1 answer 14 views
asked Dec 23, 2020
0 votes
1 answer 23 views
Difference between char and varchar in SQL server I want to know the more interesting difference between char and varchar.
asked Dec 5, 2020
0 votes
1 answer 14 views
0 votes
1 answer 49 views
Get month and year from the date in SQL I need to access the only month.year from the date field in SQL Server. Any idea?
asked Dec 5, 2020
0 votes
1 answer 343 views
Convert Julian date to calendar date in SQL I have searched but I can't seem to find a way to convert Julian to yyyy-mm-dd.
asked Dec 3, 2020
0 votes
1 answer 46 views
String or binary data would be truncated SQL Server When I tried to add data to a newly created column using SQL Server Management Studio, I got the error above. I need help to solve the problem.
asked Dec 1, 2020
0 votes
1 answer 38 views
The login is from an untrusted domain and cannot be used with Windows authentication. Whenever I try to connect to a SQL server database, I get this error. Can you give me some advice?
asked Dec 1, 2020
0 votes
1 answer 39 views
I can not access my database in MySQL. Any idea?
asked Nov 28, 2020
0 votes
1 answer 45 views
This is incompatible with sql_mode=only_full_group_by I installed a new version of SQL, and I received this error message. How can I fix it?
asked Nov 27, 2020
0 votes
1 answer 61 views
SQL check if record exists before insert I need to write a stored procedure to update a row. If the row does not exist, I need to insert it. Any Idea?
asked Nov 26, 2020
0 votes
1 answer 46 views
String or binary data would be truncated in SQL I have the error when I am inserting a row in SQL. Any idea?
asked Nov 25, 2020
0 votes
1 answer 20 views
SQL query between two dates and times I need to select the records between two specific dates and times. Any idea?
asked Nov 25, 2020
0 votes
1 answer 32 views
I received an error message when converting data type varchar to numeric I imported data into VARCHAR column to check correct character types before moving into the destination table. I ran across some decimal values they could not CAST or CONVERT even though they ... values. I received the message "Error converting data type varchar to numeric.” How can I load these problems values?
asked Nov 24, 2020