How are SQL Server databases physically stored under
Windows 2000?
Why should we go for stored procedures? Why not direct queries?
What is user-defined function?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h
we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz
Mention the command used to rename the database.
What is a transactions?
What are the types of database schema? : sql server analysis services, ssas
Is sql server is free?
Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY
What is difference between sql and sql server?
What are key, name and value columns of an attribute? : sql server analysis services, ssas