HI Friends
I am software worked as .net developer for 3 years and presently as Sqlserver DBA since 1 year . apart from i am doing MBA distance from arens foundation.
my doubt when i plan to choose the specialization there are many options to choose where i confuse , finally i preferred SAP CONSULTANCY or CUSTOMER REATIONSHIP MANAGEMENT but can any tell the exact roles of these specialization , will these suite for...
nmsreddi
Last Activity: Feb 3 '11, 06:23 AM
Joined: Jul 14 '06
Location: India,Hyderabad
-
SAP Consultancy or Customer realtionship Management In MBA
-
Inserting data to xml column
HI Friends
i am using sqlserver2005 .
I have column in my table with xml DataType .and while i am inserting data into it ,if '&' is there in data it is giving xml parser error as
"XML parsing: line 1, character 15, illegal name character"
i have idea that xml parsing & is represented as 'amp' , but i cannot do that
my requirement is to insert the data as it is.
... -
Ya got it ,
any way thanks for your reply... -
HI deepuv
Thanks for your reply,
i used second option for generating script and also checked select all objects in database option that occur in second pane .
but now the problem is when i run the script in another server i got the database and all its objects correctly but the foreign key relations ships are missing ,
is there any more options to select, in the third pane (Choose Scripts Opti...Leave a comment:
-
Generating Script for a DataBase
Hi friends
recently i have started working on SQLserver 2005 as DBA for my project .
when i tried to generate script for my Database i was confused to find two options for scripting in management studio.
1. cript DataBase as and 2. Tasks-->Generate Script..
what is the difference between these two options ,which is to be used mostly
i have done a lot of googling but... -
Hello
SQLDatareader is connection oriented ,you can only use when its connection is open(), this error indicates you are trying to read with connection closed.check whether connection is open or close before trying to read .
Cheers
nmsreddiLeave a comment:
-
Hello
if you are using VisualStudio by default you have report viewer nothing but .RDLC reports, or else you can also develop data reports by your ownLeave a comment:
-
Hello
As you can assign data table as data source to data grid better maintain different data tables as per your requirement ,depending on condition try to re- bind the grid with particular data table, it can solve your problemLeave a comment:
-
K thank you i will try with this oneLeave a comment:
-
Dual ListBox is it any New control in .Net ?
in which version ,upto VS2005 i never heard about itLeave a comment:
-
Hello Kbobce
i have tried by placing the script(what you have posted) in Head part of my web page ,but still it doesn't works any more to do after placing the scriptLeave a comment:
-
hello
Simple, always get the Max number from the database ,and assign MaxVal+1 to your text box ,if you want to insert into database just use the insert query as usual.
nothing different you need to do.Leave a comment:
-
Hello
your post looks something related to networking concepts ,
what exactly you are expecting ,what application you want to develop.
if you want your application to be accessed via lan then develop a web application you can access it where ever you want once hosted in server.
exactly i dint get whether you need any application development help or some networking HelpLeave a comment:
-
Hello
you can use normal sql query as usual like other fields how you are inserting ,
have you tried it ,did you get any error,
mostly you will get format conversion errors ,by default sqlserver will take MM/dd/yyyy format ,make sure that your input is in that format other you can conver that to your custom format with the existing convert functions.Leave a comment:
-
Hello
i hope you can write a query for getting data from both the tables and then you can fill Dataset easily with that data.Leave a comment:
-
Hello
what is the problem you are getting ,did you get any error?
are you getting any incorrect out put ?Leave a comment:
-
Hello
while system restart which user name it is asking ,either windows user account name or your application user name and which one you want to avoid .
what actually you need ,why you want to avoid user name and password which never recommended for security reasons .can you be some more specific with your requirement.Leave a comment:
-
Hello
In c# you have separate concept for SQLServer management called SMO ,have a look at it, using SMO objects you can do almost all possibilities using C#.
other wise simply you can generate script using SQLServer any you can run it at runtime in c# which also useful to solve your problem
Regards
nmsreddiLeave a comment:
-
Hello
first have you any idea about Inheritance? any idea about hierarchy of multiple inheritance .
some think if you look into reality a child should not have more than one parent right ,to avoid the same multiple inheritance is not directly applied but achieved by some other means (Interfaces in C#) .
remember not only C# ,even java doesn't support multiple inheritance.Leave a comment:
-
Hello
As per my knowledge and experience i hope ,you can only select either framework1.1 or 2.0 both not both at the same time ,you IIS allows to select frame work of any one version only .Leave a comment:
No activity results to display
Leave a comment: