T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Is there a tsql command to refresh database objects in object explorer?

  Is there a tsql commmand to refresh UI objects in object explorer? I tried sp_refresh in 2008 it do…

  invaliddba

  6 replies

  14 years, 9 months ago

  By: nagainbox

• TSQL Finding Windows Scheduled Task

  Is it possible to find Windows Scheduled Task Job using T-SQL. Satnam

  Satnam Singh

  1 replies

  14 years, 9 months ago

  By: ColdCoffee

• Selecting all records that occur more than once

  I want to select the id and name of all companies in [prospects] table that have the same name and …

  petervdkerk

  2 replies

  14 years, 9 months ago

  By: Jeff Moden

• Using CONTEXT_INFO() in fields default value

  Hi, There's an option called CONTEXT_INFO() for using it as @@MYGLOBALVARIABLE. I can use it like: …

  wshmstr

  4 replies

  14 years, 9 months ago

  By: wshmstr

• Nested While loop

  Hi all, I am having some trouble parsing multiple values within two parameters. The goal is to loo…

  @Mike

  13 replies

  14 years, 9 months ago

  By: Jeff Moden

• return code from stored procedure in Sql management studio query window

  I have a stored procedure we use for returning suceed or failure code to a commandline batch file. …

  sqlfriend

  2 replies

  14 years, 9 months ago

  By: sqlfriend

• Using TSQL to unzip rar file but I don't see the files.

  I'm running the following TSQL EXEC master..xp_cmdshell '"C:\Program Files (x86)\WinRAR\unrar" e -y…

  dndaughtery

  13 replies

  14 years, 9 months ago

  By: Steve Jones - SSC Editor

• Help need for better query

  CREATE TABLE TABLEA ( purpose VARCHAR(10), contactTime datetime ) INSERT INTO TABLEA SELECT 'Takeca…

  krishusavalia

  1 replies

  14 years, 9 months ago

  By: LutzM

• Problem with using Datediff in weeks

  Hi all, As the subject suggests I am having a problem with using the datediff function in a query I…

  Craig Pa

  4 replies

  14 years, 9 months ago

  By: calvo

• Regarding comparing Indexes

  can someone help me in comparing the indexes from two database. I have a db Adventureworks, i migra…

  MsSqlNew

  5 replies

  14 years, 9 months ago

  By: R.P.Rozema

• Query Tuning Excersise

  Dear all, I am working on tuning a query and thought to share my experience with you and ask some q…

  chandan_jha18

  5 replies

  14 years, 9 months ago

  By: Ninja's_RGR'us

• i want to display alternative records..

  idname 1Giri1 2Giri2 3Giri3 4Giri4 5Giri5 6Giri6 7Giri7 8Giri8 9Giri9 10Giri10 how to di…

  dastagiri16

  1 replies

  14 years, 9 months ago

  By: Gail Shaw

• how to store result of 1 sp into sp

  hi i want to stored one sp result into another stored procedure in variable ,how to do that?

  daveriya

  10 replies

  14 years, 9 months ago

  By: SQLRNNR

• Count with Group By clause

  I need to pull the number of donors and the organization ID's of those donors (I need the orgID's a…

  hkflight

  6 replies

  14 years, 9 months ago

  By: NotoriousDBA

• query to get data in one row by avoiding duplicates and should populate null in case of no value

  Hi, I am having data in 2 tables in the following format and I should get data in a single row with…

  NLV

  1 replies

  14 years, 9 months ago

  By: NotoriousDBA