Latest Answer: There is no VARCHAR2 in SQL server.SQL Server VARCHAR = oracle VARCHAR2In SQL Server, maximum size of VARCHAR is 8000. So VARCHAR(MAX) is same as VARCHAR(8000). Also if we write VARCHAR(10000), will give error: The size (10000) given to the type 'varchar' ...
Latest Answer: When a procedure is created a execution plan is created, proc is executed according to that execution plan. When we modify the proc it also follow this execution plan.When index is rebuild, new index structure is created, but the proc follows the old ...
Latest Answer: Extended Stored procedure is a function in a DLL that can be called from T-SQL in a similar manner as we call normal stored procedure.Can accept parameter and return value as well. ...
Latest Answer: this is also worhs mentioning database backup & recovery ...
Latest Answer: Basic DifferenceSql Server:Runs only on windows platform,Hardware independentoracle:Runs in any platform and hardware dependent.. ...
Latest Answer: In SQL Server, objects like tables, views, stored procedures and so on that occupy space are called data objects. ...
Latest Answer: The binary datatype is used for storing the images in the database.the non binary datatypes are integer,varchar etc ...
Latest Answer: http://msdn2.microsoft.com/en-us/library/ms175890.aspx ...
Latest Answer: If you have a stored procedure that looks like this: CREATE PROCEDURE myProc AS BEGIN SET NOCOUNT ON SELECT columns FROM table1 SELECT columns FROM table2 ...
Latest Answer: Here is the Top 30 features of Sql 2005http://www.microsoft.com/sql/prodinfo/features/top30features.mspx ...
View page << Previous 1 2 3 4 [5] 6 7 8 9 10 Next >>
Go Top
