Description:
Microsoft SQL Server newsgroup.
|
|
|
WHERE IN (SELECT) with multiple columns
|
| |
A continuing annoyance is that I can do stuff like this in SQL Server: SELECT * FROM X WHERE A,B IN (SELECT A,B FROM Y) This is getting more complex if any of A or B can be NULL. Is there an alternative in SQLServer 2005+ to implement such predicates? Pete
|
|
|
Need advice on product specs table
|
| |
Hi, I'm trying to figure the best way to store product specs data e.g. dimensions, weight, power requirements, etc. Because the database will contain a wide variety of products and in time, there will be new specification categories, I'm inclined to have a table that defines specification categories and another where SpecIDs and values are... more »
|
|
|
rolling back / undoing an update task
|
| |
I accidentally used this statement when trying to set my 'names' column all to lower case in the away condition: update mytable set names = lower('names') where home = 'away' ..as this changed all the names to literally 'names', wondering how to use ROLLBACK to undo this, or is there another recovery method.... more »
|
|
|
im internet geld verdienen forum , schnell geld verdien , em poker online spielen , geld online casino , sofort geld gewinnen , poker muenchen , poker spielen um , pokerschule , ganz leicht geld verdienen , schnell geld veridenen ,
|
| |
im internet geld verdienen forum , schnell geld verdien , em poker online spielen , geld online casino , sofort geld gewinnen , poker muenchen , poker spielen um , pokerschule , ganz leicht geld verdienen , schnell geld veridenen , * * * +++ GELD ONLINE VERDIENEN +++ GELD IM INTERNET VERDIENEN +++ *... more »
|
|
|
SCHEMABOUND Views over multiple databases or servers
|
| |
Hello. I'd like to use schemabinding on a view that takes its data from multiple databases. I understand that SQL 2000 is incapable of doing this, does anyone know if this is possible in 2005 or even 2008 or am I just wishing on a star? Thanks in advance, Nick.
|
|
|
SQL optimisation, stop the sub query as soon as an error is found
|
| |
Hi guys, first post here. I have the following problem I have records in a source table which I have pulled out to a temp table and built some indexes. As part of this extract I have ranked the records using the rank() over funcitonality to force a sequence key resetting on PATHWAY_ID. I am now trying to validate that the records have been entered... more »
|
|
|
Sql Job runs Slow in 2008 compared to 2005
|
| |
The following job runs in under 10 seconds in 2005 but takes 3 minutes in 2008. update Flavor.dbo.Inventory set Flavor.dbo.Inventory.user1 = 'PS' where Flavor.dbo.Inventory.InvtID in( select distinct FP.FormulaID from Flavsys.dbo.FormulaProcedures FP, Flavor.dbo.Inventory I, Flavsys. dbo.Formulas F... more »
|
|
|
temp tables with UDF defaults
|
| |
how do you get a temp table to use a udf in your db? I tried putting the databasename in front of dbo but it complained about it. Does the function need to be created in tempdb too? Create function mydate() returns datetime as begin declare @d datetime; SET @d = getdate(); return @d; end; CREATE Table #t2... more »
|
|
|
Why is displayed date format different in SSMS 2008?
|
| |
Hello! Can anybody tell me where I can set in SQL Server Management Studio 2008 that I will see date columns formatted in style "dd.mm.yyyy" like it is in SSMS 2005 or in SQL 2000? With that I mean if I open any table in any db with datetime columns inside with command "Edit Top 200 rows" or "Select Top 1000 Rows" I... more »
|
|
|
SQL syntax (part 2)
|
| |
I accidentally posted before I was done on the last one..... I have a query that I would like to modify as follows, but am not quite sure how to do it: SELECT [GenEvents EventLog].EventTime, [GenEvents EventLog].ActorID FROM [GenEvents EventLog] WHERE ((([GenEvents EventLog].ActorID) Is Not Null) AND (([GenEvents... more »
|
|
|
|
