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...
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...
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...
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...
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...
while trying to execute a stored procedure I am getting error that 'SELECT permission denied on table .......'The DBA has given execute permission...
I wanna find the difference between two tables. Table A has 6 columns and 5 of the columns are part of the primary key. Table B has 5 columns and has...
We are having SQL Server 2005 with SP1. Of late I am getting EXCEPTION_ACCESS_VIOLATION error on my production server. The database is not being able...
I need to insert data into my employee table emp. This has PK on 2 columns i.e., on empid and empname. Now I have data from a third source in a temp...
Is is possible to do bcp out data from a table based on where condition........say for example from an employee table can I bcp out data for only...
hello, I am facing an issue with a query using CTE. A sample query is as below: WITH employee AS ( Select A.employeeID, A.employeeName,...
This is a a bit tricky one.I have a list of names in a table:AlexArambacardboychrismartincindersdorothyelenafisichellaxavierxalleNow I want the...
Separate names with a comma.
