syntax for deleting the database in T SQL5 3796
How are SQL Server databases physically stored under Windows 2000?1 2198
internal language used in sql server 2000?2 1917
What types of integrity are enforced by a foreign-key constraint1 2921
How do you find the error, how can you know the number of rows effected by last SQL statement?1 2769
Which virtual table does a trigger use?3 5802
Name three version of sql server 2000 and also their differences?1 2215
Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)1 7775
can you any body tell me which service pack is installed in the sql server?3 2200
can you any body tell me the how to decrease the logfile4 2858
I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 500017 10281
employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.3 4949
what is difference between having and where clause ?3 3023
Accidentally i deleted my table. How can i get that table?4 5435
how can i view structure of table in sql server? tell me that query.10 11274
sql database suspect We have a sql database that is showing as suspect. How can we recover?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
Delete duplicate rows without using rowid.
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
how to overcome kernel isssues
whats new about truncate in sql server 2008?
whats the maximum size of view state??
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
If we delete pack Spec what will be the status of pack Body ?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
SQL Server Architecture ?