I am a SQL Server DBA and we are going to move to have to support Biztalk server also. Can anyone tell me what id the skillset I should have to...
I need to add a new column having datatype varchar in a table that is already configured for transactional replication. The replication occurs every...
I was trying to select some data by doing an inner join from a different server using linked server. I noticed it was taking an unusually long time...
I have run into a very simple query. Since I rarely do SQL programming, I am asking this query. I have results returned from two queries. I need to...
create table tSecurity(Id varchar(20),RoleId int,ModuleId int,FeatureId int,AccesslevelId int,dtCreateDate datetime,dtlastUpdatetime datetime,version...
Can anyone figure out why this WHILE loop never ends. drop table #temp1 drop table #temp3 create table #temp1(title varchar(50),const int,timestamp...
The second field is numeric. I'm a fresher. Pls help.
create table EmpDetails (Name varchar(200),ID int,YearofJoining varchar(15)) insert into EmpDetails values('Jack',1800,'2001') insert into...
I have an employee table from which I have to select data for the given employee (input) first and then the remaining employees in ascending order....
I have a table with the following data: create table #temp(ID int,Language varchar(25),Title varchar(50),Story varchar(100)) insert into #temp...
Thanks you Rich. The problem at hand is that there are too many column in Table3 and Table4. Table3 has 35 columns and Table4 has 50 columns. Hence...
There are 4 tables Table1, Table2, Table3 and Table4. Table1 has PK on 3 fields and these three fields are present in all these 4 tables. I need to...
Thank you Frank. Can you please help me with the code.
Is it possible to return only the upper case of a given string. For a string say, 'My name Is John Cramps' I should get the output as 'MIJC' I am...
even my sp got dropped.
Here is the proc SP1 /********************************************** / SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO CREATE PROCEDURE...
I want to encrypt a stored procedure. Tried looking in BOL but this is not mentioned there. Is there any sp to do that
BOL does not help. It is very complicated. Do you know of a resource where we can see step by step method ?
Can anyone tell me how to set up Snapshot and transactional replication step by step. Since I am setting up on my production servers directly give me...
XML: > > ==== > > > > <programme start="2008r8348762 84736 -0400" stop="20089798789 > -09000" channel="46731478. sjdc.gug" > > > > > <title...
Separate names with a comma.
