CONTEXT_INFO - any plans for future deprecation? 4 250 (11/26/2009 10:30:10 AM)
Hi, We're thinking about using CONTEXT_INFO to pass username to the audit trail triggers. Is this wise? Are there any plans to deprecate CONTEXT_INFO in a future version? Can anyone confirm that it's still...
JimLad

Facturation et nouveau site web 1 134 (11/26/2009 3:54:17 PM)
Salut Pierre, Toujours moi, Sylvain. Tu m'as l'air bien occup� ces temps-ci. As-tu re�u mon dernier courriel au sujet de la facturation? J'aimerais bien finaliser car j'ai besoin subitement d'...
Sylvain

Select Query Problem 10 112 (11/24/2009 2:23:53 PM)
hi all The table have lots of duplicate rows except for the last column skills The skills has diffrent values some rows 'Middle East' and the other rows 'Resident Engineer', 'planner' etc When the use...
roma_victa

How to write a trigger that updates a column in each row of an update set? 2 377 (11/25/2009 9:44:21 PM)
An issue I've ran into before but never really got a handle on is how to set up a trigger (sql 2005) so that a column value is updated as appropriate for each row, when making a bulk update? In my attemp...
mat

sql result set where value increments 2 155 (11/26/2009 4:19:20 AM)
Hi, I have a table of data logged by a factory automation process. The table consists of a timestamp, temperature values, flow rates and sequence step numbers. A new row is recorded every 2 seconds. I wa...
Al

Create Login with T-SQL 3 292 (11/26/2009 12:52:35 PM)
Hello, I am creating, using T-SQL, a database with its file groups, tables, constraints, etc. Can I also create, using T-SQL, a Login with Username and Password to access that database? Usually, I go...
shapper

Cascade Delete 2 145 (11/26/2009 12:08:09 AM)
Hello, I am creating the following tables: create table dbo.Albums ( Id int not null, [Key] uniqueidentifier not null rowguidcol constraint U_Albums_Key unique, [File] varbinary(max) filestream...
shapper

Recommended practice for JOIN syntax? 2 166 (11/26/2009 9:44:22 AM)
Hi, I'm currently reading a SQL Server 2008 book that states that the following queries will return equivalent results but that the first one is not recommended practice. SELECT a.ProductID, a.Name, b.S...
Frank

bulk insert a csv file into a Sql 2005 table 2 372 (11/25/2009 5:16:01 PM)
I have a csv file called test.csv located in c:\test folder I need to transfer all data into a table call Testtable In the csv file, there are fields can be with nulll value. The column delimator is " ...
Utf

tough sql statement help please 5 137 (11/25/2009 3:32:29 PM)
Howdy - and thank you in advance for any help!!! Here is what I have so far: SELECT sp.FirstName + ' ' + sp.LastName AS SalesPersonName, g.*, COUNT (CustomerId) AS GoalAcquired FROM Goal g INNER JOIN Sale...
tnichols333