Viewing 15 posts - 406 through 420 (of 1,048 total)
yooooooooo!!!!!! :hehe:
What a day 😛
feels awsome when you earned 7 points at start of the day 😀
Thanks Steve:-)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 3, 2013 at 11:17 pm
You can use LIKE keyword for this-
SELECT dbo.Trnasction.Salesorder, dbo.SalesPerson.SalesPersonName
FROM dbo.Trnasction CROSS JOIN
dbo.SalesPerson
WHERE dbo.SalesPerson.SalesPersonName LIKE 'John%'
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 3, 2013 at 4:51 am
Nice question and nice explanation from Iggy and Hugo 🙂
+1
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 3, 2013 at 4:41 am
I have solved my issue 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 3, 2013 at 4:36 am
Abu Dina (7/1/2013)
RIGHT-CLICK folder, click properties then Security tab, click EDIT then give the SQL Server Service account Full control of the folder.
ohhh yes, that was permission issue with the...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 1, 2013 at 8:10 am
HanShi (7/1/2013)
2. copy the LOG file to the new location
3. Change the location in the master database with code:
ALTER DATABASE [dbname] MODIFY FILE (NAME =...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 1, 2013 at 7:57 am
GilaMonster (7/1/2013)
Operating system error 5 is Access Denied. The SQL Server service does not have full rights on that folder.
How to grant it ful rights?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 1, 2013 at 7:53 am
kapil_kk (7/1/2013)
I have data file and log file at different location.
data file at location:
D:\Folder1\test.mdf
while log file at place
D:\folder2\test_log.ldf
Now I want to move this log file to D\folder1\test_log.ldf
How can I...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 1, 2013 at 7:40 am
sorry I posted it a wrong place....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 1, 2013 at 7:35 am
Bhaskar.Shetty (7/1/2013)
You can create a trigger on Table A and update the Table B directly, why to create Table C just for later joining it with TableB.
thanks Bhaskar, magic tables...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 1, 2013 at 1:32 am
Danny Ocean (6/30/2013)
Good question with real fun 😀
+1 😛
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 1, 2013 at 12:24 am
Is this approach is right?
If I create a trigger on table A and insert those voucherno into another tableC...after that using JOIN I can update column modifieddate of table B...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 1, 2013 at 12:23 am
Cadavre (6/30/2013)
kapil_kk (6/30/2013)
thnks its working.. but can you plz explain me this part of query:SUBSTRING(VoucherNo,2,LEN(VoucherNo)) - ROW_NUMBER() OVER(ORDER BY VoucherNo, TransNo)
Sure. I'm removing the character from the start of the...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 1, 2013 at 12:01 am
niladri.primalink (6/30/2013)
hi All,Thanks for your reply. it is now working fine
@kapil: your code has helped a lot. Thanks buddy.
thanks Niladri, but Sean is right as he said using TOP...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 1, 2013 at 12:00 am
Cadavre (6/29/2013)
kapil_kk (6/29/2013)
that was trns1 only not trns2...
I tried it but not it is not possible with min...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 30, 2013 at 10:53 am
Viewing 15 posts - 406 through 420 (of 1,048 total)