T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Elegant way to change field to "Identity" type?

  We have a table with millions of records. The first column looks like 1,2,3,4,5,6.... but it is no…

  Barkingdog

  9 replies

  16 years ago

  By: Jeff Moden

• index on temp table

  Hi, I tried to put create index script on temp table after writing create temp table script. But th…

  dev05

  1 replies

  16 years ago

  By: Gail Shaw

• Conversion datetime

  Hi.. sorry guys actually i posted the wrong script..in the previous post...hergo my query. in my ta…

  sa06rdy

  6 replies

  16 years ago

  By: sa06rdy

• Time interval split

  Hi May you please help/guide with a query that would break a 24 hours day into 30 minutes intervals…

  Trybbe

  7 replies

  16 years ago

  By: Trybbe

• Opening IE through SQL-CODE

  Hi Friends, We have to open Internet Explorer using Sql Code in Sqlserver 2005. And it will automat…

  abhidbasql

  1 replies

  16 years ago

  By: ColdCoffee

• How to Execute SP in new databse

  Hi..would you guys have any idea about executing SP from new database pls? actually i have 4 datab…

  sa06rdy

  3 replies

  16 years ago

  By: GattJ

• Cursors Be Gone! by Gaby Abed, 2010/06/18 (first published: 2008/12/24)

  Hello community I was very curious about the article : Cursors Be Gone! By Gaby Abed, 2010/06/18 (f…

  luissantos

  1 replies

  16 years ago

  By: WayneS

• T-SQL to retreive changes to a Db

  Hi guys, Can you advise if there T-SQL code to assist retreiving all/any Updates recorded on a Prod…

  lozt 79000

  8 replies

  16 years ago

  By: Paul White

• Help with AWE

  Hi I need help with awe i have SQL 2008 installed on windows server 2003. server memory is 8GB. i u…

  Francisco Lopez Lopez

  14 replies

  16 years ago

  By: Francisco Lopez Lopez

• syntax error in query

  Hi , this is my store procedure , i have an error message : Incorrect syntax near the keyword 'wher…

  nazaninahmady_sh

  7 replies

  16 years ago

  By: Tomasz Jureczko

• QUERY T-SQL

  Hello ! Guys Please supply a query regarding the table and the conditions. Report Name: EJ4 - End J…

  Shintu

  2 replies

  16 years ago

  By: ColdCoffee

• http call embedded in stored proc

  So i have a sql sript that i'm converting to a proc. Theres a chunk of sql that runs then the end u…

  BaldingLoopMan

  14 replies

  16 years ago

  By: jvanderberg

• Howw to Group by some group

  Hi I have a table declare @table TABLE( K int , [type] int , [value] int ) INSERT INTO @table SE…

  nguyennd

  2 replies

  16 years ago

  By: nguyennd

• Possible to pass many records to sp_send_dbmail without using a loop?

  I need to use database mail in SQL Server 2008 to send out various notifications. We have a table …

  Maxer

  3 replies

  16 years ago

  By: Maxer

• how to identify numbers in varchar column

  Hi I am facing different issue here, I got a column like this. Formatted_Name (data type varchar) …

  anitha.cherukuri

  7 replies

  16 years ago

  By: ColdCoffee