Query Syntax

47K

Solutions

13

Articles & Videos

18K

Contributors

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Related Topics

  1. Microsoft Access
  2. Microsoft SQL Server
  3. Microsoft SQL Server 2005
  4. Microsoft SQL Server 2008
  5. Databases
  6. MySQL Server
  7. Oracle Database
  8. PHP
  9. ASP
  10. Visual Basic Classic
Refine results

I need to dedupe a string made from concatenated fields before I send the string off to be split.

The leftmost word needs to be kept of the dupes.

'XF XF 250 ATV-2 TERRAHAWK' and this 'XF 250 …

1010 views
How Do You Stack Up Against Your Peers?
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Dear Experts,

Could you please have a short look on the below code, simply I would like to create a temp table with name #tRecAccountsPivot based on that pivot:

(CODE)

But something is …

913 views

SQL> INSERT INTO EMP6(EMPNO,ENAME,SAL) VALUES(1234,'MIHIR',3000);
INSERT INTO EMP(EMPNO,ENAME,SAL) VALUES(1234,'MIHIR',3000)
*
ERROR at line 1:
ORA-01400: cannot insert NULL into …

724 views

My query:
(CODE)

is resulting in the itemsOrdered being multiplied by the number of items and the itemsShipped being multiplied by something as well.

I'm not sure what more info you guru's …

114 views

Hi, Hope someone can help (using SQL server 2005)...

I have 2 queries that both work perfectly, but I would like to incorporate the second query in to the first so it returns 1 row..
what I …

222 views

I have this query, but it needs to work as a view in SQL Server:
SELECT tbl_raw_material.raw_material_id,
[packaging_type] & 
IIf(IsNull([packaging]),"","|") & [packaging] & 

519 views

I have the string  'A1 MK1 (8X) SPORTBACK TDI S LINE'

'A1' is the first word
'MK1' is the second word
'(8X)' is the third word
'SPORTBACK' is the fourth word
'TDI' is the fifth word
'S' is the…

2018 views

Hi All,

I want to generate below list :

TMCUSTOMER ("0015      ", "    ", "CASH                ", "CASH                                                                  ", "Jl.Samratulangi …

4619 views

I am trying to create a view in SQL 2014 and grouping it but whenever I create it as follows I get the timeout expired error. When I just create the view without the grouping it runs just fine and the…

521 views

Dear all brother and sister, i am working on VB.Net application with SQL Server, now i have table adapter and i copy my query to run on SQL Server it execute well, but when i click next in …

112 views
Business Impact of IT Communications
Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

A existing SQL statement that converts DateTime to a different format has been working for a long time, but is now give me a "Query timeout expired" error only seconds after the query is executed.

1028 views

I have a contact company table.  In the table I have two columns.

Company = This is the actual company name.
Alpha = This is a field that strips the word "The" from the company name and sets all …

315 views

I have the entire contents of a table, with headers, in a CSV file.

How do I import it into a file?

Thanks.

217 views

I have a SQL query that sums totals based on the current year and dumps those totals in to monthly buckets. For the sake of this question I only have Jan listed in the query however my output is from …

444 views

Hi

I use the following type of connection string to connect to a SQL database from VB.net. Is it possible to alter the connection string so that the connection is read only?

423 views

I have this query

UPDATE Table1  
SET
      CompareFlag = 'Y'
WHERE
      (Table1.doc_id IN
      (
          SELECT Table2.doc_id
          FROM   Table2
          WHERE  (batch_id IS …

215 views

Hi.  I'm trying to set up an odbc connection from client machine (windows 7) to Sql Server (2008 r2 express) using Windows Authentication.  The only driver available is sql server with no native …

415 views

hi,

I am looking for books/resource to learn SSIS and I prefer learning SSIS of SQL server 2014/2016, please suggest:

in my list, I have:

1326 views

Hi, I have this query  (using SQL server 2005)...

SELECT s.product,s.physical_qty,
      sum(h.val) AS sales
      FROM sysdaa.scheme.stockm s
      left join sysdaa.scheme.opsahistm h
      on s.product = …

415 views
Resolve Critical IT Incidents Fast
Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Hello experts. I am not an access expert so I'm hoping to get some help here. I have an ms access form on the front end connected to a sql database. The form has several tabs. On the payroll tab there…

933 views

Hi there,
Was wondering if anyone can help me out here...
I 'inherited' a spreadsheet to fix...apparently in Excel, a row 'appears' to be missing some data.

If you look at the highlighted area, …

816 views

Hi All,
Can anybody correct me with the below query where the query is going wrong ?
For the below Query i need to add where clause and get based on client names. When i execute the query i am able …

823 views

I have the following data:
Value      ReadingTime      EntityID      ServicePointChannelID
0.273      2017-05-17 00:15:00.000      76058805      1
0.272      2017-05-17 00:30:00.000      76058805      1
0.274      2017-05-17 00:45:00.000      76058805…

330 views

I wanted to alter the size of a column but sql server wont let me.

the error is
(CODE)

i tried like this:(CODE)

516 views

Hi Guys,

For example i have got the data in a table like below
(CODE)

So if i query (CODE)

is it possible that i rank the search according to the search criteria so that everything which …

313 views
Show more content
201506-LO-Top-001

Query Syntax

47K

Solutions

13

Articles & Videos

18K

Contributors

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Related Topics

  1. Microsoft Access
  2. Microsoft SQL Server
  3. Microsoft SQL Server 2005
  4. Microsoft SQL Server 2008
  5. Databases
  6. MySQL Server