Topics
Started by
Posts
Last post
When I run a script that uses COMPUTE BY in SSMS I get the desired results. When I try and create …
3 replies
Hi, I need to copy a big table (about 250G, basically used to store images) that I have on a MSSQL …
13 replies
Dear, I want to see all DML operations performed by a specific computer to track the user activitie…
2 replies
Is it possible to update 2 Db with 2 different sqlConnections under same Transaction ? Thanks.
4 replies
select cast(COL1 as datetime) from TABLE where COL1<>'' and isdate(COL1) =1 and cast(COL1 as …
3 replies
select cast(COL1 as datetime) from TABLE where COL1<>'' and isdate(COL1) =1 and cast(COL1 as …
1 replies
I am getting following error while creating index Error/Warning Message is :- Warning! The maximum …
4 replies
Upgrade to 2008r2 from 2000. Backup the 2000 db and restore to 2008 r2. Create all application user…
8 replies
is something like this possible? SELECT CASE WHEN (@X = 1) THEN COLUMN1, COLUMN2, COLUMN3 …
6 replies
I run the following query on the AdventureWorks database. SELECT ContactID, LastName, Phone FROM Pe…
9 replies
Hi Does the option "Auto Update Statistics Asynchronously" work for update ,delete and insert stat…
1 replies
I have a query like UPDATE a SET oldRemarks1.modify('insert <Value_Py>{sql:column("b.collecti…
3 replies
Hi All, I could not format a column in the below, declare @table table (mMonth smallint); insert…
5 replies
How do you add commas for numeric values to separate thousands without the 2 decimal places of a mo…
1 replies
How to disable AUTO_CREATE_STATISTICS and AUTO_CREATE_STATISTICS for all databases in single step?
2 replies
Viewing 15 topics - 12,376 through 12,390 (of 30,222 total)
You must be logged in to create new topics.