Did you know... How to perform date/time conversions using SQL Server
The first considerations is the actual date/time needed. The most common is the current date/time using getdate(). To change the format of the date, you convert the requested date to a string and specify the format number corresponding to the format needed using select convert(varchar, getdate(),)
Did you know.. How to get operating system content into SQL Server
Use the xp_cmdshell extended stored procedure to access the file system and bring the contents into SQL Server. By using a combination of both OS level commands and SQL Server commands you can pull this data into SQL Server for processing.
Did you know... How to delete duplicate rows when there is no primary key
An option that SQL Server gives you is the ability to set ROWCOUNT which limits the numbers of records affected by a command. The default value is 0 which means all records, but this value can be set prior to running a command.
The first considerations is the actual date/time needed. The most common is the current date/time using getdate(). To change the format of the date, you convert the requested date to a string and specify the format number corresponding to the format needed using select convert(varchar, getdate(),)
Did you know.. How to get operating system content into SQL Server
Use the xp_cmdshell extended stored procedure to access the file system and bring the contents into SQL Server. By using a combination of both OS level commands and SQL Server commands you can pull this data into SQL Server for processing.
Did you know... How to delete duplicate rows when there is no primary key
An option that SQL Server gives you is the ability to set ROWCOUNT which limits the numbers of records affected by a command. The default value is 0 which means all records, but this value can be set prior to running a command.
0 comments:
Post a Comment