Topics
Started by
Posts
Last post
We have a SQL 2005 database and there are some old records that need to be deleted with the matteri…
5 replies
Hi, I tried to execute in SQL Server 2005 Query Analyzer the following statement: SET IDENTITY_INSE…
2 replies
hi, say I have a field [text] with the data 'Jamie's Car' how can I show just the word 'Jamie's' ?
7 replies
I have a simple search form in MS Access (ADP) that passes parameter values into a stored procedure…
2 replies
Hi All, I've read the newsletter for a long time and I remember seeing a fuction that might help me…
7 replies
Hi, I have a application with more than 3000 pages. i have to take a list of Tables used in the ap…
9 replies
Why do we use tablesample if it only gives approx number of rows. What is the advantage of using t…
4 replies
hi, i have a doubt. PK-FK constraints will improve the performance with respect to speed or will it…
7 replies
Would like to return "Healthy" + Type. Where 'Type is the column name in my table. For example; SEL…
2 replies
How do you declare a linked server? Something like this failing example: DECLARE @linkedserv CHAR;…
7 replies
My manager asked me to update the column description for data dictionary. IS there any fastest way …
3 replies
If I have procedures which pull a set of data for a report, how would I set a condition to run it o…
5 replies
I Have a table "DemoPRofile" as shown below dPId demoNo MTrip …
3 replies
Any way to check multiple conditions in one WHEN using a CASE statement e.g. CASE somefiled WHEN …
5 replies
Hello, script: if object_id('tempdb..#temp') is not null drop table #temp create table #temp (item…
25 replies
Viewing 15 topics - 6,256 through 6,270 (of 12,234 total)
You must be logged in to create new topics.