Topics
Started by
Posts
Last post
Does anyone know of an equivalent in SQL Server 2000 for what Oracle calls a synonym and DB2 calls …
4 replies
Hi.. I have noticed a strange problem with SET ROWCOUNT when it is used with variables.. in this ca…
19 replies
What is the best way to strip out the seconds of the current date returned by getdate()? so far I h…
6 replies
Hai everybody, I have a table with text column. The structure is TblData ----------- LngIdnumeric…
1 replies
I have a varchar(100) column and I need to right justify the characters in positions 1-4 and 6-9. W…
6 replies
Hello... Me again... If I have a non-simple computed column formula like: (((ColumnA * ColumnB) / C…
4 replies
Hai everybody, I have a table with text column. The structure is TblData ----------- LngIdnumeric…
2 replies
if(select databaseproperty ('pubs','IsFulltextEnabled') ) = 0 execute sp_fulltext_database 'enabl…
1 replies
Hi all ... just wondering if someone knows of a way to figure out when an object (ie. table) was l…
4 replies
how to run '*.exe' files or '*.bat' files in sql server? thanks.
5 replies
Hi all, I am generating a report for duplicate companies in a "Company" table. These are our custom…
2 replies
Good day all Could anyone advise on the best way to manage financial data extraction ? The problems…
6 replies
I have a trigger that simply copies the value in one field to another as such: Create TRIGGER tMai…
5 replies
I have the following SQL which retrieves a set of translated text through a generic translation sto…
13 replies
a) select a.col into #table_ex from a b) create table #table_ex (c int) insert into #table_ex(c) se…
4 replies
Viewing 15 topics - 15,931 through 15,945 (of 17,082 total)
You must be logged in to create new topics.