Latest Answer: CREATE TABLE dbo.SalesByQuarter ( Y INT, Q INT, sales INT, PRIMARY KEY (Y,Q) ) GO INSERT dbo.SalesByQuarter(Y,Q,Sales) SELECT 2003, 2, 479000 ...
Latest Answer: Clustered Index ...
Latest Answer: Definitely Windows Authentication Mode. Firstly, the Windows security policy is used to authenticate is employed at user login reducing extra overhead. Secondly, if we implement any extra group policy for a Windows domain, it will automatically propagated ...
We have used a Stored Procedure having large code in it. If we try to Alter the SP again then the entire code seems to be SCRAMBLED - Why ?
I have three task in my SSIS package,1. Script Task2. Execute Process Task3. FTP Task I want to enable disable Execute Process Task and FTP Task on runtime using script task, How to do that?Do we have any property of dts using which we can access property of other task iin script task like Dts.Connection("Connectionname") for Connection Controls?
Latest Answer: CO-RELATED Query: It used to find the exits or doesnot exits value. It has two select statement, the outer select statement will execute first and then the inner select statement execute.There is no need of relation between the two select statement. ...
Latest Answer: Cursor is used to eliminate the repeated(duplicate) records in a table. ...
Latest Answer: SQL Server 2005 has reduced application downtime, increased scalability and performance, and tight yet flexible security controls. SQL Server 2005 makes it simpler and easier to deploy, manage, and optimize enterprise data and analytical applications.It enables ...
Latest Answer: You have to connect your database first than you can open asly..... ...
View page << Previous 2 3 4 5 [6] 7 Next >>
Go Top
