Browse by Tags
All Tags »
SQL Server (
RSS)
Following are the some tricky code to find previous week startdate and enddate in sql server 2000/2005 Set @STimeStamp=GETDATE() set @PStartDate=@STimeStamp-DATEPART(dw,@STimeStamp)-6 set @PEndDate=@STimeStamp-DATEPART(dw,@STimeStamp)
I have found a very good site with provide the comparison of Microsoft sql server, Microsoft and mdse capabilities on the basis of following. Number of instances per server Number of databases per instance / server Number of objects per database Number...
Some Times we want to retrive data fastly without wasting time to retrive it. SQL Server Indexes can greatly help to make data retrival fast and provide quick access to tables. Therer are four type of indexes in SQL Server 2000/2005. 1) Unique Key Index...
Performance is one of most important factor at the time of the application developement. If your application or website is not responding fast to user queries then it's accepted by the users. Here are the some tips to make fast retrival of data from sql...
Oracle and sql server both are great database management system and have great features. Often developer need to know what type of DBMS he should use for a particular needs.I have found a great comparison articles for oracle 9i and sql server 2000. Which...
Sql server joins are used to combine result data from two or more tables. Often we need to display data from two tables. Where sql server joins are very useful. There are three types of sql server joins. 1) Inner Join 2) Outer Join 3) Cross Join 1. Inner...
Here are some maximum number of different objects in sql server. maximum number of character in table name-128 maximum number of character in column name-128 maximum number of table columns per select statement -4096 maximum number of table columns per...
More Posts