How to test values returned by a subquery with the in operator?
Are resultset updatable?
find 2nd highest salary of person using cursor concept?
What is the difference between truncate and delete statement?
6 Answers CarrizalSoft Technologies, CTS,
How to set the current database in ms sql server?
What are the 3 types of schema?
Where do you think the users names and passwords will be stored in sql server?
How to count duplicated values in a column in ms sql server?
If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?
Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query
What is a collation?
What is indexed view?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture