T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Can I have a SQL Agent Job which runs a report, then a process, then another report?

  All, Is it possible to invoke SQL Agent Job which executes a reporting service report to email the …

  SQLOzzie

  2 replies

  13 years, 6 months ago

  By: SQLOzzie

• Image saving in sqlserver issue

  hi all, i have a field of image data type in my table in sqlserver. i am using enterprise library5…

  MuhammadShafiq

  5 replies

  13 years, 6 months ago

  By: Sean Lange

• Database Growth Option Issue

  Hello friends, I am trying to setup a database logfile size to autogroth through TSQL but it is not…

  sqlquest2575

  2 replies

  13 years, 6 months ago

  By: sqlquest2575

• how to join two tables with non equal conditions?

  I have two tables: create table #A(aYr int, aCol int) insert #A(aYr,aCol) values (2008, 2) insert #…

  sliu

  3 replies

  13 years, 6 months ago

  By: sliu

• Get Changes to Objects form DMV's as opposed to Database Triggers

  I had Database triggers for Tables and Stored Procedures. However they prevented creating, altering…

  Welsh Corgi

  3 replies

  13 years, 6 months ago

  By: Welsh Corgi

• Error on SELECT INTO INSERT failed because the following SET options have incorrect settings: 'ANSI_NULLS'

  I get the error listed below when performing a SELECT INTO. I never got an error on a SELECT INTO.:…

  Welsh Corgi

  8 replies

  13 years, 6 months ago

  By: Welsh Corgi

• using select into and controlling varchar sizes

  Hi, I have a really long select-into statement that has a lot of calls to user-defined string funct…

  cafescott

  22 replies

  13 years, 6 months ago

  By: Jeff Moden

• Help with PIVOT

  Hi all, Can someone pls help me with the following? I'm trying to to do a few tests and to use PIVO…

  Mr. Holio

  3 replies

  13 years, 6 months ago

  By: Mr. Holio

• Clustered Index + Logical IO cost

  Hi All, Will clustered index help us to reduce logical IO cost? Since the data's are physically sor…

  karthik M

  8 replies

  13 years, 6 months ago

  By: pkrudysz

• Temp table not deleted when exec SQL string

  When I try to run below script Getting error : There is already an object named '#mytemp' in the da…

  inayatkhan

  6 replies

  13 years, 6 months ago

  By: GSquared

• Exporting table with data

  Hi, i have a table having alot of data on my local machine.i want to import this table to my server…

  MuhammadShafiq

  7 replies

  13 years, 6 months ago

  By: Grant Fritchey

• DELETE !!! soft ? or Hard ?

  All, I have a different scenario. create table sec_returns ( sec_no int, sec_dt datetime, ret decim…

  karthik M

  11 replies

  13 years, 6 months ago

  By: Ninja's_RGR'us

• RollBack Needed

  Hi all, i am using sqlserver2005.i have two questions 1- I updated a table without puting a where c…

  MuhammadShafiq

  16 replies

  13 years, 6 months ago

  By: Ant-Green

• linked server. To use or not to use

  I have a couple tables and or viewes that i want to copy over to a different box daily. I was plann…

  Snargables

  7 replies

  13 years, 6 months ago

  By: Divine Flame

• How to replace a part of string in all the column values

  Hi, I have a table with many columns. It contains the details of the products. One of the column…

  SkyBVI

  4 replies

  13 years, 6 months ago

  By: SkyBVI