Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Display Data

  Hi I want below data to appear like below using query CREATE TABLE [dbo].[Test]( [DocEntry] [int] …

  jagjitsingh

  1 replies

  4 months, 2 weeks ago

  By: Phil Parkin

• Different number of records returned from SSMS and C# ExecuteReader

  I am using the EXACT same query in SQL Server Management Studio (2014) as I am in my C# program, bu…

  tim8w

  3 replies

  4 months, 3 weeks ago

  By: EdVassie

• How to connect to Oracle Cloud Database in SSIS

  Hey guys, I need to connect to an Oracle Cloud database inside ssis. Can someone point me to a tuto…

  dndaughtery

  3 replies

  5 months, 3 weeks ago

  By: NickEvans

• Why is "SELECT *" about 10 times faster than "SELECT (ALL Columns)"

  Dear all, I have noticed that  a "SELECT * ..."  is about 10 time faster than "SELECT Column1, Colu…

  fw 10048

  6 replies

  5 months, 3 weeks ago

  By: frederico_fonseca

• why no suggested indexes in estimated exec plan?

  hi im looking at a query for a friend that has to be lacking in indexes.  I'm in ssms. i ran an est…

  stan

  10 replies

  6 months, 2 weeks ago

  By: Jeff Moden

• How can I tell which action happened from the UPDATE or INSERT in my SP?

  I have the following Stored Procedure that attempts to UPDATE a table, and if there is no correspon…

  tim8w

  2 replies

  7 months, 1 week ago

  By: Grant Fritchey

• How can I tell if an UPDATE command updated any rows?

  I am calling an Update routine from C# and need to determine if the Update routine found a matching…

  tim8w

  5 replies

  8 months, 3 weeks ago

  By: kaj

• Need assistance to remove numbers from a Column result

  I have a Colum that outputs this data, depending on the Card Type: 0991719957291436|02|22|VISA|Visa…

  chef423

  7 replies

  9 months ago

  By: chef423

• Stop job after specified run time

  I'm testing a long running job and want to stop it after it has been running for, say, 2 hours. How…

  kuopaz

  11 replies

  9 months, 3 weeks ago

  By: tung858

• Query to return all data that has same site, section and date

  I have a query Select Id, WOCode, Site, Section, CompletionDate from work orders where type = 'BRE'…

  Nomvula

  7 replies

  10 months ago

  By: Steve Collins

• could you please help, i want to update 3days before and after holidaydate samed

    could you please help, i want to update holidayAll column with same Holidaydate as  3days be…

  DBA.k

  3 replies

  10 months, 1 week ago

  By: drew.allen

• Need help on results output

  Hi guys. I need help  with query results output. I have the following table: create table MyTable(H…

  Barcelona10

  4 replies

  10 months, 2 weeks ago

  By: DesNorton

• Healthcare / Medical sample database?

  Does anyone know of an "AdventureWorks-esque" sample database for the heatlhcare, health insurance …

  mtlsql

  16 replies

  10 months, 2 weeks ago

  By: mtlsql

• How to load AML files SSIS or any other option

  Team, Please suggest or if you have an example please share the link for loading AML (anti moneylau…

  JSB_89

  7 replies

  10 months, 2 weeks ago

  By: JSB_89

• Log Reader Agent error

  Dear all, What is the reason and fix for the below error? The Replication_User is used in Security …

  Meera

  3 replies

  10 months, 2 weeks ago

  By: Meera