2012-01-08 13:04
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
Blog Directory > Software Blogs > Programming Blogs > ASP.NET CODES programming Blog >
Asp.net Codes Blog
incredibledotnet.blogspot.com
Tags:
table
behavior
database
varchar
connection
stored procedure
unique
datareader
procedure
primary
SQL and ASP.NET Codes
2012-01-08 13:00
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
2006-06-07 11:16
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
2006-06-07 11:16
CREATE FUNCTION dbo.DateTimeFormats ( @dt DATETIME, @format VARCHAR(16) ) RETURNS VARCHAR(64) AS BEGIN DECLARE @dtVC VARCHAR(64) &nbs&hell…Read More
2006-06-07 11:16
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
2006-06-07 11:16
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!