All Type Coding

Search Here

SQL SERVER

How to install sql server 2008.?
What is DBMS.?
What is advantages and disadvantages of DBMS.?
What is the Characteristics of DBMS.?
How to Creating, altering and dropping a database.?
What is SQL Commands.?
Data types in sql server
What is operator and its type in sql server.?
How to create table in sql server.?
How to insert data into table in sql server.?
How to Update Record/Data in a table in sql server.?
How to delete data from a table in sql server.?
How to truncate a table in sql server.?
Differencebetween Delete and Truncate command in sql server.
How to drop a table from database in sql server.?
How to use select statement in sql server.?
How to use Where clause in sql server.?
Group By statement in Sql Server.
Distinct Statement in sql server.
Having Clause in sql server.
Diffrence between WHERE Caluse and HAVING Clause in sql server.
Like operator in sql server.
TOP Clause in sql server.
ORDER BY Clause in sql server.
ALTER COMMAND in sql server.
Alias in Sql server
Difference between primary key and foreign key in sql server.
Difference between PRIMARY KEY and UNIQUE KEY
IN operator in sql server.
Between Operator in sql server.
Primary Key in sql server.
How to get the last generated identity column value in SQL Server.?
Joins in sql server.
SELF JOIN in Sql Server.
How to replace NULL value in sql server.?
Coalesce function in sql server.
Union and union all in sql server
Stored Procedure in sql server
How to rename a table column name in sql server / How to change column name in sql server
How to create a procedure that return back current month and previous three month in sql server.
How to create a procedure that return back current month and next three month in sql server.
How to create calendar in sql server.?
Stored procedures with output parameters in Sql server
Built in string functions in sql server
Built in string function LEFT, RIGHT, CHARINDEX and SUBSTRING,Replicate, Space, Patindex, Replace and Stuff in sql server
what is scan in sql server















No comments :

Post a Comment