Viewing 15 posts - 1 through 15 (of 72 total)
where is express edition mentioned in question.
July 24, 2015 at 12:11 am
Thank you dear for your reply. I know all this. But by this they can see all databases present on server.although they can't access them.but i had a condition they...
June 7, 2015 at 5:41 pm
It could be any where, but both place should be accessible by sql server account. It will work on a network path too or a remote location.
May 29, 2015 at 9:45 am
--Configure advance options
sp_configure 'show advanced options', 1;
go
reconfigure;
go
sp_configure 'Ole Automation Procedures', 1;
go
reconfigure;
go
execute above code first. Then use this script, modify the script according to need like path. remove above code and...
May 29, 2015 at 5:15 am
Sure. @perry Whittle,
But what, if you have more than 50 or 100 databases or each database has multiple ldf & log files.
Will you write the query.
The script is...
May 27, 2015 at 3:06 am
Sure, Explanation is wrong -
You can understand this by below query :
CREATE TABLE mytable ( myid INT, mychar VARCHAR(10) );
GO
INSERT mytable
( myid,...
January 13, 2015 at 11:56 pm
MMartin1 (10/31/2014)
Vimal Lohani (8/17/2014)
DECLARE @i TABLE( mychar VARCHAR(50)
,deriv as SUBSTRING(mychar,1,3) --Use this
,newderiv as left(mychar,3));--Or use this
INSERT @i VALUES ('Steve'), ('Stephan'), ('Stephanie')
, ('Sterling'),...
October 31, 2014 at 8:12 pm
StefanMayer (10/16/2014)
After correcting the spelling mistakes ( if you run this query on a case sensitive instance) you will receive 2 rows!
What do you mean by correcting spelling mistakes and...
October 16, 2014 at 12:46 am
twin.devil (10/15/2014)
Comments posted to this topic are about the item <A HREF="/questions/unpivot/117130/">Unpivot</A>
HAHA,
Still wrong answer
admin has not tested it.
Answer should be two rows.
OrderIDProductNameProductQty
1 ...
October 15, 2014 at 10:49 pm
The answer is right for this kind of procedure :
CREATE PROCEDURE my_sp AS
SELECT id FROM my_table
The answer is Wrong for below procedure
CREATE PROCEDURE my_sp AS
SELECT Column FROM my_table
October 15, 2014 at 12:31 am
Viewing 15 posts - 1 through 15 (of 72 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy