Topics
Started by
Posts
Last post
Hi , Is there any Way to delete all the datas in all the tables of a database without reloading the…
3 replies
Hi. I have a problem where I'm storing a very large xml sting in a field of type ntext in the datab…
5 replies
I have a temporary table with the following fields InvoiceWFID , InvoiceID, , Seq, num_lev, Appro…
4 replies
In the following select statement, the Appointment and Ailment tables are connected via the Appoint…
5 replies
We have a table that contains 12 columns, one of which is of TEXT datatype and contains from 1 to 1…
8 replies
SET @SeqNo = (SELECT MIN(ID) FROM Reporting.SequenceNumber WHERE @ReportName IS NULL) I hav…
5 replies
Dear All, I Have 2 tables Table1 and Table2 The Table1 is structure is like Pno bigint(Primary Key)…
2 replies
Hello all, I'm doing a funky file import in SQL Server 2000, where a certain field has different fo…
6 replies
Dear All, declare @a varchar(30) select @a = "a b" select @a = replace(@a, char(32), rtrim('')) …
5 replies
Dear Experts, I have one text file.I have to split this file in the below format. Content of the Fi…
17 replies
Dear All, How to find the number of table used in a procedure ? -----------------------------------…
9 replies
On of the central tables in our system has a unique constraint defined on a column that should have…
2 replies
Hi: I have the following query that may return null if certain dates are selected, I want to displa…
6 replies
Hi Could anyone help me on how to convert a string such as 20050910 to a date format e.g 10/09/200…
7 replies
If I use checksum() in SQL2000 will I get the same results in 2005 and later versions. EX: select c…
9 replies
Viewing 15 topics - 3,076 through 3,090 (of 17,082 total)
You must be logged in to create new topics.