Welcome to Jonic Developer Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

Recent questions tagged sql

0 votes
159 views
1 answer
    I'm looking for a way to update just a portion of a string via MySQL query. For example, if I have 10 records all containing 'string' as part ... string/etcetera', is there a way to change 'anothervalue' See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
166 views
1 answer
    Is the following piece of SQL Query a normal query or a Correlated Subquery ?? SELECT UserID, FirstName, LastName, DOB, GFName, GLName, LoginName, ... , can someone state the difference between the both See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
106 views
1 answer
    Being a self-taught newbie, I created a large problem for myself. Before inserting data in to my database, I've been converting apostrophes (') in a ... to know why I couldn't achieve that with SQL? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
136 views
1 answer
    Why does the PRINT statement in T-SQL seem to only sometimes work? What are the constraints on using it? It seems sometimes if a result set is generated, ... in another result set, such as the row count? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
134 views
1 answer
    I am new to SQL programming. I have a table job where the fields are id, position, category, location, salary range, description, refno. I want ... jobsalrange LIKE '%sales%' OR b.catname LIKE '%sales%' See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
173 views
1 answer
    I'm trying to determine the relative performance of two different queries and have two ways of measuring this available to me: 1. Run both and time each ... CPU with MANY more Reads takes less time :) See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
155 views
1 answer
    What is the meaning of the OVER clause in Oracle? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
102 views
1 answer
    I was wondering if it is possible to move all rows of data from one table to another, that match a certain query? For example, I need to move ... in Table1. I'm using SQL Server 2008 Management Studio. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
159 views
1 answer
    I am using Entity Framework 4 in a desktop application with SQL Compact. I want to use a private installation of SQL Compact with my application, so ... on the installation machine? Thanks for your help. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
119 views
1 answer
    I'd like to show the observation number for each record returned by a PostgreSQL query. I think in 8.4 windowing functions can perform this capability. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
172 views
1 answer
    I have following data in my table "devices" affiliate_name affiliate_location model ip os_type os_version cs1 inter Dell 10.125.103.25 Linux Fedora cs2 inter Dell 10. ... .103.27- cs4-Dell-10.125.103.28- See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
99 views
1 answer
    I'm just trying to get a general idea of what views are used for in RDBMSes. That is to say, I know what a view is and how to make ... questions are intentionally naive. This is partly a concept check.) See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
87 views
1 answer
    I am trying to port this line from MS SQL Server to SQLite IF NOT EXISTS(SELECT 1 FROM EVENTTYPE WHERE EventTypeName = 'ANI Received') INSERT INTO ... I missing something simple? Is there a workaround? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
180 views
1 answer
    I have a table in PostgreSQL where the schema looks like this: CREATE TABLE "foo_table" ( "id" serial NOT NULL PRIMARY KEY, "permalink" varchar(200) ... unique across the table by ALTER-ing the table. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
201 views
1 answer
    Assuming we have a database project called MyDatabase then a file called MyDatabase.jfm appears in the root of the project directory. It is exclusively locked while ... file is and where it came from... See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
285 views
1 answer
    My lecturer stated: All column names in SELECT list must appear in GROUP BY clause unless name is used only in an aggregate function I'm just wanting some ... explanation as to why it should be true... See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
153 views
1 answer
    This question asks about getting a random(ish) sample of records on SQL Server and the answer was to use TABLESAMPLE. Is there an equivalent in Oracle ... from a query that will return millions normally? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
180 views
1 answer
    I have a users table and a payments table, for each user, those of which have payments, may have multiple associated payments in the payments table. I would like ... p.user_id = u.id WHERE u.package = 1 See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
143 views
1 answer
    DELETE B.* FROM m_productprice B INNER JOIN m_product C ON B.m_product_id = C.m_product_id WHERE C.upc = '7094' AND B.m_pricelist_version_id = '1000020' i am ... .m_... what is the problem with my query? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
172 views
1 answer
    I have 3 tables: Persons (PersonID, Name, SS) Fears (FearID, Fear) Person_Fear (ID, PersonID, FearID) Now I'd like to list every person with ... personid = person_fear.fearid What am I doing wrong here? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
149 views
1 answer
    What is it a BLOB? How can I use it? What are the differences between DBMS's BLOBs. I would like to save data using BLOBs into any DBMS and then read that BLOB with a library. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
140 views
1 answer
    I know how to get the last executed queries using the following SQL in SSMS - SELECT deqs.last_execution_time AS [Time], dest.text AS [Query] FROM sys. ... turned on. I need to do this from SSMS. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
100 views
1 answer
    I would like to know is there a way to select randomly generated number between 100 and 500 along with a select query. Eg: SELECT name, address, ... FROM users Hope someone help me out. Thank you See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
134 views
1 answer
    I was wondering peoples opinions on the naming of ID columns in database tables. If I have a table called Invoices with a primary key of an identity ... on? What are other peoples thoughts on the topic? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
147 views
1 answer
    When I run a query with OPENROWSET in SQL Server 2000 it works. But the same query in SQL Server 2008 generates the following error: SQL Server ... of 'Ad Hoc Distributed Queries' by using sp_configure See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
84 views
1 answer
    It is based on the interview question that I faced. Very short definition can be It can be used to manipulate the rows returned by a query. Besides ... there any concrete point that we should use cursor? See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
130 views
1 answer
    Is there a value or command like DATETIME that I can use in a manual query to insert the current date and time? INSERT INTO servers ( server_name, ... I want to add the current date and time. See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
364 views
1 answer
    The table in question contains roughly ten million rows. for event in Event.objects.all(): print event This causes memory usage to increase steadily to 4 GB ... it's relevant, but I'm using PostgreSQL.) See Question&Answers more detail:os...
asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)
To see more, click for the full list of questions or popular tags.
Ask a question:
Welcome to Jonic Developer Community for programmer and developer-Open, Learning and Share
...