What is full form of XP ?
Answer Posted / siddharth
xp means Extended Procedure . These procedrue are made from
dlls written in c++.
Example- XP_cmdshell is a extended procedure to run all dos
commands in sql server.
| Is This Answer Correct ? | 193 Yes | 57 No |
Post New Answer View All Answers
What part does database design plays a role in performance of an sql server-based application?
How can we rewrite sub-queries into simple select statements or with joins?
What is set nocount on?
Write a SQL queries on Self Join and Inner Join.
How to access the deleted record of an event?
What is 2nf normalization?
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.
What is the usage of sign function?
How to delete existing triggers using "drop trigger"?
How to disable a login name in ms sql server?
What is row_number () and partition by in sql server?
explain the storage models of olap? : Sql server database administration
what is difference between NULL and ISNULL in SQL Server 2008?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
Write the syntax for stuff function in an sql server?