Viewing 15 posts - 2,416 through 2,430 (of 2,462 total)
plz provide the dummy script...:cool:
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 9, 2008 at 4:25 am
add following code in ur script
declare @db as nvarchar(50)
set @db='Employee'
declare @lstr varchar(100)
set @lstr ='select max(empId) as lastEmloyee from ' + @db + ' ..Employee'
exec (@lstr)
hope this will work...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 9, 2008 at 4:23 am
I dont know what exaclty u want but if u want to incorporate
ur SELECT command into Procedure then
see this................
DECLARE @LSTR NVARCHAR(300)
DECLARE @projectId INT
--SET @projectId = 90
SET @LSTR =...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 9, 2008 at 4:14 am
On what basis you want to update targetid in T2 from T1
there shud be some criteria or condition 😉
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 8, 2008 at 6:45 am
Dear SSC Veteran,
On production that guy wants to avoid UNION and you are executiing it CURSOR
dont u think it will increase network traffic and degrade server performance:D
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 8, 2008 at 6:43 am
Thanks ...but have u run this ..it only giviing system relevant information..
But buddy i want user databasee specific information
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 5, 2008 at 5:42 am
Thanks .i 'll try this ...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 4, 2008 at 9:50 pm
Can anybody tell me which dynamic managemant view or function will be used to get information ??
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 4, 2008 at 9:14 pm
Thanks :):)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 3, 2008 at 3:08 am
i want result as sql query:)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 3, 2008 at 12:59 am
Can't we use OPENXML queries without using it ??
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 31, 2008 at 9:20 pm
Thanks for ur response..but i need someone who can put light on it with his views.....
I have read thta BOL but i couldnt get it:)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 31, 2008 at 12:00 am
try this out
select * ,op_bal + quantity from #Temps
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 26, 2008 at 2:32 am
see linked server is not a physical machine ...when we want to execute a query from server A to server B...then Server B act as Linked server
Linked...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 20, 2008 at 9:58 pm
thanks............now please see this also
please run thi script....
set statistics profile on
exec sp_helpserver
set statistics profile off
And explain following terms...how they should be analyzed?
--PhysicalOp
--logicalOp
--estimatedIO
--EstimateCPU
--AvgRowSize
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 20, 2008 at 1:43 am
Viewing 15 posts - 2,416 through 2,430 (of 2,462 total)