Topics
Started by
Posts
Last post
Hi, Could any one tell me how I can list all trigger in a database? With regards Sunil
3 replies
Hi I have an update which works fine. UPDATE Table1 SET T1.col1 = T2.Name FROM dbo…
2 replies
When running BULK INSERT AuditDBA.dbo.tblPS_FILE_LOG FROM 'C:\PSfiles.log' WITH (FIELDTERMINATOR = …
2 replies
Hi, I am attempting to convert some datetime data into a varchar in the ISO8601 format with timezon…
1 replies
I am loading data from .txt file with selected column only. (4 fields out of 40 fields) I had creat…
2 replies
Hi, It should work on SQL2005 and 2000. id name -- ----- 1 John 1 Bill 1 Marc 4 Jack I need: …
3 replies
Hey all, I am spinning my wheels to get this thing resolved unable to do that. How can i convert th…
5 replies
OK, that topic doesn't make much sense, but I'm not sure how else to phrase it. Well, then, how abo…
9 replies
Hi I am loading data from .txt file 8.0 5 1 SQLCHAR 0 8 "|" 1…
3 replies
I am trying to do a dynamic where clause in a stored procedure using coalesce but I am having probl…
5 replies
By: noeld
Hello I have the stored procedure that I need to run on several databases. It is stored in the mas…
4 replies
Hi there, How can I do a search on the % sign in a like clause on sql2k5 sp2 ?? I have try to d…
6 replies
By: Foutchy
Hi all, Why would you use Hexidecimal in SQL ? Other than for fun? Thanks Chris -------------------…
5 replies
select top 5 left(convert(varchar(10),EffectiveDate,101),10) [Date] , convert(varchar,cast(…
3 replies
By: jcollins
Hi , We have the databases with exactly same data on SQL Server 2000 and SQL server 2005. I noticed…
8 replies
Viewing 15 topics - 9,721 through 9,735 (of 12,230 total)
You must be logged in to create new topics.