Hello, I have created the following table CREATE TABLE [dbo].[testclient] ( [client_id] [bigint] NOT NULL , [one_Code] [char] (6) COLLATE...
I have two tables. 1 Employee table contians Employee_id and Employee_name 2.EmpSalary contains Employee_id and SalaryMonth Please see the data...
Hello, I have created the following temp table in a sp. CREATE TABLE #tmpProjectListForGrid ( [Id] INT identity(1,1) ,...
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, 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.
