Topics
Started by
Posts
Last post
Hi All, Is it possible to log error message to windows Event Viewer through T-Sql Statement? Regar…
1 replies
Hi I have a table consisting of millions of records. and I am looking for only few records like: se…
1 replies
Guys, I need to find missing data within a set of records. There is a table which has data for a gr…
4 replies
By: PNS
Hi, what is the best solution for archiving the data.I cannot keep in the database more than 6 mont…
3 replies
By: - Win.
Ok i got a csv in permon and i brought into SQL Table SELECT [(PDH-CSV 4#0) (Pacific Daylight Ti…
2 replies
Looking for SQL to render a string that truncates anything to the right of the character "\" 3 ex…
2 replies
By: Doylie
Hi, I'm attemting to construct a XML document from data stored in SQL tables. Below is a sample st…
3 replies
hi, I have written this script but there is an error by dbcc. how can I do this ?thank you for any …
5 replies
I have a stored proc on a DB that runs once an hour that analyses recent web traffic. At the beginn…
7 replies
I have forgotten how to search for a column name through a certain DB. For instance I need to find …
3 replies
By: WayneS
Hiya, Either I am overtired and missing something simple, or there is a problem using isnull \ null…
6 replies
how to reseed a table variable fileds identity value
2 replies
By: SwePeso
Hello, I have a rather simple question but I'm a bit stuck... I want to perform a datediff between …
6 replies
Hi folks, I have a table with records like 1 aaaa John 2 bbbb Jane 3 aaaa John 4 …
14 replies
By: mtassin
Am getting the infamous Msg 7391 error: OLE DB provider "SQLNCLI" for linked server "DEVFTDB1" retu…
1 replies
By: LeeM
Viewing 15 topics - 6,016 through 6,030 (of 12,230 total)
You must be logged in to create new topics.