Querying Microsoft SQL Server : Defining Variables
Querying Microsoft SQL Server : Defining Variables: Defining Variables in SQL Server: Like other programming languages T-SQL allows to defining your...
2013-03-13
836 reads
Querying Microsoft SQL Server : Defining Variables: Defining Variables in SQL Server: Like other programming languages T-SQL allows to defining your...
2013-03-13
836 reads
Transaction Log in SQL server records all operation on database.This recoring depends on Recovery Model selected for database.You can find...
2013-03-08
631 reads
Sometimes you need to know how many and what instances of
SQL Server running in your organization over Network. You can...
2013-02-22
2,346 reads
Use following script to generate random Passwords
DECLARE @id int,@list varcharSET @list ='abcdefghijkmnopqrstuvwxyzABCDEFGHIJKLMNPQRSTUVWXYZ23456789.,-_!$@#%^&*'selectreplace(SUBSTRING(CONVERT(varchar(255),NEWID()),8, 8),'-','')as RANDOM
Example:
Suppose you have a table tblUser with columns[id],[userid],[password].
CREATETABLE [dbo].[tblUser]( ...
2013-02-12
4,714 reads
What is NULL?
In SQL, A Null is an unknown or undefined value. Some interesting
operations on NULL.
--query --resultselect 3*NULL --NULLselect 3+NULL ...
2013-02-05
521 reads
Data to test:
CREATETABLE [dbo].[emp]( [emp_id]
[nchar](10)NULL, [emp_name]
[nchar](10)NULL, [salary]
[int] NULL)ON [PRIMARY] insert emp( emp_id,emp_name,salary ) select'1','ABC',-20000 insert emp( emp_id,emp_name,salary ) select'2','XYZ',-5000 insert emp( emp_id,emp_name,salary ) select'3','PQR',-7800 insert emp( emp_id,emp_name,salary...
2013-02-04
741 reads
What is SQL Server?Microsoft SQL Server is Relational database management system (RDBMS) developed and owned by Microsoft. It is a software...
2013-01-28
409 reads
DBCC Commands:
DBCC commands are most useful for
performance and troubleshooting.
The DBCC Commands are used in Maintenance, Informational use, Validation on a
database,...
2013-01-28
1,906 reads
1.Select no of Months between two dates:
SELECT DATEDIFF(MONTH,'4/1/2011','01/23/2013')+ CASE WHENDAY('4/1/2011')<DAY('01/23/2013') THEN 1 ELSE 0 END
Output:
----------------
22
2.What will be the
output of following...
2013-01-24
492 reads
FOR XML CLAUSE: Sometimes we need to data in form of XML from
Database.SQL Server provide FOR XML Clause. For XML clause...
2012-12-26
761 reads
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
I've tried different credentials, target server versions, etc. hitting our Primavera WSDL. Works great...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers