Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• last exected date for stored proc

  Hi All, Is it possible to find out the last executed date for any stored proc in the database usin…

  anjaliagarwal5

  2 replies

  10 years ago

  By: ShineBoy

• Partitioning Table Strategie

  Im just starting to get into this topics and looking for general advice on how to set up the partit…

  ps_vbdev

  25 replies

  10 years ago

  By: ps_vbdev

• Help - Sql update commands being reversed

  Hi, Can you help me please? I'm running a update on a table and it appears to work. But when I c…

  jellybean

  9 replies

  10 years ago

  By: Grant Fritchey

• Working on type 2 dimension in 2014 visual studio

  Actually , for historical record I have to update End date as Updated Date where end date is Defau…

  sqlmaverick

  7 replies

  10 years ago

  By: sqlmaverick

• Like Statement With Parameters

  I have a table : Person(Id bigint , FirstName nvarchar(50) , LastName nvarchar(50),Address nvarchar…

  eskandari-a

  11 replies

  10 years ago

  By: Jason A. Long

• Help with query

  I need to create a query where patients have delivered and may have returned within a certain numbe…

  sharonmtowler

  2 replies

  10 years ago

  By: ChrisM@Work

• Alternative query which can have better performance

  Hello All, Is there an alternative to this update query mentioned below. DROP TABLE #FinalMeetings…

  myzus2004

  8 replies

  10 years ago

  By: myzus2004

• Random number !

  I have a function which generate random number in range : CREATE FUNCTION Func_Rand ( @M…

  farax_x

  2 replies

  10 years ago

  By: farax_x

• Syntax question

  I have a robust query that returns a dataset and the data is good, however some of the records cont…

  rhaberkorn

  4 replies

  10 years ago

  By: rhaberkorn

• Code dotnet in the sql injection in management studio

  Hello, I have developed a solution that allows to inject code directly in dotnet requettes sql . wh…

  inosys

  6 replies

  10 years ago

  By: inosys

• SQLCMD format issue

  Hello All, I am trying to export data using SQLCMD. One of the columns in the table has the FLOAT …

  deep_trance_

  4 replies

  10 years ago

  By: deep_trance_

• Error using PowerShell script for restore job

  Dear All, I'm trying to create a restore job for restore job in sql using PowerShell but I get the …

  tt-615680

  1 replies

  10 years ago

  By: WilburBud

• SSIS Deployment

  Hi, I need to deploy a SSIS project to a remote server to which I have very limited access. Don't h…

  D1rtyD0g

  4 replies

  10 years ago

  By: D1rtyD0g

• Table locking while insert statement

  I have two tables for insertion in one transaction scope. Table one have 10 rows. After first table…

  shamshad.ali

  5 replies

  10 years ago

  By: Dean Mincic

• SSDT - Where??

  After trashing my Visual Studio 2013 Professional installation by installing the stand-alone SQL Se…

  Steve Marak

  1 replies

  10 years ago

  By: serg-52