I´m kind of new to databases and I was hoping you could answer my question: I have a table with an ID that´s a primary key, not null and Auto increments. It´s data type is int, with a limit of 50 digits. this table will be receiving new rows constantly, so I was wondering if it´s dangerous to leave as
Tag: sql
Update row with select on same table
I’m trying to update row with same table query. Context: I want to : For each row; if TEXT IS NULL; update it with TEXT value of row with same ID and LANG = ‘EN’. What is the SQL request to do something like that ? Answer You don’t specify the database. The following is standard SQL: I…
There is insufficient system memory in resource pool ‘default’ to run this query. on sql
I have a running service that gets 50-100 queries per minute. And these are not high cost queries. This service has been running for around 3-4 months without any errors. Suddenly few days ago it started giving “There is insufficient system memory in resource pool ‘default’ to run this query…
Convert oracle.sql.timestamptz to postgresql timestamp with timezone
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 …