Topics
Started by
Posts
Last post
I am trying to implement table change log. For this we decided to create a BEFORE_UPDATE trigger. I…
10 replies
select proemail from pro join res on pro.proln=res.resln and pro.profn=res.resfn and…
6 replies
We had initially set up a client db with "SQL Server Authentication" in place. When it came to sch…
3 replies
Hi, I’m trying to build a table dynamically by concatenating a string. Set @v_exec_str = ‘create …
6 replies
Hello: I hope someone can help me with this--I'm at my wits' end! I inherited a biological taxonomy…
4 replies
drop table #temp select distinct Empid, jobid , salary, age into #temp from Revenue.dbo.BudgetRevCA…
2 replies
Hello, I am trying to search for a specific text string however I do not know what table it resides…
2 replies
Hi , i need your help to present this master-detail form by tsql, i have sample data like this; t…
5 replies
Hi, There is a table with 50 columns: I need to select 48 or 49 columns only. Is there any way to d…
22 replies
I am trying to define a Full Text index on an indexed view. I managed to define a unique and cluste…
1 replies
Hey guys, I am working on an application, which needs to query the xml document from another serve…
1 replies
Hi All, I've got a couple of queries that run on a linked server. We just upgraded the SQL Serve…
1 replies
It's clear from behavior that full text indexing is treating symbols (such as @ and &) as "noi…
1 replies
I have a sql 2005 db used to archive hundreds of csv files that i store in a varchar(max) field. I…
1 replies
Hi all, I need to do a "simple" thing. I need to transfer some data from a local SQL Server 2005 to…
1 replies
Viewing 15 topics - 7,246 through 7,260 (of 12,234 total)
You must be logged in to create new topics.