sql

[Solved] How to pass parameters to SqlDataAdapter

by

here is an example of what you can use and how to pass Parameters you have to make the changes where necessary Public Shared Function GetCustomerInfo(stardate As DateTime, enddate As DateTime, Department As String, Active as String, Visits as Int33) As List(Of String) Dim cszList = New List(Of String)() Dim DSCityStateZipLookup As New DataSet() ‘load … Read more

[Solved] add 3rd table to left join

by

Try this: SELECT users2.* FROM users2 LEFT JOIN user_location2 ON user_location2.uid = users2.id LEFT JOIN users_like ul ON ul.uid1 = users2.id WHERE ( 3959 * acos( cos( radians(28.547800068217) ) * cos( radians( `lat` ) ) * cos( radians( `lon` ) – radians(-82.726205977101) ) + sin( radians(28.547800068217) ) * sin( radians( `lat` ) ) ) ) … Read more

[Solved] SQL Access ” Count “? [closed]

by

You can’t use Count as it will do just that – count the number of records for each Name ignoring the value of tap. But you check for the values of tap and sum these matches. However, while SQL Server returns 1 for a match, Access returns -1, thus – for a universal solution – … Read more

[Solved] Is there any way to calculate age of a person based on DOB and quarter of the provided year sql server? [closed]

by

Using DATŠ•DD() and DATEPART() is an option: SELECT DOB FROM (VALUES (CONVERT(date, ‘19971207’)), (CONVERT(date, ‘19700607’)), (CONVERT(date, ‘19771207’)), (CONVERT(date, ‘19971108’)) ) d (DOB) WHERE DATEPART(year, DATEADD(year, 50, DOB)) = 2020 AND DATEPART(quarter, DATEADD(year, 50, DOB)) = 2 Result: DOB 1970-06-07 0 solved Is there any way to calculate age of a person based on DOB and … Read more

[Solved] How to generate view from Monthly data in rows converting it to columns in Oracle tables

by

The basic pattern you want is to have a case expression for each month, and only show the amount if the monthmatches: select account, day, center, entity, year, frequency, case when month=”Jan” then amount end as jan, case when month=”Feb” then amount end as feb, case when month=”Mar” then amount end as mar, — … … Read more

[Solved] Update PHP statement [closed]

by

you are not connecting to database. you variables are strings. change this $conn = mysql_connect(“$DB_HostName”, “$DB_User”, “$DB_Pass”) to $conn = mysql_connect($DB_HostName, $DB_User, $DB_Pass) and your update is wrong . you have to use math part outside the query, try use this $RH = $RANK * $HEALTH ; $SP = $Skills + $POWER ; $SPRH = … Read more

[Solved] I want to search for a product by its name and display the name and selling price in a JTextField in java [closed]

by

When you use a PreparedStatement you need to replace each “?” with a valid value before doing the actual query. So the basics of the code would be: String sql = “Select * from SomeTable where SomeColumn = ?”; PreparedStatement stmt = connection.prepareStatement(sql); stmt.setString(1, someColumnVariable); ResultSet rs = stmt.executeQuery(); solved I want to search for … Read more

[Solved] Is mysql count(*) much less efficient than count(specific_field)? [duplicate]

by

For InnoDB If specific_field is not nullable, they are equivalent and have the same performance. If specific_field is nullable, they don’t do the same thing. COUNT(specific_field) counts the rows which have a not null value of specific_field. This requires looking at the value of specific_field for each row. COUNT(*) simply counts the number of rows … Read more

[Solved] How to find dates between two dates in SQL Server 2005

by

This will work in sqlserver 2005: DECLARE @startdate datetime DECLARE @enddate datetime SELECT @startdate=”2015-12-04″, @enddate=”2015-12-07″ ;WITH N(N)AS (SELECT 1 FROM(SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1)M(N)), tally(N)AS(SELECT ROW_NUMBER()OVER(ORDER BY N.N)FROM N,N a,N b,N c,N d,N e,N f) SELECT top (datediff(d, @startdate, @enddate) + 1) dateadd(d, N – 1, … Read more

[Solved] How to select the first number in a string

by

This substring() expression does what you ask: substring(string, ‘\m\d+\D?*\M’) The regular expression only returns the first match, or NULL if none. \m … beginning of a word\d+ … one or more digits\D? … zero or one non-digits\M … end of word Demo: SELECT string, substring(string, ‘\d+\D?\d*\M’) FROM ( VALUES (‘FLAT 3, thanos house, nw1 6fs’) … Read more

[Solved] What is wrong with this sql statement?

by

First error: field names should be enclosed in backticks, not quotes. (and even then, the backticks are only necessary if the field name is a reserved SQL word or contains special characters. Generally it’s a good idea to have backticks, but in your example you can get away without them) Second error: missing closing bracked … Read more