Advertise Here

Query Syntax

47K

Solutions

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

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

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

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

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

Advertise Here

Query Syntax

47K

Solutions

Articles & Videos

18K

Contributors

Course Of The Month

Query Syntax

Related Topics

Query Syntax

Related Topics