Viewing 15 posts - 1 through 15 (of 18 total)
Excellent article! Good one Vishnu.
December 7, 2018 at 12:07 pm
February 5, 2018 at 1:15 pm
Wrong Answer! I provided 3 and it skipped the first three rows as its 1-based. I just got Erasmo,0 and Brett,2 in my table.
So Answer should be 2.
Load.Txt Content
-------------------
Heading
Name,Value
Sreejith,1
Erasmo,0
Brett,2
May 19, 2015 at 12:12 pm
Story of my previous company (mine was around 3000 employees company with a DBA team around 15 people in different verticals, sql server 4 people were there in which one is...
January 8, 2007 at 5:58 am
Whats the error message errorlog file of Sql Server showing?
Cant you fix the drive which find faulty...
Is it not mirrored? If you can bring back the drive with help of...
May 30, 2006 at 8:50 am
If you guys tried to attend all QOD question then you would have came accross one DLL Hell question. This is another way of asking the same question
February 13, 2006 at 2:03 am
Do it with Stored Procedure.... pass the table name and feild name as arguments.... I dont know what u really want and doesn't know when will u have tablename & feildname...
January 24, 2005 at 1:37 am
havent u see the previous post.......
we can use databasename.owner.SP to execute the same SP for different database.... I could find u replying...
January 20, 2005 at 1:48 am
'xp_regread' doesnt have optional arguments to provide remote access..... u can run an remote SP by linking other server to ur server..... the linked server concept..... ohhhhh iam making it...
January 20, 2005 at 12:41 am
Sorry its,
'server_name.database_name.dbo.sp_name'
Typing mistake
January 20, 2005 at 12:12 am
Sure u can use it....
for eg...
database_name.dbo.sp_GetEmployees will point to particular database Employee table...
i.e A.dbo.sp_GetEmployees -> point to A's Employee table...
I would add to other additional points...
1. Dont use 'sp_......'...
January 20, 2005 at 12:09 am
Go thru this link,
http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=529
It uses table variable & While loop to handle this scenario..... I would suggest to go for this only if ur record count is small.... or...
January 19, 2005 at 11:39 pm
Its better not u use such type of 3rd party products, I cannot even beleive that its creating so much ad-hoc tables and not deleting it... then why do we...
January 14, 2005 at 3:19 am
Viewing 15 posts - 1 through 15 (of 18 total)