Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Using "Try-Catch" and "Rollback" on read only stored procedure

  Hello All, I have a confusion on using "Try-Catch" and "Rollback" on stored procedures. In general …

  SQL_Hound

  14 replies

  10 years, 3 months ago

  By: Eirikur Eiriksson

• Split and Transform Words

  I have a problem I'm having trouble solving. I have an application I write a textbox: 'SQL SQL' MIC…

  diogo_1984

  2 replies

  10 years, 3 months ago

  By: Steve Jones - SSC Editor

• Somebody explain Checkpoint to me

  I'm using the below SQL to delete about 110million rows in batches of 100,000 It's working fine in …

  planetmatt

  7 replies

  10 years, 3 months ago

  By: Luis Cazares

• Remove memory optimized filegroup

  I read this: http://www.sqlservercentral.com/Forums/Topic1568262-32-1.aspx Which says you must drop…

  Josh Rotert

  3 replies

  10 years, 3 months ago

  By: Grant Fritchey

• Can I get the user windows login when using Sql server login authentication ?

  Hi everyone, Oracle and Teradata are able to capture the windows/client login that connects to thei…

  Matrixman

  2 replies

  10 years, 3 months ago

  By: Grant Fritchey

• DDL AND DML STATEMENTS IN SSIS

  I have a situation to write this code in SQL to used in SSIS. if table1.username in (table2.usernam…

  Sangeeth Raj

  5 replies

  10 years, 3 months ago

  By: Sangeeth Raj

• Creating Mutliple Logins

  I had a need to test something recently and wanted to create multiple logins. Other than using a ba…

  Steve Jones - SSC Editor

  6 replies

  10 years, 3 months ago

  By: Eirikur Eiriksson

• Find double records within DateTime range

  Hi, thanks for reading my topic. I have a query question. Consider a table with the following struc…

  sirokinl

  11 replies

  10 years, 3 months ago

  By: Robert-378556

• Access to SQL Server - How to Auto Update Multiple Tables Daily

  I have got 4 MS Access Database Files, which have got 3 Tables each, means Total 12 Tables which ge…

  tlp6327

  4 replies

  10 years, 3 months ago

  By: tlp6327

• Help with troubleshooting performance

  Hi I have been looking at a SQL agent job that runs. The issue is that it joins a lot of tables as …

  SG87

  2 replies

  10 years, 3 months ago

  By: Grant Fritchey

• Is there an easier way to do this than to use a CTE?

  Here's the code, followed by the explanation of what I'm wanting to do: --alter view vwStudentsAPHQ…

  Wayne West

  5 replies

  10 years, 3 months ago

  By: Wayne West

• Trigger on a view

  Hi, I have a situation where I have Table A, Table B. View C is created by joining table A and tabl…

  ajvkumar

  2 replies

  10 years, 3 months ago

  By: ajvkumar

• Trying to Avoid Dynamic SQL

  I am constructing a query. It will pull data from 10 different databases. Rather than write the cod…

  ducksql@gmail.com

  11 replies

  10 years, 3 months ago

  By: ducksql@gmail.com

• Add new column with default value

  Hi There, I want to set a default value to a column while adding it. Create table test(id int ) …

  vignesh.ms

  6 replies

  10 years, 3 months ago

  By: John Mitchell-245523

• TSQL dense rank type question - finding the first date of a budget change (budget values can bounce back and forth in values)

  I am trying to write a query to give me all "budget changes" (and the day they happened) per custom…

  bperrello

  4 replies

  10 years, 3 months ago

  By: Eirikur Eiriksson