Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• null date parameter for a stored procedure

  I have a stored procedure that has a parameter of date named dateStored. The default value is null.…

  sqlfriend

  41 replies

  7 years, 9 months ago

  By: ScottPletcher

• running trigger before deletion

  Hello, I have a table called Consequences. I have another table called RiskMatrixAxis. The Conseque…

  junk.mail291276

  6 replies

  7 years, 9 months ago

  By: junk.mail291276

• Using a Case Statement to see if a Date is in the previous month or not

  For a crazy calculation I need to do (it's part of a conditional across many fields)  I need t…

  Stephen crocker

  12 replies

  7 years, 9 months ago

  By: Sergiy

• “LOGIN FAILED FOR USER ‘NT AUTHORITY\ANONYMOUS LOGON’” WHEN YOU RUN AN SSIS 2012 PACKAGE FROM A STORED PROCEDURE

  i researched my issue and found the below link. I don't want to use a sql job. I'd rather now hard …

  Snargables

  5 replies

  7 years, 9 months ago

  By: sqlfriend

• Regarding Installation from MSSQL serve 2014 to SSIS, BIDS

  Hi everybody,I am looking for step by step whole installation of MSSQL server 2014 database and SSI…

  kmahendra229

  4 replies

  7 years, 9 months ago

  By: kmahendra229

• Add Auto Incremental to existing column

  Somehow when adding a table from another database there was no PK or Auto Incremental column set, n…

  rtrice81

  3 replies

  7 years, 9 months ago

  By: Phil Parkin

• how to open view on inserting values

  Hello I am trying create view, when I run it it will ask for values, I enter and it will search for…

  Krasavita

  6 replies

  7 years, 9 months ago

  By: sgmunson

• I'm struggling to update records from the result query

  I'm doing validation, comparing if two tables have the save rows and result using except and inters…

  Nomvula

  5 replies

  7 years, 9 months ago

  By: ChrisM@Work

• using IF and ELSE if to tell SSMS to jump to that section of code

  USE GTM_ODSFirst, i declare the variable and set it . . . . DECLARE @FTA VARCHAR (10)SET @FTA=…

  jeffshelix

  10 replies

  7 years, 9 months ago

  By: Lynn Pettis

• dateadd(day, max(field1) % 1000, dateadd(year, floor(max(field1)/1000), '31-dec-1899')) --must be formatted as text, MM/DD/YYYY

  Hello can someone help me to format this code as text ?Thank you so muchT

  Krasavita

  6 replies

  7 years, 9 months ago

  By: ChrisM@Work

• 2000-11-28 00:00:00.000 how to convert this to text format

  Hello can some one help me to convert this to text format dd/mm/yyyy thank you so much

  Krasavita

  1 replies

  7 years, 9 months ago

  By: Lynn Pettis

• Insert a data in MS Sql Server Managment studio thorugh php

  Hi,I am using MS SQL server management through PHP. I have already connection successful&…

  zsultan 53790

  7 replies

  7 years, 9 months ago

  By: Phil Parkin

• Odd Join Scenario

  I wasn't sure how to search for a solution this scenario. So I'm posting it here hoping for some he…

  sqlprincess

  2 replies

  7 years, 9 months ago

  By: deepika0928

• Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths.

  Hello, I'm encountering an error when trying to deploy my database. The error says: "Introducing FO…

  junk.mail291276

  3 replies

  7 years, 9 months ago

  By: sgmunson

• Need help setting cascade on delete

  Hello, I have a hierarchy of tables in my database. They look like this: --Reports----ReportMetrics…

  junk.mail291276

  3 replies

  7 years, 9 months ago

  By: sgmunson