Posts by José Diz • 6,942 points
305 posts
-
1
votes2
answers4115
viewsA: Query returning error in query between date period
Octavio, the error message indicates line 27 but in the code you transcribed there are 14 lines... If column V.DATA is declared as datetime, it seems to me that the cause is related to the session…
-
2
votes2
answers2202
viewsA: Update of several records together with select
William, the topic is marked with Mysql and SQL Server tags. As you know, not always does an SQL build work on all sgbd. In T-SQL (SQL Server) the solution can be simplified to something like --…
-
3
votes5
answers19374
viewsA: How to check if a field of type text or ntext is null or empty?
To test the proposed solutions, the following table was created: use tempDB; CREATE TABLE DocumentNotes (Subject varchar(50), Notes ntext); INSERT into DocumentNotes values (1, space(1)), (2, N''),…
-
-1
votes3
answers219
viewsA: operation with data sqlserver
Ivan, to calculate the difference between dates, use the function Datediff. Regarding the percentage calculation, aware that, in T-SQL, the operator / It has variable behavior, and can be entire…
-
-1
votes1
answer345
viewsA: My Sqlserver Express 2014 does not show all installation options
Pablo, the Express edition of SQL Server 2014 is available in different packages: Express (SQLEXPR): includes only the database mechanism of the SQL Server; Express with Tools (SQLEXPRWT): contains…