These specification are for SQL Server 2005Columns per base table = 246Rows per table = Limited by available storageBytes for each column = 1024Clustered Index per Table = 1Non Clustered Ind… Read More
This is one of questions that is regularly asked in interview1) Stored procedures may or may not return a value or can return more than one value but a Function has to return a single value… Read More
Few days back I went for an Interview in HCL(2yr Exp) and this was one of questions that was asked : What is Command Behavior in ADO.NET? Command Behavior… Read More
CREATE FUNCTION dbo.DateTimeFormats ( @dt DATETIME, @format VARCHAR(16) ) RETURNS VARCHAR(64) AS BEGIN DECLARE @dtVC VARCHAR(64) &nbs&hell…Read More
1) Primary Key can't not be Null where as Unique may be Null some times if declared but by default we can have only one Null value in Unique Column.2) Maximum one Primary Key can be declared… Read More
To Copy a table across DATABASE use this Query-SELECT * INTO <Database>.dbo.<Table> FROM <Database>.dbo.<ExistingTable>Example:SELECT * INTO p… Read More
Subscribe to Asp.net Codes
Get updates delivered right to your inbox!