Explain the architecture models of SQL Server?

why not null is not allowed at table level

Cognizant,

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

What is difference between Sql server and MySql database? It may be silly question but i really dont know.

Table A has 5 rows and table B has 0 rows Cartesian join on A,B will have----rows

Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END

what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL

What is the difference between truncate and delete?

DELL,

how to add a new column to an existing table?

MCN Solutions,

SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?

Which statement is used to delete a table in MySQL.

Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

Explain about the architecture of MYSQL?

Explain about reporting services of MYSQL?

In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?