T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• How to find current database being used by Tsql

  Hi all,, Is there any way to find out which database is being used currently using a TSQL command? …

  vikas khirwadkar

  1 replies

  17 years, 12 months ago

  By: Ian Scarlett

• Export using openrowset

  hi INSERT INTO OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=c:\test\Test.xls;', …

  vsjayashri

  2 replies

  17 years, 12 months ago

  By: vsjayashri

• Too large to UPDATE ?

  Column name : ExecSummary, VARCHAR(8000) UPDATE dbo.tblRegistration SET ExecSummary=' extensive exp…

  onlo

  2 replies

  17 years, 12 months ago

  By: onlo

• Inner Join

  I want to SQL Server 2000 more 3 table join using Inner Join and get more fields each tables. pl gi…

  sl.indika

  3 replies

  17 years, 12 months ago

  By: sl.indika

• FOR XML PATH variable

  I have a stored procedure that returns xml. Using the FOR XML type of query. It is fairly complic…

  mjackson-527564

  1 replies

  17 years, 12 months ago

  By: RBarryYoung

• How to write Insert Trigger

  Hi , I am new to trigger. I want to create a insert trigger for a table(table 1) ,in which w…

  Rahul-765886

  9 replies

  18 years ago

  By: John Rowan

• (Riga) WAITFOR DELAY. Can I keep querying until data is found?

  I can't understand the behavior of WAITFOR DELAY. Why this code flows? WHILE NOT EXISTS (select * …

  JMI

  9 replies

  18 years ago

  By: GSquared

• tricky SQL

  How can I convert first result set to look like second one??? SQL to create and populate table is a…

  ALI-408105

  3 replies

  18 years ago

  By: ALI-408105

• How to Delete a Folder using an xp_cmdshell extended procedure

  Hi there, I need to delete an entire Folder that gets created programmatically on a daily basis. I…

  sidpchandra

  2 replies

  18 years ago

  By: Timothy J Hartford

• stored procedure based on conditions

  Dear All How can I write a stored procedure based on condition. At the moment, my code is not work…

  Johann Montfort

  5 replies

  18 years ago

  By: Johann Montfort

• How to I create a log file alert in sq2005

  My company want me to write the task that will send email out when the log file reach every 100MB (…

  nicknguyen74

  3 replies

  18 years ago

  By: GSquared

• Stored Procedure Development Query

  I have one Main Stored Procedure. I will be executing multiple stored procedure one by one. I would…

  Paresh Randeria

  1 replies

  18 years ago

  By: Grant Fritchey

• problem with count(*)

  Hi Please help i have a table with the following columns id identity Event_Startdatedatetime Ve…

  Parmesh Althi

  3 replies

  18 years ago

  By: Parmesh Althi

• Join tables without exact match

  Hello. I need to join two tables (each table has only 1 column). The problem is that the record fro…

  AT_0622

  2 replies

  18 years ago

  By: AT_0622

• insert problem

  Hello Guys, I seem to have a weird problem, can insert data into table X using T SQL, but cannot in…

  toparsi

  5 replies

  18 years ago

  By: GSquared