Topics
Started by
Posts
Last post
Hi, I want to be able to select any five rows in random, from a table that I have. How do I do this…
9 replies
By: noeld
I would like to extract data from SQL server 2000 and need to generate AIF files for EDI transactio…
1 replies
I have the following query in Access. UPDATE [RiskSysSum of Source ClaimType] SET [RiskSysSum of So…
3 replies
By: noeld
How to restore a database backup to a specified databse with a different name (and show a progress …
2 replies
Can any tell the equivalent of ORDSYS.ORDImage.processCopy (oracle) in sqlserver. for instance : O…
1 replies
By: Lowell
Does anyone have a script handy that tells you the space left on a filegroup where multiple f…
2 replies
By: ishaan99
I need help to optimise this query; as currently it takes a lot of time to process. /*This collects…
25 replies
Derived Tables I have two queries: SELECT DISTINCT tot.po_tble_cod FROM po_tabelatotal tot (…
2 replies
Greetings I am trying to write a stored procedure on Server 1 to run a query against linked Server …
4 replies
I have two tables. The first is named tblEquipment and, for simplicity sake, it has just one …
3 replies
Dear All! I want to display all available SQL Servers over a local network. I have found a C# code …
3 replies
Hello friends! Is there a way to create a text file with T-SQL code? I have to create a stored…
2 replies
By: Flavio
Hi, How to find the columns involved in a computed column without string manipulation? I want only …
3 replies
By: sushila
I am getting date returned from various tables in mm/dd/yyyy format but some of the values in the t…
6 replies
I am writing a script that will return the backup sizes for last night's DB and log backups. Howev…
3 replies
Viewing 15 topics - 10,366 through 10,380 (of 17,082 total)
You must be logged in to create new topics.