Explain the steps to create and execute a user-defined function in the sql server?
how to find the second salary?
What are the types of indexing?
What are the advantages of partitioning?
What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?
3 Answers Microsoft, TCS, Techastrum,
How to how to convert numeric expression data types using the convert() function??
how many type of indexing in database?
i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .
Will count(column) include columns with null values in its count?
Tell me what is difference between clustered and non clustered index?
How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.
Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?
How many primary keys are possible in a table?