Showing posts with the label SQLShow all
Tech Info
Local And Global Table in SQL
Difference between local temporary table and global temporary table are : #TABLE(Local Temp table) 1. Temp tables are available ONLY to the on…
Read more
Tech Info
Sql Table Creation
Table in Sql server is the primary object of database. All the information of our data are store in the form of table which is the collection of…
Read more
Tech Info
Create Database In SQL Server
Creating Database In Sql Server is the first step of the database learn here i am given the sample example CREATE DATABASE [tutorialsdb] This is …
Read more
Tech Info
How to Delete Duplicate Date From Database
Sometime we have a very challenging task, Duplicate data in database store but we have to keep one data safe and need to be delete other data , dup…
Read more
Trigger
Update Trigger for SQL Server
Update Trigger is very useful if you keep your deleted record or which data is replaced withnew,, here I have one table called tblstudent which ha…
Read more
