Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Select part of a text string...

  I have a problem where I need to select all top level file paths from a string value in SQL So I ha…

  chapterthirteen

  4 replies

  9 years, 12 months ago

  By: chapterthirteen

• Transaction isolation level and implicit transactions

  I'm investigating a poorly performing procedure that I have never seen before. The procedure sets t…

  Stephanie Giovannini

  4 replies

  9 years, 12 months ago

  By: Stephanie Giovannini

• Using value from cloumns to generate a new value for new column

  Hi I've data as below account period01 period02 period03 period04 1111 null …

  sqlbaby2

  2 replies

  9 years, 12 months ago

  By: Jeff Moden

• Query to Split the String as rows and columns in SQL

  I have a string that contains series of parameters with separators.i need to split the parameters a…

  g_rose42

  8 replies

  10 years ago

  By: Jeff Moden

• EXISTS queries that can't be written any other way

  Hello. All examples of the EXIST operator I know of use correlated subqueries that could be also wr…

  peter 82125

  18 replies

  10 years ago

  By: cyp901

• Relation between SQL Server login and session

  Hi people I have question, how can I determine the relation between MS SQL Server user (SQL l…

  arthurpogh

  1 replies

  10 years ago

  By: SpeedySQL

• Need best way to move historical data out

  Hi, I am getting ready to start a project where I am charged with moving out old data from producti…

  krypto69

  5 replies

  10 years ago

  By: JustMarie

• SSIS

  I am trying to get some details for one of my SSIS migration project. I need to find all of the SSI…

  Austin_123

  1 replies

  10 years ago

  By: JustMarie

• SQL Server- Export Data without html formatting

  I need to export some Database data into a text file. My Query looks like this: SELECT Category…

  marialena.webdesign

  1 replies

  10 years ago

  By: Michael L John

• 【HELP】T_SQL LIKE CLAUSE

  Hi All, In my column (FilePath) contains the values as below, FILEPATH --------------- \\Dpo-doctes…

  knockyo

  6 replies

  10 years ago

  By: knockyo

• Metadata about current query

  I'm curious if there is a way to gather any metadata about a query that was just ran, or about a dy…

  bartedgerton

  1 replies

  10 years ago

  By: mister.magoo

• IndexedView question for heavy loaded database

  Hi folks. I know you'll say "you have to experiment it" but I need your opinions. Here are key poin…

  aykut canturk

  3 replies

  10 years ago

  By: aykut canturk

• Trigger a report by sending email

  Hi friends, I have a report that gets a Customer_Number parameter and sends a mail with that custom…

  mshparber

  1 replies

  10 years ago

  By: HappyGeek

• Query for listing views in a database involving tables from other databases

  Hello, Can anyone provide me with a script to get the list of views in a database, involving tables…

  Agnii

  2 replies

  10 years ago

  By: Agnii

• How to roll back all changes if not all statements executed successfully?

  I have a script contains multiple statements to update multiple tables. How can I make sure that ei…

  nguyenanhminhxd

  5 replies

  10 years ago

  By: Gail Shaw