Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x

SQL

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.

Share tech news, updates, or what's on your mind.

Sign up to Post

Have you enrolled in this month’s complimentary course? Enroll now for a free Microsoft SQL Server and Database Concepts course. Get 7+ hours of step-by-step SQL training, including possible topic interview questions.
0
[eBook] Windows Nano Server
LVL 1
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

I've a stored procedure SP1 built. It has 8 columns n 6 rows. I also created a table T1 with exact 8 columns as SP1 and this table is empty. How do I insert 6 rows from SP1 into T1? Does the insert statement need to be inside the stored proc SP1 or can be it a separate query?
0
 
LVL 124

Expert Comment

by:Andrew Hancock (VMware vExpert / EE MVE^2)
You may want to post this Question, in the Microsoft SQL Server, SQL, Query Syntax topic areas, to get an Answer.
0
 

Author Comment

by:LION KING
Thank you Andrew.
0
How to create a 4 quarter rolling calendar / period in sql server? For instance, if Table A as a date field - DATE1.
0
v2-native-ad-no-button.pngDo you work with and analyze data? Enroll in October’s Course of the Month to get step-by-step SQL training. Learn SQL to quickly and efficiently store and retrieve data!
0
native-ad-no-button.pngOctober’s Course of the Month is available! Enroll today to get 7+ hours of step-by-step Microsoft SQL Server training.
4
hi i  have 3 tables in sql server and i want to save all 3 table data into one new table WIN_20170930_221232.JPG
any help me?
0
 
LVL 60

Expert Comment

by:Kevin Cross
You should post this as a Question and it will draw in Experts within the areas you designate.  It looks like you will want to ask about how to JOIN data.  Good luck!

Ref: http://support.experts-exchange.com/customer/portal/articles/756544-how-to-succeed-at-ee-as-an-asker
0
 
LVL 60

Expert Comment

by:Kevin Cross
Welcome to Experts Exchange by the way!
0
2
Modified all long running SQL Agent jobs so that the end-of-process email notification also plays Boyz II Men's 'End of the Road'.   Management approved this and also proposed Johnny Cash 'Ring of Fire' for error notifications.
4
 
LVL 17

Expert Comment

by:Kyle Santos
Endorsed for the band ref.
0
A technology that is kind of a fad,but will probably last but be not as popular are the no sql databases. They have there place for certain applications, but I don't believe they will replace SQL databases. Having to know how you are going to query before you store your data is just not realistic.  
3
We had a partner replace a drive on the database server, when he resorted the database(s) on Friday all are now in SUSPECT mode and are inaccessible. We are not dba's and need help can anyone please help.  Sql 2012 r2.

Thank you
SORRY I posted this in the incorrect place I will not do this again
0
 
LVL 14

Expert Comment

by:Alex Green
1
 
LVL 12

Administrative Comment

by:Andrew Leniart
Hi Steven,

What you have done is made a "Post" here.

To get expert help, you need to "Ask a Question" so that more experts are able to see that you need help. Click the Big blue button near the top of your screen.

Ask-a-Question.png

The following link also explains more about asking for help at Experts Exchange..
http://support.experts-exchange.com/customer/portal/articles/336330

Regards,
Andrew
EE Topic Advisor
1
Prepare for your VMware VCP6-DCV exam.
LVL 1
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

A real head scratcher

SQL Server 2005
Web Service .Net Framework 3.5
Symbol MC3190
VB.NET Compact Framework 3.5

Dates consumed by the compact framework are shifted by the difference in the timezone between the server and the client.

Luckily for me the fix was as just a matter of setting the client machines timezone to that of the server.

Just putting it out there in case someone runs into something similar.

https://social.microsoft.com/Forums/en-US/9858d657-ce26-442a-86a7-e2ba6b774ebf/sync-framework-over-wcf-sql-2005-datetime-is-shifted-by-timezone?forum=syncgeneral


0
I have designed SSRS Report and Once I click on preview it is asking SQL Login details first time. I entered login details (sa, 123) after it was showed  report. On the DataSource double click => credential saved. Again it is asking to enter SQL Login credentials but I am not able to see any boxes on the top, it is showing only View Report.  
0
Can anyone explain this?

When looking for transactions based on timestamp in e.g. 2017 you can for instance do it like this:

...where timestamp >= to_date('2017','YYYY')
or
...where timestamp >=to_date('01.01.2017','DD.MM.YYYY')

Why does these two expressions return different number of transactions? In my case the latter returns appox. 8 times as many. Is this an error in Oracle SQL or is it something I have missed?

Thx!

Brgds
IVer Erling Årva, Oslo
0
 
LVL 14

Expert Comment

by:Alexander Eßer [Alex140181]
I don't think this is a bug, I suppose it's just the default behavior if you omit some time parts. I just can't find any evidence within the official docs. Maybe some other Oracle expter may help in finding that reference?!
0
 

Administrative Comment

by:South Mod
It seems this is a technical question, and therefore you should post this as a Question in the appropriate topics. The Posts feature is intended for members to share news, information, etc with others, and not to find a solution to a technical problem.
0
SQL PASS DBA Fundamentals mtg going on now.  Gail Shaw talking about Indexes, and her cat is talking back.  :-)  http://fundamentals.pass.org/
4
 
LVL 66

Expert Comment

by:Jim Horn
Joined.  Thanks for posting.
0

SQL

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.