Viewing 15 posts - 1 through 15 (of 32 total)
+1 I would like to know a sample business justification too.
September 7, 2011 at 7:28 am
Try below steps:
1. Take the value of newley created unique Id in a variable.
2. Now create a CTE which selects rows from table 2 which matches with previous unique id.
September 7, 2011 at 1:00 am
working with new data bars will be easy,I have tried them on R2 CTP, let the R2 come out, for using maps first get an idea about spatial datatypes introduced...
February 19, 2010 at 8:14 am
SELECT ROW_NUMBER() OVER(PARTITION BY rowid ORDER BY rowid) as rownum , * INTO #MaintTable1 FROM #MaintTable
DECLARE @cnt int
SELECT @cnt = max(rownum) FROM #MaintTable1
WHILE @cnt >= 1
December 8, 2009 at 5:14 am
If You are using management studio just right click your database select detele, watch for a checkbox at end of this popup saying "Close exixsting connections" just select it and...
July 24, 2009 at 6:32 am
Just Check IF @@Trancount =0 ROLLBACK your transaction.
Also if you are using SQL 2005 why not use a TRY catch in your procedure.:-)
July 24, 2009 at 6:29 am
dont you need a .com or .org or .gov etc...at the end 😉
July 24, 2009 at 6:24 am
You can use PIVOT operator see SQL server books online for same.
July 24, 2009 at 6:17 am
If not intrested in replication you can use triggers and TSQL scripts in SQL jobs to keep your databases in sync.Though it would be good only if you are comfortable...
July 24, 2009 at 6:12 am
Use Alter table as suggested its nota difficult thing to do just go through books online.
say for example if you want to change datatype of a column say...
July 24, 2009 at 6:05 am
this will also work if u dont like 0's 😉
select dateadd(dd, datediff(dd, 1, getdate()), 1)
July 24, 2009 at 4:41 am
If you have a visualsource safe or Source depot or VSTF available please use it to avoid any big problem. If you have none then make a directory structure and...
July 24, 2009 at 4:30 am
Not a good way buddy, you should have tooka backup to a network location and then drop database and restore the new one , i dont see any profit...
July 24, 2009 at 3:02 am
Try repairing and if it doesnt work for you, only solution is to reinstall(dont forget to backup your databases ;))
July 24, 2009 at 2:51 am
You can get same performance with :
SELECT t1.vendorid,t1.vac1 from table1
WHERE t1.vendorid not in (SELECT t2.vendorid from table2)
AND t1.vac1 not in (SELECT t2.vac2 from table2)
July 21, 2009 at 12:36 am