Friday, June 28, 2013

[SQL Server] Connect SQL Server 2012 with Database Engine

[SQL Server] Connect SQL Server 2012 with Database Engine

Connect SQL Server 2012 with Database Engine

Posted: 28 Jun 2013 02:52 PM PDT

Hi all,Installed SSMS 2012 Express addition with localDB. I don't know how to connect with Database engine and start using Sql Server?I also want to download Sample Database TSQL2012 for 70-461 practice?One more question do I have to give all the three Microsoft exams at the same time to become MCSA?Thank you.

Concatenating Values of 2 rows in SQL Server

Posted: 28 Jun 2013 09:32 AM PDT

Hi There,In the Picture attached this is the Table for one single item and all the items will be having the same 4 values since it has 4 fields, Is there any simple way to concatenate the Field STRGA255 to display as Shoes, Pumps.

Columns from one table match with rows in another table

Posted: 28 Jun 2013 07:52 AM PDT

Hi, I have 3 tables in the first table customernumber i have data filled. it has 4 columns which specifies the total number of different kinds of customers in the market.The second table has two columns customertypeID and customers type so it has only 4 rows (every customerType is assigned with a customerTypeID). here comes my work there is a third table which has CustomertypeID and number of customers. the data in the third table is filled basing on the first and second tables. the columns in the first table should match with the rows in the second table and data has to come into third table can any one of you help me in this ? Create table Customersnumber( cityname varchar(25),Loyal Customers interger,DiscountCustomers integer,ImpulseCustomers integer,NeedBasedCustomers integer,WanderingCustomers integer)insert into customersnumbervalues(1,5,8,56);insert into customersnumbervalues(7,65,98,756);create table customertype( customertypeID int identity(1,1) , Customertype ) insert into customertype values('DiscountCustomers'); insert into customertype values('ImpulseCustomers'); insert into customertype values('NeedbasedCustomers'); insert into customertype values('WanderingCustomers') create table customers ( ID int identity(1,1) , customertypeID int ,NumberOfCustomers int )

How to replace a value in Bracket with negative value in ssis

Posted: 28 Jun 2013 02:52 AM PDT

Hi, I have imported data into a database from an excel file and some of the columns contain values are like (392.03), (2.25), (65.00). Actually these values are should be -ve values can you guys help me how to convert these into -392.03,-2.25,-65.00
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog