Hello, I have created the following table CREATE TABLE [dbo].[testclient] ( [client_id] [bigint] NOT NULL , [one_Code] [char] (6) COLLATE...
quote:Originally posted by s_niladri I have two tables. 1 Employee table contians Employee_id and Employee_name 2.EmpSalary contains Employee_id...
I have two tables. 1 Employee table contians Employee_id and Employee_name 2.EmpSalary contains Employee_id and SalaryMonth Please see the data...
Originally posted by FrankKalis I can't reproduce this behaviour on SQL Server 2000, but may I ask, why you first create a temp table and then drop...
Replace "not in" with "Not Exists" keyword and use else if insetead of if. in the above scenario if one of the criteria is matched it shouldn't...
Hello, I have created the following temp table in a sp. CREATE TABLE #tmpProjectListForGrid ( [Id] INT identity(1,1) ,...
quote:Originally posted by Madhivanan s_niladri, It seems you are posting only interview questions. What was your answer there? Madhivanan...
Hello All, Suppose there is a table with the following data Table Name : Door ---------------------- Door_Id Door_Status ======================== 1...
Hello All, The following one was asked to me in Microsoft interview. Suppose there is a table with the following data Table Name : Door...
Hello All, The following question was asked by Microsoft during interview session There is a one table say FileDetails with only one column...
Hello All, Thanks for your referrence. I have got the query. Here I am submitting the finaly query to get the desired ouput SELECT id,...
Hello, My requirement is like the following. There is a student table with the following details. Table : Student ---------------- Student...
Hello ALL, If I use IN caluse in my query will it be slow. Because I have heard that IN clause slow down the query . if it is what are...
Hi ALL, I know the basic difference between char and varchar datatype. In my interview the interviewer asked me what are the advantage of using...
Hello, Before asking the actual question I would like to describe the scenario. I took full backup of my databases with log backup at...
Separate names with a comma.
