SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Move DB file with a '.' in the name

  I am trying to move a database file to another drive. For some reason I keep getting invalid file. …

  toolman21

  3 replies

  9 years ago

  By: toolman21

• one of my stored proc is getting stuck in activity monitor for 2 hours.

  hi, one of my spid is getting stuck for two hours or 15 min or 1 hours etc, and showing up in "a…

  rajemessage 14195

  3 replies

  9 years ago

  By: Ed Wagner

• there are two spid in sp_who2 .

  pls tel me why two spid are there in sp_who2

  rajemessage 14195

  1 replies

  9 years ago

  By: Eirikur Eiriksson

• will it call subquery for every row of table with distinct in subqyery.

  hi, 1) select * from abc where abcid =(select top 1 abcid from xyz where xyzid =@xyz) 2) Select…

  rajemessage 14195

  13 replies

  9 years ago

  By: rajemessage 14195

• Need help in partitioning a table

  Hi Guys, As I am not much familar with partition concept of SQL Server, I need your help to add a n…

  prabhu.st

  3 replies

  9 years ago

  By: TheSQLGuru

• T-SQL Coding Help

  CREATE TABLE Link_Table ( ScodeVARCHAR(10) ,ICodeVARCHAR(10) ,SDateDATETIME ,EDateDATETIME ,CCo…

  rocky_498

  2 replies

  9 years ago

  By: rocky_498

• sifting sequencing problem

  hi, DROP TABLE MARBLE CREATE TABLE [dbo].MARBLE( [marbleid] [int] IDENTITY(1,1) NOT NULL, […

  rajemessage 14195

  14 replies

  9 years ago

  By: sgmunson

• Trigger causing deadlocks

  We have a trigger which is causing increasingly frequent deadlocks to occur at a particular time of…

  zoggling

  11 replies

  9 years ago

  By: Jeff Moden

• Updating from text file

  Hello, I am sending data(text file) to third party which they import to their tool which users pul…

  PJ_SQL

  3 replies

  9 years ago

  By: Phil Parkin

• Store procedure to export a table to csv file

  How to create a store procedure to export a table to CSV file? I try to use code below but company …

  adonetok

  4 replies

  9 years ago

  By: Luis Cazares

• grain of a table

  Hi, To me, grain is the mechanism how you can get 1 single Unique row in any table. For example, t…

  etl2016

  4 replies

  9 years ago

  By: Chris Harshman

• Trigger Question - Update not working for my situation

  Okay - I have an ERP application that I am trying to write a SQL trigger for. I'm trying to write …

  Bron Tamulis

  3 replies

  9 years ago

  By: Sergiy

• XML multiple nodes not working

  I have some xml that I need to pull data from. Below is a sample of the xml and what I'm trying to …

  bennylu

  10 replies

  9 years ago

  By: R.P.Rozema

• Help with concatenating row values

  Hi, I have requirement to concatenate row values and was able to achieve using codeplex-groupconcat…

  Tsql-561486

  2 replies

  9 years ago

  By: R.P.Rozema

• Trigger Problems

  We have transactional replication set up. On the subscriber, there's a table with 2 triggers on it.…

  Sioban Krzywicki

  7 replies

  9 years ago

  By: TheSQLGuru