Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?1 4342
How do I compare two values when one value(data type) is char and the other is an integer?3 5978
What are the pros and cons of creating extended stored procedures?1 3864
I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?1 4876
How to Check Whether a Global Temporary Exists in a SQL Database or not?2 5669
how to know Who Is Blocking Your SQL Server?4 8774
How to Get the last identity value used4 5311
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?1 3593
How to Run a Query on a Remote SQL Server?2 6124
How to Generate a Series of Random Integers With T-SQL?1 2965
What is normalization?9 6736
What is a Stored Procedure?8 6465
Can you give an example of Stored Procedure?4 6911
sql database suspect We have a sql database that is showing as suspect. How can we recover?
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?)
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
Which is the best place or learning center for MS SQL?????In Bangladesh?????
SQL Server Architecture ?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
what is difference between view and Dip.
application server is slow what may be the problem
What are the dis_advantages of stored procedures, triggers, indexes?
What is the difference between online clustering and Offline clustering?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
whats new about truncate in sql server 2008?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
what is the Ticketing tool used in Wipro technologies at Bangalore...???