ugi.nagesh

SEO - Search Engine Optimization. Most of us go on to Google every day and search for something. Whether it is a education related, product or service we desire, news, people or inquiries, Google is the most commonly used in the world. There are other search engine sites like Yahoo, …

For selling of any product in the ecommece site like urs T.Shirt. We need to make the customers to konw about our site first. For that we need to do marketing just like we are doing in shops... Advertising, Campaign etc... In the Internet, we need make your site in …

Payment Gateway is a online Bank who will collect the money from customers and pay to us. Just like an account in the bank.. He will act as mediator between merchant and customer. To get the payment from customer for the product purchased online site. we will be getting approved …

You can try the below SQL Query select top 1 sem_no from course, student_info where course.c_id=student_info.c_id and student_info.s_id='0001'; order by sem_no desc have a good day :)

HI Could you provide the table structure with data and output that you are expecting from the Query. Thanks

To rename a column called "Column_Old" to "Column_New" in the table named "customer": mysql> alter table customer change Column_Old Column_New int(3) unsigned; So, when renaming a column, we need to provide the old column name first, then after the new column name.

HI, In the Query Analyzer check the option as Query -> Result to -> Results to Grid (Select).

Hi, See the sample that i have attached to confirm is this i am gatting the error for both direct insert and stored procedure... create table table1(name varchar(10)) go Case 1 : insert into table1 values('12345678901') -- more than 10 characters Msg 8152, Level 16, State 14, Procedure test, Line …

Server side programming : Where the code will be executed and maintained in the server side. We will use the server side programming when performing the business logics/complex calculations etc.. ex: C#, Vb.NET etc... Client Side Programming : We wil use the client side programming to perform the validation and …

Assuming the Client table has companyid column, then you can use the below SQL Query to get the Logo value SELECT NAME, ADD, (SELECT TOP 1 LOGO FROM COMPANY WHERE COMPANYID = CLIENT.COMPANYID) AS LOGO FROM CLIENT Hope this will solve your problem Thanks

Hi Maideen, find the below update query UPDATE WEB_TBL_ACCURAL_AUDIT SET NOMONTH =TBL_ACCURAL_BASIC.NOMONTH , ACC_P=TBL_ACCURAL_BASIC.ACC_P, STARTDATE=TBL_ACCURAL_BASIC.STARTDATE FROM WEB_TBL_ACCURAL_AUDIT WEB_TBL_ACCURAL_AUDIT INNER JOIN TBL_ACCURAL_BASIC TBL_ACCURAL_BASIC ON WEB_TBL_ACCURAL_AUDIT.<<KEY COLUMN>>=TBL_ACCURAL_BASIC.<<KEY COLUMN>> Note: Key Column : Key column to mapp both the tables Hope this would solve your problem.. Happy coding.. THanks

Create the below user defined function fnsplit_string in sql server CREATE FUNCTION [dbo].[FNSPLIT_STRING] (@STR1 VARCHAR(MAX), @CTERMINATOR CHAR(1)) RETURNS @TABLE TABLE(STRNAME VARCHAR(7000)) AS BEGIN IF(@STR1 IS NOT NULL) BEGIN DECLARE @STR2 VARCHAR(MAX) DECLARE @INO INTEGER SELECT @INO=CHARINDEX(@CTERMINATOR,LTRIM(RTRIM(@STR1)),1) WHILE(@INO<>0) BEGIN SELECT @STR2=SUBSTRING(LTRIM(RTRIM(@STR1)),1,@INO-1) INSERT INTO @TABLE SELECT LTRIM(RTRIM(@STR2)) SELECT @STR2= SUBSTRING(LTRIM(RTRIM(@STR1)),@INO+1,LEN(LTRIM(RTRIM(@STR1)))) SELECT @INO=CHARINDEX(@CTERMINATOR,LTRIM(RTRIM(@STR2)),1) …

Hi Ken, You can maintain separate master table to store the different types of round data that you want EX: RoundMaster ( Round_id integer primary key, Round varchar(100) ) Then reference the Round column in result table with Round_id of type integer. Hope this will solve your problem

Hi Team, Could any one help on setting the date formats We have the web application developed in c#. how to make sure that aplication should use the server regional settings like date formats etc.. irrespective of the client regional settings. Examole: if the server regional settings - date format …