CONTEXT_INFO - any plans for future deprecation?4250 (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 web1134 (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 Problem10112 (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
sql result set where value increments2155 (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-SQL3292 (11/26/2009 12:52:35 PM) Hello,
I am creating, using T-SQL, a database with its file groups, tables,
Can I also create, using T-SQL, a Login with Username and Password to
access that database?
Usually, I go... shapper
Cascade Delete2145 (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
[File] varbinary(max) filestream... shapper
Recommended practice for JOIN syntax?2166 (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 table2372 (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 "
tough sql statement help please5137 (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