Sorry, but i`m noob and i need your advices. I have some result set from oracle with timestamptz, i get string value of this timestamptz which like 2014-1-10 13.47.56.0 7:0 and then I need put it in postgresql-request in some function which takes timestamp with timezone. How can I convert this this string to …
Bat File to Delete sql database
I am able to delete files/folders through the bat file fine, the problem comes when i need to delete old mdf and ldf files. I get access denied error message. Is there a way to overcome this in the …
Sql query to convert or display bytes columns into MB?
I have a query as This query would bring the IP addresses that sent more than 1 million bytes within all flows in a specific time frame, you must enter The result is similar to I want the sourcebytes to appear as MB format. Do I need a nested query for that? Thanks. Answer Use this expression. CONCAT is SQL
The backend version is not supported to design database diagrams or tables
I’m trying to add a table to my newly created database through SQL Server Management Studio. However I get the error: the backend version is not supported to design database diagrams or tables To see my currently installed versions I clicked about in SSMS and this is what came up: What’s wrong her…
Split Full Name with Format: {Last, First Middle} Comprehensive Cases
My client sent me name data as a Name string which includes the last, first, and middle names in a single entry. I need them split into LastName, FirstName, and MiddleName. I have found some scripts online, but they don’t serve my purposes because they either (1) use a different format, or (2) don’…
How to use SUM and GROUP BY(SQL) with Visual FoxPro in VB.NET?
I do not have much experience with VB. I have built a VB app that can retrieve data from a table(FoxPro). The code is given below: But I need to run the following SQL instead of SELECT * FROM inventory I replaced the SQL and it does not work. How can I implement that SQL or GROUP BY statement into
Calculate price of rental period
I am working on a project for which I need to calculate prices of holiday homes available in a selected rental period. I need some help with building a SQL query that combines the following tables and …
Trying to get a single record involving MAX(Date) and GROUP
I am trying to create a query in which I start with an item number and a customer and I have to determine the last selling price. The tables involved are SOP30200 = Sales Header SOP30300 = Sales Detail lines Given the following code and results: CODE: RESULTS: I am getting 2 records because the query is group…
two foreign keys, how to map with laravel eloquent
I have two tables in MySQL, where the first one is called users and the second one is called games. The table structure is as follows. users id (primary) email password real_name games id (Primary)…
Get column names which do not match a particular ending string
I have a table with a structure like this: abc_col | abcd | ab_col | | | | Some column names end in _col and some do not. abc or ab or abcd are random column name …