How do represent objects in SQL Server? Is it possible? If yes, how?If not? Why?
Which TCP/IP port does SQL Server run on? How can it be changed?
Latest Answer: SQL server works on 1433 port and DAC (dedicated admin connection ) works on 1434 port. You can change the port number SQL server should use through SQL net configuration manager. ...
You are required to design a social networking site. Set of all those people who are friend of friends your friends would be consider to be in your network. Write a SQL query to print Number of people
Latest Answer: Answer for ist part of the question:Create 2 tables mapidandnames and friendsTable:mapidandnamesid name-------------- 1 a 2 b 3 cTable:friendsid ...
What is T-SQL means? How it is different from SQL?
Latest Answer: As the name indicates that T-SQL means transact SQL queries developed by Microsoft. It is a programming language and the difference between SQL and T-SQL is SQL is the base class for T-SQL and T-SQL is inherited from SQL having some extra features as ...
How will you fetch records having underscore ( _ ) in the middle of of strings, from columns having attributes as "amit_6", "t_mit06", "am_06", "m_t", "j_x_t"
Latest Answer: SELECT * FROM TableName WHERE ColumnName LIKE '_%[_]%_' ...
Why do we use alias for the table name? What is its importance?
Latest Answer: -is a shorthand notation-Will be used along with column name if same colum name present in more than one table (while joining those tables)-Must in self join ...
Write an SQL query if you want to select the data from one block which intern reflects in another block?
Latest Answer: Select *from(Select *from ) a ...
Is there any reason for which we cannot use After trigger with a view?
Latest Answer: In a view if composite primary key is present than "After Trigger" cannot be defined. ...
Latest Answer: Windows authentication is highly secure than SQL Server authentication why because we need not provide any login details. So the chance of tracing login details from code by the unauthorized persons will be less. Windows authentication uses the default ...
1 How is the error handling in stored proc of T-SQL2 What is clustered index and non-clustered index? How many clustered indexes and non-clustered indexes can be created in one table? 3-what is disconnected
Latest Answer: You can have only one clustered index on a table and a maximum of 249 non clustered indexes. ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
