T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Check .mdf and .ldf file size using T-SQL

  Hello, Please tell me a query which i can use to get a result like below table Database_NameDataTy…

  pankaj.baluni

  5 replies

  1 week, 3 days ago

  By: Srinivas Merugu

• Dropping Linked Server 'repl_distributor'

  Hi Guys, How Can I drop this linked server? ( There has been no replication setup in the environmen…

  srawant

  8 replies

  10 months ago

  By: ShuttleBILL

• Evaluating String Arithmetic Expressions In A View

  I Need Help, Please. I am trying to use a math formula stored as a string in a calculation in a rep…

  dougb 34607

  11 replies

  10 months, 2 weeks ago

  By: manojsenma8

• EXEC() results to populate cursor

  Within SQL Server I am trying to populate a cursor with no luck. After declaring a cursor you popu…

  kevvie.fowler

  11 replies

  1 year, 11 months ago

  By: pietlinden

• Calculate XIRR in SQL Server

  Hello All, Is there any way to calculate XIRR in SQL server using T-SQL. Kindly suggest. Thankx

  vijay.s

  13 replies

  1 year, 11 months ago

  By: anoush.farhangi@gmail.com

• DROP DATABASE with variable not possible?

  Hi, I wish to drop a database when it exists, like this: DECLARE @DBNaam varchar(50), @file1 varcha…

  FreeHansje

  4 replies

  2 years, 4 months ago

  By: wally_pons

• Evaluate a string Expression

  Hi, I have a table which has expression as a column and the data looks similar to the following . I…

  ramsatish

  18 replies

  2 years, 4 months ago

  By: JediSQL

• Calculating Last 5 Business Days and Next 5Days

  Hi All, Can you any help me out calculation of last 5 business days and next 5 business days. thank…

  koti.raavi

  18 replies

  2 years, 5 months ago

  By: jefferyjordan26

• SQL DB Email sending,HTML body formatting from two tables

  I am working on a sql server DB mail sending task in which the mail body should be as HTML. Data ha…

  suthaharmca

  10 replies

  2 years, 11 months ago

  By: Jeff Moden

• Script system stored procedures in master?

  Hi, I made quite a lot of stored procedures in the master's *system* stored procedures folder. (The…

  R. van Laake

  18 replies

  2 years, 11 months ago

  By: Jeff Moden

• Create table for members, groups and members_groups

  I am trying to CREATE TABLE for the following: Members table, groups table, members_groups table, I…

  candle_sd

  3 replies

  2 years, 11 months ago

  By: jose

• Cannot resolve the collation conflict

  Hello!   Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Lat…

  hemak

  5 replies

  2 years, 11 months ago

  By: hemak

• Random Phone numbers

  The table currently has a column with phone numbers, however I need to randomize/scramble them up s…

  colemanj

  21 replies

  3 years ago

  By: jackaustin

• Select Where Any Column Equals (or Like) Value

  All, Is there a simple way to do a select on a table to compare any column to see if it matches a v…

  Paul Anderson-304005

  14 replies

  3 years, 1 month ago

  By: WERT123q

• Last Execution Date Time of Stored procedure - SQL SERVER 2005

  Would like to know the Last Execution Date Time of Stored procedure . We use SQL Server 2005.  

  skb 44459

  2 replies

  3 years, 7 months ago

  By: Ant-Green