skip to main
skip to sidebar
Thursday, March 27, 2008
How To Copy Data and Structure of One Table To Another New Tables
select * into newtable from originaltable where 1=1
Post a Comment
Post Comments (Atom)
ASP.NET Code Book
The COALESCE Function
Return Null If A Value Is A Certain Value
How to return random results from SQL SERVER
Date formatting in SQL Server
SQL:Format Data From Numberformat To Timeformat
Check If Temporary Table Exists
Sort A SQL Server Table With CASE Or CHARINDEX
COALESCE And ISNULL Differences
How To Split column In SQL
Formatting Data By Using CHARINDEX And SUBSTRING
Pad Numbers By Using CASE, LEFT And CONVERT
Find all Primary and Foreign Keys In A Database
Use OBJECTPROPERTY To Find Out Table Properties
SQL String Functions Tutorial
To Get The Current Identity Value From A Table
How To Delete a null record
SQL Case Statements
SQL Count Distinct
SQL Server 2005 Cast-Convert Date Time Format
How To Use COALESCE And NULLIF To Prevent Updating...
How To Use Self Join In Sql Server 2000 2005
Delete Duplicate rows from the table.
How To Copy Data and Structure of One Table To Ano...
what Is Cursor
What is Triggers
Returning Complex Data from User-Defined Functions...
What is Stored procedure?
What are the differences between UNION and JOINS?
How many types of Joins?
Write a SQL Query to find first day of month?
# Write a query to round up the values of a number...
Write a query to convert all the letters in a word...
Find top salary among two tables
How to delete the rows which are duplicate (don’t ...
Find duplicate rows in a table?
How to know how many tables contains empno as a co...
T-SQL: Leap Year Check
T-SQL: Optional Parameters in Select Query (Using ...
HowTo Convert Table Values to Comma-Delimited Stri...
Select Middle Record
How TO Find age from date of birth
Get only Date from DateTime without performing any...
How can I find the last day of the month
How To get the comma delimited list:
Returning String Instead of NULL:
User Define Function For Converting Column Value i...
How To Split String in SQL
If there are 1 millinon rows ,how would you remove...
There is an employee table having dep_id field an...
What is Trigger?
Find 3rd max salary
Define having , order by ,group by
Types of constraint
what are index?
how do you delete duplicates rows from a table
what are joins and what are the types of join
can we use aggregate function in the “where clause...
what is a cursor ? whay do you need cursor.
what are the ypes of locking available in Sybase.
what is bcp
How do you delete all records from the file that h...