Click here to Skip to main content
The default search term operator is AND.

You can use brackets, AND, OR, and NOT to improve your search. For example: C# AND NOT(VB or SQL)

A query of a single * will return everything, filtered by any filters.

Filter examples:
Search by Author  author:"author name"
Filter by tag  tag:C# or tag:(C++ or Java)
Wildcard search  use "?" or "*" eg. gr?d or gr*
  
50 Results

Search



Sort by



Match


Rating Range

Advanced Filters:


Page 1 of 1
Page Size: 10 · 25 · 50

Author filtered by: Aadhar Joshi [x]
Tip/Trick 18 Apr 2013   license: CPOL
To avail Danish language as a language breaker in full text search index option, it has to be enabled manually by adding a registry key for the Danish language.
DBABeginnerSSRS
Answer 3 Dec 2012   license: CPOL
Please use SQL Profiler to check exact time taken for each query..
SQL-Server
Answer 27 Nov 2012   license: CPOL
EXEC sp_configure 'default language', '23';goRECONFIGURE GO
SQL
Tip/Trick 27 Nov 2012   license: CPOL
Creating job in sql server which automates taking backup of all stored procedures and functions in physical drive.
.NET2.0SQL2005.NET3.0.NET3.5DBAIntermediate.NETSQL-ServerSysAdminSQL2008, +
Forum Message 29 Oct 2012  
Yes but it has bright chances as most of uses it now a days
Answer 26 Oct 2012   license: CPOL
U can find out in code project itsself..http://65.39.148.52/Articles/10622/Using-DOTNETARX-To-Develop-Your-NET-ObjectARX-Appl[^]
C#
Answer 26 Oct 2012   license: CPOL
Have you tried to start SQL Server Agent from the command prompt using:SQLAGENT90 -C -V>C:\SQLAGENT.OUT
SQL-Server
Answer 26 Oct 2012   license: CPOL
Hi, please find below code as exactly what u need it..UPDATE dbo.Emp SET EmpName = t1.EmpName FROM (SELECT e.EmpId,e1.EmpName FROM dbo.Emp e LEFT OUTER JOIN dbo.Emp e1on e.EmpID + 1 = e1.EmpID ) t1WHERE dbo.Emp.EmpId = t1.EmpIdThanks,
SQL2005SQL-ServerSQL2008
Question 25 Oct 2012   license: CPOL
Currently i'm using "Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Jun 17 2011 00:54:03 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) " version for sql server.I have added danish language registry to...
SQL-CESQLSQL-ServerSQL2008
Re: Quote by Aadhar Joshi
Forum Message 24 Oct 2012  
My 5!
Answer 24 Oct 2012   license: CPOL
In a same for loop, u can take two string variables ine for column names and other for values,u can execute that string through sql client..
ASP.NETSQL-Server
Answer 24 Oct 2012   license: CPOL
u can guess from following exampleSelect a.*,b.* froma left outer join b on a.id = b.idwhere b.id is nullORSelect a.*,b.* froma left outer join b on a.id = b.idwhere b.id is not nullOr give details of your table so give u exact output what u needed..Give votes if...
SQL-ServerSQL2008
Answer 24 Oct 2012   license: CPOL
You can simply cast it to varchar(max)/nvarchar(max), concatenate and thencast it back.declare @x xml, @y xmlselect @x = ' 60 1 'select @y = ' 59 2 'select cast(cast(@x as nvarchar(max)) + cast(@y as nvarchar(max)) as xml)
SQL
Re: locking on select by Aadhar Joshi
Forum Message 22 Oct 2012  
Thanks
Re: locking on select by Aadhar Joshi
Forum Message 22 Oct 2012  
I apologies for what i did.. I know i should listen you first but as u said i am a small kid and i need to go far away.. I can not compete with u, your knowledge, your points but as a senior u shoul
Re: locking on select by Aadhar Joshi
Forum Message 22 Oct 2012  
U please read the question.. he is talking about only 100 clients.. u know in a second how many number of locks sql can handle?? every time i don't belive i am good enough for all condition..
My vote of 1 by Aadhar Joshi
Forum Message 22 Oct 2012  
can understand properly
Re: 300,000+ by Aadhar Joshi
Forum Message 22 Oct 2012  
Congrats..!!
Answer 22 Oct 2012   license: CPOL
If viewing SQL Server Configuration Manager you only see the SQLEXPRESS instance name, then the Standard edition you "installed" did not get installed properly or at all. If in the install of the Standard Edition you just clicked through the wizard it probably installed as the default instance....
SQL-ServerVisual-Studioconnection
Forum Message 22 Oct 2012  
Where 1=1 I mean that is obvious..
Grouping table attributes by Aadhar Joshi
Answer 18 Oct 2012   license: CPOL
Can u please brief your question i mean produce output u need here?
C#ASP.NETSQL-Server
Answer 18 Oct 2012   license: CPOL
U can use Save Point functionality given for try can catch..SET NOCOUNT ON BEGIN TRANPRINT 'First Transaction: ' + CONVERT(VARCHAR,@@TRANCOUNT) INSERT INTO People VALUES ('Tom') SAVE TRAN Savepoint1PRINT 'Second Transaction: ' + CONVERT(VARCHAR,@@TRANCOUNT) INSERT INTO...
SQL-ServerStoreddatabse
Answer 18 Oct 2012   license: CPOL
Please optimize your database, stored procedure because such configuration runs good for just only 6000000 rows.. as well can u use profiler to check where exactly it takes time and paste those queries here..As well as u can use Transaction Isolation Level OR Lock Hints to improve...
SQLServer
Answer 18 Oct 2012   license: CPOL
Yes u can use it.Just for your information..DBCC commands to free several SQL Server memory caches:DBCC FREESYSTEMCACHEReleases all unused cache entries from all caches. The SQL Server 2005 Database Engine proactively cleans up unused cache entries in the background to make memory...
SQL-Server
Answer 18 Oct 2012   license: CPOL
You might have to check each join where it is giving more than one rows.U can also use distinct clause where it returns more than one rows.And rather applying as a case when, u should take as a inner join and then make join.Regards,Keep helping nature..!
SQLServer
Answer 17 Oct 2012   license: CPOL
I agreed Andrew Cherednik. just i want to confirm so i posted the question.Actually where i am working is a large transaction traffic and by using isolation level, sometimes u get data with dirty reads or penthoms. But as far locks are safe.
SQL2005SQLSQL-ServerSQL-ServerSQL2008sqldatasourceSqliteSQL2012
Answer 17 Oct 2012   license: CPOL
u can use following querySELECT DATABASEPROPERTYEX('master', 'Status')GO Also please follow following link may it could help..http://www.mssqltips.com/sqlservertip/1037/system-information-in-sql-server-2000-vs-sql-server-2005/[^]
SQL-ServerSQL2008
Forum Message 17 Oct 2012  
Keep your column in an numeric format OR convert it manually in numeric format so it dont create destruction.
Question 16 Oct 2012   license: CPOL
As a professional, Which should be better to usestatement in stored procedure or Lock Hints in particular query..SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTEDOR SELECT DISTINCT T.CompanyID ...
SQL2005SQLSQL-ServerSQL-ServerSQL2008sqldatasourceSqliteSQL2012
Re: SQL Select Where query by Aadhar Joshi
Forum Message 16 Oct 2012  
Hi, U can use following statment.. SELECT ISNULL(File_Name, '') FROM Files WHERE File_Name = @FileName1 because is is string so it should return blank
Re: subquery using 1 table by Aadhar Joshi
Forum Message 16 Oct 2012  
First thing is u should avoid sub query as a column and make a inner join and take a column from sub table as it improves your performance when u fire your query with large data. Second is it works
Question 20 Sep 2012   license: CPOL
this is not working please help..SELECT * FROM Company c WHERE 1=1 and CONTAINS (c.FullCompanyName, ' "Baresso*" AND "Coffe*" AND "A/S*"')it is not giving output with Baresso Coffe A/S
SQLSQL-Serverqueries
Answer 5 Sep 2012   license: CPOL
When it concern with windows application it all depents on design,1) Use table layout panel make it Doce = Fill for the page2) Define rows and columns as per your control needs3) Put controls in cell and apply Anchor property to Top, Left (Or as per your setting)===============Just...
C#2.0C#WinForms
Loading web.config file by Aadhar Joshi
Answer 5 Sep 2012   license: CPOL
Keep contry wise folders and put your config files in that and call upon so..
C#ASP.NET
Answer 5 Sep 2012   license: CPOL
Please use this user defined table valued function to split your string and then apply max.SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER FUNCTION [dbo].[Split] ( @String varchar(max) ,@Delimiter char ) RETURNS @Results table ( Ordinal int ,StringValue...
SQL2000SQL-Server
Forum Message 4 Sep 2012  
Aadhar: Greetings doesnt copying..!! It remains same for everyone..!!
Answer 4 Sep 2012   license: CPOL
You can use following method:System.Configuration.ConfigurationManager.ConnectionStrings["YourConnectionString"].ConnectionString You could execute select command using a SqlCommand object with the ExecuteReader method, see: http://msdn.microsoft.com/en-us/library/9kcbe65k.aspxLook...
C#ASP.NET
Answer 4 Sep 2012   license: CPOL
You can use a BackgroundWorker for the threading, use Process.WaitForExit() to wait for the process to terminate until you stop your service.You're right that you should do some threading, doing lots of work in the OnStart may render errors about not starting correctly from Windows when...
VBVB.NET
Forum Message 4 Sep 2012  
Wishing u all a very happy teacher's day..!!
MySql Database Replication by Aadhar Joshi
Forum Message 4 Sep 2012  
To perform MySql Database Replication please visit below link.. MySql Database Replication Procedure[
Tip/Trick 4 Sep 2012   license: CPOL
Database replication procedure is to replicate data from different databases of MySQL.
.NETDBADevIntermediateMySQLSysAdmin
Crystal Report in C# by Aadhar Joshi
Answer 4 Sep 2012   license: CPOL
1) Select Draged field (which appears as 20,000) 2) Select right click on that and select Format Embaded Field option.3) Where u can find different options for numeric4) Select option as per your required format..!!
C#
Answer 4 Sep 2012   license: CPOL
Please find below link..may be it can help..1) http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=5114[^]2) http://forums.codeguru.com/archive/index.php/t-288100.html[^]Keep faith in god..!!
C#
Re: Who was here? by Aadhar Joshi
Forum Message 3 Sep 2012  
Hi, I am new to cP but found u as experienced as edited one of my post by u.. i really interestd to write articles amd tips, please point your finder to reach better destination..
How to create a 3d array? by Aadhar Joshi
Answer 3 Sep 2012   license: CPOL
using System;public class CSharpApp { static void Main() { int[,,] n3 = { {{12, 2, 8}}, {{14, 5, 2}}, {{3, 26, 9}}, {{4, 11, 2}} }; int d1 = n3.GetLength(0); int d2 = n3.GetLength(1); ...
C#
Answer 3 Sep 2012   license: CPOL
Let's say that your DateTimes are called start and end.DateTime start = new DateTime(2009, 6, 14); DateTime end = new DateTime(2009, 12, 14); We have established our DateTimes to June 14, 2009 and December 14, 2009.Now, let's find the difference between the two. To do this, we...
.NET2.0C#.NET.NET
Answer 3 Sep 2012   license: CPOL
Listen first, If we see the difference between a non-static and a static class in C# is simply that a static class cannot be instantiated. This means that you don’t use the new keyword to instantiate an instance of the class. Instead, you will access members of the static class by using the...
C#ASP.NET
Answer 3 Sep 2012   license: CPOL
This can be easily accomplished using an object of Type "TimeSpan". For example: let's assume that we want to know the number of days between the max. and min. values for the DateTime Type and show it in a Console window, then I may write something like:DateTime d1=DateTime.MinValue;DateTime...
.NET2.0C#.NET.NET
Answer 3 Sep 2012   license: CPOL
This can help out..Try once..=======================================================private void CreatePDF(string fileName){ // Variables Warning[] warnings; string[] streamIds; string mimeType = string.Empty; string encoding = string.Empty; string extension...
C#ASP.NET
Page 1 of 1
First · Prev · Next · Last


Advertise | Privacy | Mobile
Web03 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid