Viewing 15 posts - 1,906 through 1,920 (of 5,111 total)
It's worth noting, SSMS is not SQL Server. SSMS is an application to connect to SQL Server. SQL Server is a completely different install. If you've looking to uninstall a...
June 21, 2018 at 4:26 pm
I realise this isn't an answer to your question, however, why are you using the nolock query hint on every table? Also, please learn how to Alias objects in a...
June 21, 2018 at 9:33 am
Also, I noticed you haven't responded on my comment in regards to NOLOCK. What's your reasoning for using it?
June 21, 2018 at 7:18 am
When ever I run the statement again the "duplicate key value" just goes up...
June 21, 2018 at 7:10 am
Something a bit more readable (again):USE [campus_reporting];
GO
CREATE TABLE [dbo].[CmEvent] ([StartDate] [datetime] NULL,
[EndDate] [datetime] NULL,
[RemindDate] [datetime] NULL,
[DueDate] [datetime] NULL,
[Comments] [text] NOT NULL,
[Subject]...
June 21, 2018 at 6:59 am
Ideally, you need to change your data set up. Is that something you're open to?
June 21, 2018 at 6:50 am
Have you checked the "Keep together on one page if possible" checkbox?
June 21, 2018 at 5:30 am
Query that is a (little more) readable (white space remove courtesy of SSC's broken text editor) and with the syntax errors removed:WITH
#ExList AS
(SELECT DISTINCT
st.SystudentID,
CASE...
June 21, 2018 at 5:20 am
also this query had run few minutes in sql 2012 and now run hours in...
June 20, 2018 at 7:01 am
Perhapsyyou mean can you use SSMS to connect to 2 (or more) servers at the same time? If so, then yes.
Like Phil said, however , this question is...
June 20, 2018 at 6:50 am
select columnJune 20, 2018 at 6:39 am
Thanks for your reply. My requirement is like some thing like support system. From...
June 20, 2018 at 6:05 am
What do you mean by editting? As in, someone in an application is viewing the record? You'll need to implement your own "locked" system. For example, add a column (maybe...
June 20, 2018 at 5:47 am
"disturbing" is an odd choice of word. 🙂
Have you considered using the Dark Theme?
June 19, 2018 at 1:13 pm
Viewing 15 posts - 1,906 through 1,920 (of 5,111 total)