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
841 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
841 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
633 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,355 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,804 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
524 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
745 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,989 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
410 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
494 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
763 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers