SQL Server
concepts with Sachin Agrawal.....
SQL Server : Replicate ()
›
While working I was looking for a function which can help me to repeat a particular ‘string’ up to ‘n’ number of times and I can dynamical...
How to know data type of a column
›
With the help of below query, we can get the data type of a column:- SELECT TABLE_NAME , COLUMN_NAME , DATA_TYPE , CHARA...
List of stored procedures depend on a table
›
There is a Dynamic Management Function introduced with SQL Server 2008 which help us to get the list of stored procedures depend on a tab...
List of tables referenced by stored procedure
›
There is a Dynamic Management Function introduced with SQL Server 2008 which help us to get the list of tables referenced by a stored proc...
PRINT in SQL Server
›
Returns a user-defined message to the client. Message should have string ((n)varchar) data type. If we are planning to PRINT any vari...
›
Home
View web version
