-
What is the query used to display all tables names in SQL Server (Query analyzer)?
srikanth tirunagari
- May 25th, 2007
select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_TYPE = 'BASE TABLE'
-
How to join four same fields of different tables at sql server?
-
Are there any Commands, can be used to calculate the performance of a Querry?
sapna
- Sep 20th, 2006
set showplan onset showplan_text on
-
Transferring data from text file
How to transfer data from a text file to SQL table, Which is the best method to do that?
sakthi.jaganathan
- Aug 25th, 2008
By using OPENROWSET commandExample: INSERT INTO dbo.ImportTestSELECT * FROM OPENROWSET('Microsoft.Jet.OLED...
-
Using Distinct clause
How to select Distinct columns from the table, table having 20 columns and i want all columns
-
How to run SQL script from a Unix Shell?
sreddy_bond
- May 9th, 2008
Rownum is the id which is assigned to recored, by the time of record set selected (executed).Rowid is, the id which is assigned physically to each record in table.RegadsSarele
Bill
- Nov 10th, 2006
sql dbname < script_filename > output.out 2>&1
-
How to create table with same strecture of the existing table in same data base in sql server2000
ramakrishnasri
- Dec 6th, 2007
Hai,here is the example for ypour qustionselect * into emp1 from emp where 1=9execute this u can have the structure of the new table as old with out the data in the new tablei hope it will solve your problem
-
What are DTS subroutines? What is their use and How do you write them?
sutanu_halder
- Mar 29th, 2008
DTS is a set of tools you can use to import, export, and transform heterogeneous data between one or more data sources, such as Microsoft SQL Server, Microsoft Excel, or Microsoft Access.The Import/Ex...
-
How to find the list of system databases in a SQL Instance.
-
Can we partition a SQL Server table. If yes how to make patition in a SQL Server table.
Kiran Patil
- Mar 26th, 2008
Yes, there is table partitioning in SQL Server. Unfortunately I don't know how to do that, If anyone knows that, let me know.
-
Database Attach and Restore
What is the Difference between Attach and Restore of a Database?
Kiran Patil
- Mar 26th, 2008
Database attach is faster as compaired to Database Restore. SO if you have both options then may be you can choose Database attach than Database Restore.
nbkb9hv
- Feb 13th, 2008
Both are used to restore database, we Use attach database when we have .mdf file to upload data into database while we use restore database when we have .bak file to upload data into database.
-
Tail Log Backup
What is tail log backup? Where can we use it?
Kiran Patil
- Mar 26th, 2008
Tail Log Backup is the log backup taken after data coruption (Disaster). Though there is file corruption we can try to take log backup (Tail Log Backup). This will be used during point in time re...
-
How can I migrate database from ms SQL Server 2000 to SQL Server 2005? What are the steps?
bugeye
- Mar 15th, 2008
Take a full backup and restore or dettach 2000 db copy .mdf and ldf to 2005 server. Attach then switch compatiblity mode to 90 then update statistics. Once you go to 2005 you can go back.
-
Assign Deny Permissions to Specific User
How to deny insert, update, delete, update permissions for a specific user of a specific user database?
bugeye
- Mar 15th, 2008
So what context is the user in? A role a datareader? Datawriter?You want no permissions?USE <your db>Drop USER <your user> In a role?EXEC sp_droprolemember 'rolename&#...
-
I did not took backup for a database.My colleague had mad some changes to some Stored procedures and I want to roll back to the original codr.Since he did not used the begin transaction i am not able to rollback the changes.>How can I get back to my original code?
bugeye
- Mar 14th, 2008
Go to your last good full backup. Restore to another db using the MOVE command.
-
How many column maximum we can add in one table and how many foreign key maximum we can use in one table?
venkat.rbs
- Feb 12th, 2008
We can define up to 1024 columns. in one table....And 253 forignkeys we can assign for 1 table...
-
What is different between int and bint?
amitm79
- Feb 8th, 2008
Bigint can hold values from -2^63 (-9,223,372,036,854,775,807) to 2^63-1 (9,223,372,036,854,775,807) and it takes 8 bytesint can hold values from -2^31 (-2,147,483,648) to 2^31 - 1 (2,147,483,647) and it takes 4 bytes
-
Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no.
sreyas kvm
- Feb 3rd, 2008
Yes we can generate....CREATE TRIGGER Tgr2Tab ON dbo.employee FOR INSERT AS INSERT INTO dbo.department(SELECT departmentno FROM INSERTED )
chauhan_anilit
- Jan 10th, 2008
Usha G, your code is right but it only for first (SampleMainTable) table and execute whn you insert a record in the SampleMainTable tabe so its only for SampleMainTable table
-
Connection of SQL file to web page
How we can pulish the connectivity of SQL query to the HTML file or web page? Please Explain.
Mena1710
- Jan 30th, 2008
Normally connection of SQL file to a web page can be done in two ways1. Through the code2. In web config fileIf we give through the code, we need to alter the relevant pages, where as if we give throu...
-
Nested Trigger Levels
How many levels a trigger can be nested? Explain about nested triggers.
SQL Server Interview Questions
Ans