Viewing 15 posts - 1 through 15 (of 47 total)
Thank you. Using Net Use solved the problem.
Also here https://www.mssqltips.com/sqlservertip/3499/make-network-path-visible-for-sql-server-backup-and-restore-in-ssms/ is a...
May 6, 2018 at 6:22 am
Is there any way to disable a user in visual way?
I cant see red arrow even if I remove all role memberships for a user.
November 3, 2015 at 5:17 am
Sorry it had syntax error, try this:
CREATE TRIGGER triggerName ON test.dbo.rental
FOR INSERT
AS
DECLARE @VEHNO AS NVARCHAR(8)
DECLARE @CUSTNO AS NVARCHAR(5)
SELECT @VEHNO=VEHNO,@CUSTNO=CUSTNO FROM INSERTED
IF
(
(NOT EXISTS (SELECT 1 FROM test.dbo.CUSTOMER where id = @CUSTNO))
OR
(EXISTS...
October 12, 2014 at 5:11 am
I didn't test it, but it should be fine
CREATE TRIGGER triggerName ON tableName
FOR INSERT
AS
IF NOT EXISTS (SELECT 1 FROM customerTable where id = 'customerID')
OR
IF EXISTS (SELECT 1 FROM rentedCarsTable WHERE...
October 12, 2014 at 4:00 am
It would be best if you break your table structure into 3 tables but for this particular architecture there is no way unless something like this:
SELECT * FROM LeaveType WHERE...
October 12, 2014 at 2:16 am
Sorry I think I asked my question in wrong section. I just searched for 'oracle' with ctrl + F through my web browser and I'm in here.
I working with oracle...
July 14, 2014 at 10:38 pm
I don't care what requirement is, I send my resume for them any way.
And even if you fail in interview its still good, because you can research about questions they...
March 19, 2014 at 2:03 am
kumariannapureddy (3/19/2014)
SELECT EI.EmplID,ER.Designation FROM #EmpIDs AS EIINNER JOIN #EmpRoles AS ER
ON EI.EmplID = ER.EMPID
WHERE EI.EmplID IN (1,3)
UNION ALL
SELECT * FROM #LatestRoles
ORDER BY EmplID
You shouldnt write queries that work only with...
March 19, 2014 at 12:40 am
WITH CTE (EmplID,previousRole,currentRole) AS
(
SELECT #EmpIDs.EmplID,
#EmpRoles.Designation AS [Previous Role],
#LatestRoles.Designations AS [Current Role]
from #EmpIDs
INNER JOIN #EmpRoles ON #EmpIDs.EmplID...
March 19, 2014 at 12:36 am
I prefer to write this kind of queries with this technique:
Select
(SELECT DOB FROM [Table] WHERE DOB IS NOT NULL) AS DOB,
(SELECT LNAME FROM [Table] WHERE LNAME IS NOT...
March 18, 2014 at 11:51 pm
Try it, in SQL Server Management Studio right click on your database and choose "tasks --> shrink --> Databases"
March 17, 2014 at 11:51 pm
I don't want to do spam, but there is something misty in your table relations for me.
You said you found a solution with cursor approach, but i can not find...
January 28, 2014 at 1:31 am
In my opinion there is no need to checking sys.objects for the code given in the original post 😀
DECLARE @sql AS NVARCHAR(MAX)
SET @sql = N'Select something from ' + QUOTENAME(@TableName)...
December 25, 2013 at 9:33 am
Thanks Grant Fritchey, Ill take a look at that.
According to this:
http://technet.microsoft.com/en-us/library/ms176114.aspx
Now to add to my troubles:
how QUOTENAME('abc[]def') produce [abc[]]def] ? 😀
Well, Its a new question. Ill ask it in a...
December 24, 2013 at 6:08 am
Viewing 15 posts - 1 through 15 (of 47 total)