Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Parent / Child tables - SELECT QUERY to bring child data records into parent record

  I have two tables, one with Summary/basic data, the other with detail data multiple records pertain…

  rmcfaden

  4 replies

  7 years, 10 months ago

  By: rmcfaden

• SEQUENCE object or NEWSEQUENTIALID()

  I'm studying for my 70-461 exam and have received a corker of a question in my practice test: "You …

  JamesSmith1000

  6 replies

  7 years, 10 months ago

  By: Steve Jones - SSC Editor

• Error OPENQUERY Maximum length is 8000

  Hi, I have a query inside a openquery:SELECTRE.*FROM OPENQUERY(PROD,'SELECT XXXX ') RE This is…

  Helical Joan2

  1 replies

  7 years, 10 months ago

  By: Lynn Pettis

• SQL Job calling .NET App connecting to another SQL instance - security issue

  Hi, I've intertied a failing process and have been asked to fix it. The process is a SQL job which …

  MikeRen

  2 replies

  7 years, 10 months ago

  By: Steve Jones - SSC Editor

• Best way of concatenating values and returning an empty for null values

  I've taken an online practice exam for my 70-461 exam and I cannot work out why concatenating using…

  JamesSmith1000

  3 replies

  7 years, 10 months ago

  By: JamesSmith1000

• Spilt a record into 4

  Guys,  have select statementSelect salesid, salesname, salesamount from salestable ssales…

  Angela4eva

  3 replies

  7 years, 10 months ago

  By: Angela4eva

• Managing large table in SQL Server 2014

  Hi Guys, I have a large table that has around 11 million rows and is growing by about 1 million row…

  Jim-S

  25 replies

  7 years, 10 months ago

  By: Jim-S

• Issue with SELECT after creating a CTE SOLVED!! User error

  not fluent in CTE's but I thought i did this right. I get an Error Near SELECT for the select after…

  jeffshelix

  1 replies

  7 years, 10 months ago

  By: Lynn Pettis

• Using the Name of a CASE STATEMENT later on in a CONCAT

  I understand why i can't do this (using CONCAT with "MOT2".  For the same reason i couldn't us…

  jeffshelix

  7 replies

  7 years, 10 months ago

  By: Lynn Pettis

• Import and Export Data Package

  I created a package (AccessData) using the SQL Server 2014 Import and Export Data (32-bit) tool.&nb…

  Dave62

  2 replies

  7 years, 10 months ago

  By: Dave62

• Moving database

  I have moved a database from one computer (and server) to another by using a backup copy, and then …

  pchiro

  3 replies

  7 years, 10 months ago

  By: Lynn Pettis

• Nullable FK within one to many relationship

  Hi Guys, i noticed that my problem appeared from one to many relationship with nullable FK. My…

  jaryszek

  11 replies

  7 years, 10 months ago

  By: RonKyle

• updates are not happening through ssms

  hi,I have created after insert ,update,delete trigger for one of the table.The table does not have …

  dastagiri16

  13 replies

  7 years, 10 months ago

  By: dastagiri16

• SQL Server 2014 Reporting issue

  I am Configure SQL Server 2014 Reporting server. and i Developed and Deploy Reports using visual St…

  shoaibhameed1192

  12 replies

  7 years, 10 months ago

  By: Sue_H

• Merge several codes to one code

  I am trying to merge different sets of sql queries to one query and when i try to do , i shows inco…

  komal145

  3 replies

  7 years, 10 months ago

  By: komal145